Data instantiation can be done by creating a target database using the RMAN restore and recover command.This method is more suitable for data instantiation when almost every schema of the source database is to be replicated, and the source and target database databases are both Oracle. Once the target instance is ready, select a particular SCN to start replication from and restore and recover the target database up to that SCN. You can then run the setup wizard of Dbvisit Replicate to configure replication.
...
Following is a step-by-step illustrative example of using RMAN restore and recover command for data instantiation before configuring Dbvisit Replicate. Following The following environment is used in this example.
...
3. Backup archivelogs, these backups are used to restore target database up to the SCN 1007088SCN 1009189.
| No Format | ||
|---|---|---|
| ||
RMAN> backup archivelog all; Starting backup at 01/07/2013:14:02:41 current log archived using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=41 device type=DISK channel ORA_DISK_1: starting compressed archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=2 RECID=1 STAMP=819637105 input archived log thread=1 sequence=3 RECID=2 STAMP=819637137 input archived log thread=1 sequence=4 RECID=3 STAMP=819640946 input archived log thread=1 sequence=5 RECID=4 STAMP=819640961 channel ORA_DISK_1: starting piece 1 at 01/07/2013:14:02:42 channel ORA_DISK_1: finished piece 1 at 01/07/2013:14:02:45 piece handle=/backups/rman/REPTEST1_05odlek2_1_1 tag=TAG20130701T140242 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 Finished backup at 01/07/2013:14:02:45 |
...