ORACLE 11g rac+单实例数据库构建dataguard(五)
e copy RECID=5 STAMP=823299518 filename=/u01/oradata/racdg/undotbs2.263.818615365
datafile 5 switched to datafile copy
input datafile copy RECID=6 STAMP=823299518 file name=/u01/oradata/racdg/users.264.818615419
Finished Duplicate Db at 12-AUG-13
五、打开DG，检测是否可用
11.打开备库，此时DG处于最大性能模式
可以通过select protection_mode,database_role,open_mode from v$database;在主备库上进行验证当前DG模式
同时可以在备库上alter database recover managed standby database disconnect fromsession;此时DG可以正常运行。
这里就不演示查询结果了，因为我在下面一步要配置DG为最大可用模式。
12.配置为最大可用模式
在备库要创建STANDBY REDO LOGFILE。所要创建在的目录当然要先存在了。
使用的语句如下：
alter database add standby logfile group 5'/u01/oradata/racdg/standbyredo/standbyredo05.log' size 50M;
alter database add standby logfile group 6'/u01/oradata/racdg/standbyredo/standbyredo06.log' size 50M;
alter database add standby logfile group 7'/u01/oradata/racdg/standbyredo/standbyredo07.log' size 50M;
alter database add standby logfile group 8'/u01/oradata/racdg/standbyredo/standbyredo08.log' size 50M;
alter database add standby logfile group 9'/u01/oradata/racdg/standbyredo/standbyredo09.log' size 50M;
BYS@racdg>select member from v$logfile;
MEMBER
----------------------------------------------------------------------------------------------------
/u01/oradata/racdg/group_1.257.818615137
/u01/oradata/racdg/group_1.257.818615145
/u01/oradata/racdg/group_2.258.818615153
/u01/oradata/racdg/group_2.258.818615163
/u01/oradata/racdg/group_3.265.818619941
/u01/oradata/racdg/group_3.259.818619949
/u01/oradata/racdg/group_4.266.818619961
/u01/oradata/racdg/group_4.260.818619967
/u01/oradata/racdg/standbyredo/standbyredo05.log
/u01/oradata/racdg/standbyredo/standbyredo06.log
/u01/oradata/racdg/standbyredo/standbyredo07.log
/u01/oradata/racdg/standbyredo/standbyredo08.log
/u01/oradata/racdg/standbyredo/standbyredo09.log
在主库验证DG工作模式并修改保护模式为最大可用
22:44:28 SYS@bysrac1>selectprotection_mode,database_role,open_mode from v$database;
PROTECTION_MODE DATABASE_ROLE OPEN_MODE
-------------------- ---------------- --------------------
MAXIMUM PERFORMANCE PRIMARY READ WRITE
22:47:13 SYS@bysrac1>show parameter log_archive_dest_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string SERVICE=racdgLGWR SYNC VALID
_FOR=(ONLINE_LOGFILES,PRIMARY_
ROLE) DB_UNIQUE_NAME=racdg
22:48:52 SYS@bysrac1>shutdown immediate;
22:50:00 SYS@bysrac1>startup mount;
ORACLE instance started.
Total System Global Area 740724736 bytes
Fixed Size 1339092 bytes
Variable Size 549454124bytes
Database Buffers 184549376 bytes
Redo Buffers 5382144 bytes
Database mounted.
22:52:31 SYS@bysrac1>alter database set standbydatabase to maximize availability;
Database altered.
22:53:48 SYS@bysrac1>alter database open;
Database altered.
22:55:56 SYS@bysrac1>select protection_mode,database_role,open_mode fromv$database;
PROTECTION_MODE DATABASE_ROLE OPEN_MODE
-------------------- ---------------- ------------