channel clone_default: deleting archive log(s)
archive log filename=/free/oracle/orabak/1_320_605985194.dbf recid=1 stamp=608645661
media recovery complete, elapsed time: 00:00:03
Finished recover at 08-12月-06
11.将备库置于自动恢复状态
SQL> alter database recover managed standby database disconnect from session;
Database altered.
12.在主库上执行检查
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#
----------
2
...
321
13.在备库上执行检查
SQL> conn / as sysdba
Connected.
SQL> select * from v$archive_gap;
no rows selected
SQL> select sequence# from v$log_history;
SEQUENCE#
----------
1
2
...
321
SQL> select sequence#,applied from v$archived_log;
SEQUENCE# APPLIE
---------- ------
320 YES
321 YES
SQL> select process,status from v$managed_standby;
PROCESS STATUS
------------------ ------------------------
ARCH CLOSING
ARCH CLOSING
RFS IDLE
MRP0 WAIT_FOR_LOG
至此，备库创建成功。
可以看到，使用rman的duplicate来创建备库，过程简洁了不少，无需在手动创建备库控制文件。
作者 “技术成就梦想”