datafile 1 switched to datafile copy input datafile copy RECID=19 STAMP=845008154 file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_system_27p5rj2m_.dbf datafile 2 switched to datafile copy input datafile copy RECID=20 STAMP=845008154 file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_sysaux_28p5rj2m_.dbf datafile 3 switched to datafile copy input datafile copy RECID=21 STAMP=845008154 file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_undotbs1_29p5rj2m_.dbf datafile 4 switched to datafile copy input datafile copy RECID=22 STAMP=845008154 file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_users_2ap5rj2m_.dbf Finished Duplicate Db at 16-APR-14

sql statement: alter system set log_archive_max_processes=5

sql statement: alter system set fal_client=dg1

sql statement: alter system set fal_server=dg2

sql statement: alter system set standby_file_management=AUTO

sql statement: alter system set log_archive_config=''dg_config=(dg1,dg2)''

sql statement: alter system set log_archive_dest_2=''service=dg2 lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=dg2''

sql statement: alter system set log_archive_dest_1=''location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles)''

sql statement: alter system archive log current

sql statement: alter database recover managed standby database using current logfile disconnect from session

released channel: ch1

released channel: ch2

released channel: ch3

released channel: ch4

released channel: ch5

released channel: ch6

released channel: ch7

released channel: ch8

RMAN>

验证如下：

在备库可以查看如下信息：

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- 1 1 35 52428800 512 1 YES CLEARING 1106799 16-APR-14 1106799 16-APR-14 3 1 34 52428800 512 1 YES CLEARING 1106413 16-APR-14 1105288 16-APR-14 2 1 35 52428800 512 1 YES CURRENT 1106799 16-APR-14 1104233 16-APR-14

SQL> select * from v$standby_log;

GROUP# DBID THREAD# SEQUENCE# BYTES BLOCKSIZE USED ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME LAST_CHANGE# LAST_TIME ---------- ---------------------------------------- ---------- ---------- ---------- ---------- ---------- --- ---------- ------------- --------- ------------ --------- ------------ --------- 4 1756848898 1 35 52428800 512 108544 YES ACTIVE 1106799 16-APR-14 1106904 16-APR-14 5 UNASSIGNED 1 0 52428800 512 0 NO UNASSIGNED 6 UNASSIGNED 0 0 52428800 512 0 YES UNASSIGNED 7 UNASSIGNED 0 0 52428800 512 0 YES UNASSIGNED

SQL> select process,status from v$managed_standby;

PROCESS STATUS --------- ------------ ARCH CLOSING ARCH CLOSING ARCH CONNECTED ARCH CONNECTED ARCH CONNECTED RFS IDLE MRP0 APPLYING_LOG RFS IDLE RFS IDLE RFS IDLE RFS IDLE

11 rows selected.

SQL>

注：在使用rman脚本的时候，非常要细心，或是因为一个单引号或是因为一个双引号缺失就会导致整个任务失败，对脚本要求比较严格。另外如何使用10G之前的rman方式，那么需要将全部备份集copy到备库，进而使用duplicate target database for standby dorecover nofilenamecheck；完成搭建。