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 #
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--