探索Oracle 11gR2 DataGuard_02配置(四)
1: restoring datafile00004 to /DBData/Woo/Woo/users01.dbf
channel ORA_DISK_1: reading from backuppiece /DBBackup/Phycal/full_db_01o9j16h_1_1
channel ORA_DISK_1: piecehandle=/DBBackup/Phycal/full_db_01o9j16h_1_1 tag=TAG20130514T025617
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete,elapsed time: 00:00:13
Finished restore at 14-MAY-13
RMAN> ---至此恢复工作已经完成
八、在pri端应用接受归档日志文件
[sql]
SQL> ALTER SYSTEM SETLOG_ARCHIVE_DEST_STATE_2=ENABLE;
System altered.
九、再sty上启动日志应用
[sql]
SQL> alter database recover managedstandby database disconnect from session;
Database altered.
十、在sty端配置standby 日志，并使其进入active状态生效，通常需要重启一遍备库：
[sql]
SQL> alter database add standby logfile
group 4 ('/DBData/Woo/Woo/styredo04.log')size 50m,
group 5 ('/DBData/Woo/Woo/styredo05.log')size 50m,
group 6 ('/DBData/Woo/Woo/styredo06.log')size 50m,
group 7 ('/DBData/Woo/Woo/styredo07.log')size 50m;
SQL> SELECTGROUP#,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
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 839282688 bytes
Fixed Size 2217992 bytes
Variable Size 507512824 bytes
Database Buffers 327155712 bytes
Redo Buffers 2396160 bytes
Database mounted.
Database opened.
SQL> SELECTGROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;
GROUP# THREAD# SEQUENCE# ARC STATUS
---------- ---------- ---------- -------------
4 1 11 YES ACTIVE
5 1 0 NO UNASSIGNED
6 0 0 YES UNASSIGNED
7 0 0 YES UNASSIGNED
SQL>
十一、在pri端启动redo应用
[sql]
SQL> recover managed standby database usingcurrent logfile disconnect from session;
查看DG数据保护模式：
[sql]
SQL> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
附录：
十二、需修改添加的参数介绍:
角色
参数名称
介绍
Pri
DB_NAME
数据库名称，primary端和standby端相同
DB_UNIQUE_NAME
指定唯一名称，区别pri 端和 sty端
LOG_ARCHIVE_CONFIG
指定DG的全局日志配置，包含所有数据库的名称，及归档路径
CONTROL_FILES
控制文件路径及名称
LOG_ARCHIVE_DEST_n
指定主备库的归档路径
LOG_ARCHIVE_DEST_STATE_n
配置是否允许通过redo进行日志传输及路径
REMOTE_LOGIN_PASSWORDFILE
配置远程登陆模式，是否独享还是共享
LOG_ARCHIVE_FORMAT
配置归档日志文件存储格式规范
LOG_ARCHIVE_MAX_PROCESS=integer
配置归档进程数量，默认为4
FAL_SERVER
配置服务器角色
DB_FILE_NAME_CONVERT
配置数据库数据文件转换，用在主备库数据文件路径不一致
LOG_FILE_NAME,_CONVERT
配置数据库redo日志文件转换，用在主备库redo日志文件路径不一致
STANDBY_FILE_MANAGEMENT
配置备库是否同步主库的表空间添加或数据文件添加。
sty
DB_UNIQUE_NAME
指定唯一名称，区别pri 端和 sty端
CONTROL_FILES
控制文件路径及名称
DB_FILE_NAME,_CONVERT
配置数据库数据文件转换，用在主备库数据文件路