oracle/oradata/orcl/gaojf3db.dbf
restoring datafile fno=00010 name=/free/oracle/oradata/orcl/cicrodb1.dbf
restoringdatafile fno=00011 name=/free/oracle/oradata/orcl/cicrodb11.dbf
restoring datafile fno=00009 name=/free/oracle/oradata/orcl/gaojf4db.dbf
restoringdatafilefno=00002name=/free/oracle/oradata/orcl/undotbs01.dbf
restoring datafile fno=00005 name=/free/oracle/oradata/orcl/gaojfdb.dbf
restoring datafile fno=00004 name=/free/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 06-DEC-06
channel ORA_DISK_1: finished piece 1 at 06-DEC-06
piecehandle=/free/oracle/full_ORCL_20061206_37tag=TAG20061206T101027 comment=NONE
channel ORA_DISK_1: restore complete, elapsed time: 00:03:15
Finished restore at 06-DEC-06
13.将备库置于自动恢复状态
SQL> alter database recover managed standby database disconnect from session;
Database altered.
14.在主库上执行检查
SQL> conn /as sysdba
Connected.
SQL> select dest_name,status,error from v$archive_dest;
DEST_NAME STATUS ERROR
------------------------------ -------- ----------
LOG_ARCHIVE_DEST_1 VALID
LOG_ARCHIVE_DEST_2 VALID
LOG_ARCHIVE_DEST_3 INACTIVE
LOG_ARCHIVE_DEST_4 INACTIVE
LOG_ARCHIVE_DEST_5 INACTIVE
LOG_ARCHIVE_DEST_6 INACTIVE
LOG_ARCHIVE_DEST_7 INACTIVE
LOG_ARCHIVE_DEST_8 INACTIVE
LOG_ARCHIVE_DEST_9 INACTIVE
LOG_ARCHIVE_DEST_10 INACTIVE
10 rows selected.
SQL> select * from v$archive_gap;
no rows selected
SQL> select sequence# from v$log_history;
SEQUENCE#
----------
1
2
...
303
15.在备库上执行检查
SQL> conn / as sysdba
Connected.
SQL> select * from v$archive_gap;
no rows selected
SQL> select sequence# from v$log_history;
SEQUENCE#
----------
1
2
...
303
SQL> select sequence#,applied from v$archived_log;
SEQUENCE# APPLIE
---------- ------
295 YES
296 YES
297 YES
298 YES
299 YES
300 YES
301 YES
302 YES
303 YES
SQL> select process,status from v$managed_standby;
PROCESS STATUS
------------------ ------------------------
ARCH CLOSING
ARCH CLOSING
RFS IDLE
MRP0 WAIT_FOR_LOG
本文出自 “技术成就梦想” 博客