allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
Crosschecked 7 objects
Finished implicit crosscheck backup at 21-JUL-14
Starting implicit crosscheck copy at 21-JUL-14
using channel ORA_DISK_1
Finished implicit crosscheck copy at 21-JUL-14
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/app/oracle/oradata/ORCL/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/ORCL/sysaux01.dbf
restoring datafile 00006 to /u01/app/oracle/oradata/ORCL/ogg01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/bak/bk_23_1_853515593
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/bak/bk_23_1_853515593 tag=HOT_DB_BK_LEVEL0
channel ORA_DISK_1: restore complete, elapsed time: 00:00:27
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/ORCL/system01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/ORCL/users01.dbf
restoring datafile 00005 to /u01/app/oracle/oradata/ORCL/example01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/bak/bk_22_1_853515593
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/bak/bk_22_1_853515593 tag=HOT_DB_BK_LEVEL0
channel ORA_DISK_1: restore complete, elapsed time: 00:00:46
Finished restore at 21-JUL-14
然后recover数据库到前边我们记录的SCN处：
RMAN>run
{
SET UNTIL SCN 484267;
RECOVER DATABASE;
}2> 3> 4> 5>
目标端查看此时SCN并打开数据库：
SQL> SELECT CHECKPOINT_CHANGE#,CHECKPOINT_TIME FROM V$DATAFILE_HEADER;
CHECKPOINT_CHANGE# CHECKPOIN
------------------ ---------
484267 21-JUL-14
484267 21-JUL-14
484267 21-JUL-14
484267 21-JUL-14
484267 21-JUL-14
484267 21-JUL-14
6 rows selected.
SQL> alter database open resetlogs;
Database altered.
目标端启动Replicat进程：
GGSCI (edbjr2p2) 1>start repya ,afterscn 484267
此处使用的SCN是我们之前记录的SCN。因为数据文件恢复到了这个SCN，rman保证了这个SCN之前的源端和目标端库的数据一致性，OGG只要应用此SCN之后出现的数据变化即可。