Problem Description
By default the PREPARE
command adds a table/schema into the replication from the SCN where MINE is currently running. The as of SCN
clause of the PREPARE
command allows you to add a table into the replication from an SCN number you specify.
Prerequisites
- MINE and APPLY must be on a SCN less than the SCN used in the
PREPARE as of <scn>
command. Therefore, pausing MINE & APPLY is required before executing thePREPARE as of <scn>
command. - There must be no open transactions on tables you want to add in the replication. Therefore: Lock table(s) on source, capture SCN and release lock.
Steps Performed
- In the replication console execute
pause MINE
andpause APPLY
commands. - Lock table(s) on source, capture SCN and release lock.
- Execute
prepare as of <SCN> table schema1.table1
command in console. - Resume MINE.
- Import/export the table from source to target using
flashback_scn=<SCN>.
- Resume APPLY.
Krupesh Desai October 29, 2014 12:26
Comments