Oracle Data Guard创建物理Standby数据库(三)
SIVE'
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
db_file_name_convert='/u01/app/oracle/oradata/a1','/u01/app/oracle/oradata/a1'
log_file_name_convert='/u01/app/oracle/oradata/a1/','/u01/app/oracle/oradata/a1'
STANDBY_FILE_MANAGEMENT=AUTO
[oracle@a2 a1]$ cp standby.ctl control01.ctl
[oracle@a2 a1]$ cp standby.ctl control02.ctl
[oracle@a2 a1]$ cp standby.ctl control03.ctl
11.确定监听，tns正常后，启动备库到mount状态
startup mount
12.备库上执行以下命令使备库自动应用已归档的日志
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
13.验证：
.在主备库上看当前已归档日志
SQL> select sequence#,first_time,next_time from v$archived_log order by sequence#;
如果主库的归档日志已传送到备机，并被备库成功就用，表示DATAGUARD已配置成功.