Saturday, June 25, 2016

DownGrade Integrated Replicat to Classic Replicat GoldenGate

scenario # I am bringing Integrated replicat down and converting back to classic replicat. Steps as follows ### 

STEP1 #
GGSCI (red.gg.ora.com) 4> dblogin userid ggsuser@mldb69, password oracle
Successfully logged into database.

STEP 2 #
GGSCI (red.gg.ora.com) 22> stop rmots

STEP 3 #
GGSCI (red.gg.ora.com) 21> info checkpointtable ggsuser.ckptab
Checkpoint table ggsuser.ckptab created 2016-06-21 01:17:44.

STEP 4 #
GGSCI (red.gg.ora.com) 8> alter replicat rmots, nonintegrated checkpointtable ggsuser.ckptab
REPLICAT (Integrated) altered.

STEP 5 # 
GGSCI (red.gg.ora.com) 9> start replicat rmots
Sending START request to MANAGER ...
REPLICAT RMOTS starting

After restart you will see following report in the report file of replicat # 
Opened trail file /u01/app/goldengate/dirdat/aa000009 at 2016-06-25 00:25:32
2016-06-25 00:25:53  INFO    OGG-02529  Successfully unregistered REPLICAT RMOTS inbound server OGG
$RMOTS from database.
2016-06-25 00:25:53  INFO    OGG-02525  Integrated Replicat has been unregistered.

2016-06-25 00:25:53  INFO    OGG-01407  Setting current schema for DDL operation to [SYS].
2016-06-25 00:25:53  INFO    OGG-01408  Restoring current schema for DDL operation to [ggsuser].
2016-06-25 00:25:53  INFO    OGG-01407  Setting current schema for DDL operation to [SYS].
2016-06-25 00:25:54  INFO    OGG-01408  Restoring current schema for DDL operation to [ggsuser].


--Nikhil Tatineni--
--Oracle In Memory--


Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...