This is an old revision of the document!

After the duplication is done, the database will be opened with resetlogs up to the SCN which we recorded up: 474514374

DO NOT CHANGE ANY DATA

Be sure to delete any running job on the destination server

GGSCI (destinSRV) 1> info all  

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                            
JAGENT      STOPPED                                            
REPLICAT    RUNNING     REP1        00:00:00      00:00:02  

GGSCI (destinSRV) 1> dblogin userid ggate password izola
Successfully logged into database.

GGSCI (destinSRV) 5> stop ibprep1

Sending STOP request to REPLICAT IBPREP1 ...
Request processed.

GGSCI (destinSRV) 2> cleanup ibprep1
Cleanup completed

GGSCI (destinSRV) 3> delete ibprep1
Deleted REPLICAT REP1.

Assure also that, you delete ALL retail files from the responding directory:

[oracle@destinationSRV dirdat]$ ls -lart
total 8
drwxr-xr-x 29 oracle oinstall 4096 Nov 14 14:35 ..
drwxr-x---  2 oracle oinstall 4096 Jan 16 12:35 .

Once all have been cleared, create a REPLICAT job as follows:

GGSCI (destinSRV) 4> add replicat ibprep1, exttrail ./dirdat/rt, checkpointtable ggate.CKPTAB
REPLICAT added.

GGSCI (destinSRV) 5> start replicat ibprep1, aftercsn <scn obtained from restore preview above>

Sending START request to MANAGER ...
REPLICAT REP1 starting