?executing command: SET NEWNAME
?executing command: SET NEWNAME
?executing command: SET NEWNAME
?executing command: SET NEWNAME
?Starting backup at 17-JUN-15
?using channel ORA_DISK_1
?channel ORA_DISK_1: starting datafile copy
?input datafile file number=00001 name=/DBSoft/oracle/oradata/woo/system01.dbf
?output file name=/DBSoft/oracle/oradata/woo/system01.dbf tag=TAG20150617T223532
?channel ORA_DISK_1: datafile copy complete, elapsed time: 00:05:58
?channel ORA_DISK_1: starting datafile copy
?input datafile file number=00002 name=/DBSoft/oracle/oradata/woo/sysaux01.dbf
?output file name=/DBSoft/oracle/oradata/woo/sysaux01.dbf tag=TAG20150617T223532
?channel ORA_DISK_1: datafile copy complete, elapsed time: 00:05:30
?channel ORA_DISK_1: starting datafile copy
?input datafile file number=00003 name=/DBSoft/oracle/oradata/woo/undotbs01.dbf
?output file name=/DBSoft/oracle/oradata/woo/undotbs01.dbf tag=TAG20150617T223532
?channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
?channel ORA_DISK_1: starting datafile copy
?input datafile file number=00004 name=/DBSoft/oracle/oradata/woo/users01.dbf
?output file name=/DBSoft/oracle/oradata/woo/users01.dbf tag=TAG20150617T223532
?channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
?Finished backup at 17-JUN-15
?sql statement: alter system archive log current
?contents of Memory Script:
?{
? ? switch clone datafile all;
?}
?executing Memory Script
?datafile 1 switched to datafile copy
?input datafile copy RECID=1 STAMP=882658052 file name=/DBSoft/oracle/oradata/woo/system01.dbf
?datafile 2 switched to datafile copy
?input datafile copy RECID=2 STAMP=882658052 file name=/DBSoft/oracle/oradata/woo/sysaux01.dbf
?datafile 3 switched to datafile copy
?input datafile copy RECID=3 STAMP=882658052 file name=/DBSoft/oracle/oradata/woo/undotbs01.dbf
?datafile 4 switched to datafile copy
?input datafile copy RECID=4 STAMP=882658052 file name=/DBSoft/oracle/oradata/woo/users01.dbf
?Finished Duplicate Db at 17-JUN-15
#至此已经恢复完成
6、在primary 和standby端添加standby日志
SQL> alter database add standby logfile
?
group 4 ('/DBSoft/oracle/oradata/woo/styredo04.log') size 50m,
group 5 ('/DBSoft/oracle/oradata/woo/styredo05.log') size 50m,
group 6 ('/DBSoft/oracle/oradata/woo/styredo06.log') size 50m,
group 7 ('/DBSoft/oracle/oradata/woo/styredo07.log') size 50m;
SQL> SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;
? ? GROUP# THREAD# SEQUENCE# ARC STATUS
---------- ---------- ---------- --- ----------
? ? ? ? 4 0 0 YES UNASSIGNED
? ? ? ? 5 0 0 YES UNASSIGNED
? ? ? ? 6 0 0 YES UNASSIGNED
? ? ? ? 7 0 0 YES UNASSIGNED
7、在standby端开启实时日志应用
SQL> recover managed standby database using current logfile disconnect from session;
?
Media recovery complete.
SQL>