GoldenGate 12.2 setup Uni-Directional Sync of some DB schemas with RMAN Active Duplicate Initial Load

Excuse my dust, work in progress… This blog demonstrates an Oracle GoldenGate 12.2 setup Uni-Directional Sync of a subset of schemas Oracle 12.2 DB with / using RMAN Active Duplicate for the “Initial Load” (initial GoldenGate load of the target).  The entire DB will be duplicated so we can replicate whatever schemas we choose. Assumptions: you…

RMAN duplicate using active RMAN technology

This blog demonstrates the use of an RMAN duplicate using “active” RMAN technology.  Active duplication is available with Oracle’s Enterprise Database product starting with 11gR2 forward 11.2.x.x.x, 12c etc. Basically “active duplicate” uses the control file and the currently open database as a source to clone / duplicate from – no backup is required.  It…

Oracle 12c RAC file type locations

# work in progress – excuse my dust Voting and OCR – shared device spfile – shared device control files – shared device – * or instance name can be specific to affect instances redo logs – read only sharing – writes take place to a dedicated instance thread undo segments – read only sharing…

Verify that EBS R12 processes are running on Unix

Unix Commands To Find Running R12 Processes: Apache ps -ef | grep -i apache Forms/Reports ps -ef | grep -i frmweb ps -ef | grep -i rwrun Concurrent Manager ps -ef | grep -i FNDLIB List all application services ps -ef | grep -i applmgr Port List Use the application context file, or use netstat…