Procedure to sync the target database using Oracle Export / Import and flashback_scn option (4301229)

Procedure to sync the target database using Oracle Export / Import and flashback_scn option

Starting with Oracle 9i, it is possible to take an Export of a database which is consistent for a specified SCN.
This opens door for its use in conjunction with Shareplex to resync a target database, especially when the source database is constantly being accessed for changes by the users. The procedure does involve using SharePlex’s reconcile command.

General information.

The following steps are involved:

1. Flush from the Source to the target (i.e. on source at sp_ctrl> flush o.sourcesid queue <queue name>).

2. Begin an Export of the Source database with FLASHBACK_SCN option in database mode.

3. After the Export is finished on the Source, and after Post stops due to flush on the Target, compare the Source tables to the Target tables to make sure both are the same structure (no DDL changes have occurred).

4. Import the data into the Target database.

5. Disable any triggers or constraints (except PK or U type) on target tables.

6. Run reconcile on the Post queue(s) using SCN option and use the same SCN+1  as was used in step 2.

7. Start Post on target.