ORACLE 11g rac+单实例数据库构建dataguard(六)
--------
MAXIMUM AVAILABILITY PRIMARY READ WRITE
###############################
备库上的操作：
22:58:17 SYS@racdg>shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
22:59:18 SYS@racdg>startup mount;
ORACLE instance started.
Total System Global Area 740724736 bytes
Fixed Size 1339092 bytes
Variable Size 436207916bytes
Database Buffers 297795584 bytes
Redo Buffers 5382144 bytes
Database mounted.
22:59:45 SYS@racdg>selectprotection_mode,database_role,open_mode from v$database;
PROTECTION_MODE DATABASE_ROLE OPEN_MODE
-------------------- ---------------- --------------------
MAXIMUM AVAILABILITY PHYSICAL STANDBY MOUNTED
这里我要使用了11G新特性ACTIVE STANDBY
SYS@racdg>alter database open;
Database altered.
SYS@racdg>set time on
23:01:06 SYS@racdg>select protection_mode,database_role,open_mode fromv$database;
PROTECTION_MODE DATABASE_ROLE OPEN_MODE
-------------------- ---------------- --------------------
MAXIMUM AVAILABILITY PHYSICAL STANDBY READ ONLY
使用 using current logfile参数启动实时恢复
23:01:08 SYS@racdg> alter database recover managedstandby database using current logfile disconnect from session;
Database altered.
23:02:05 SYS@racdg>select protection_mode,database_role,open_mode fromv$database;
PROTECTION_MODE DATABASE_ROLE OPEN_MODE
-------------------- ---------------- --------------------
MAXIMUM AVAILABILITY PHYSICAL STANDBY READ ONLY WITH APPLY
13.测试DG双方能否同步
切换日志，并做DML操作
SYS@racdg>selectsequence#,status,thread#,block# from v$managed_standby;
SEQUENCE# STATUS THREAD# BLOCK#
---------- ------------ ---------- ----------
168 CLOSING 1 1
166 CLOSING 1 1
0 CONNECTED 0 0
169 CLOSING 1 1
170 APPLYING_LOG 1 10
0 IDLE 0 0
0 IDLE 0 0
0 IDLE 0 0
170 IDLE 1 10
BYS@bysrac1>set time on
23:03:45 BYS@bysrac1>alter system switch logfile;
System altered.
23:03:53 BYS@bysrac1>select sequence#,status,thread#,block# fromv$managed_standby;
SEQUENCE# STATUS THREAD# BLOCK#
---------- ------------ ---------- ----------
166 CLOSING 1 1673
164 CLOSING 1 1
169 CLOSING 1 1
168 CLOSING 1 1
170 WRITING 1 26
在主库中创建一个新表
23:06:49 BYS@bysrac1>create table test(a varchar2(10));
Table created.
23:07:12 BYS@bysrac1>select * from test;
no rows selected
在备库中立刻就可以查到这个新表已经存在。
23:08:01 SYS@racdg>conn bys/bys
Connected.
23:08:24 BYS@racdg>select * from test;
no rows selected