当前位置：首页 -> AI编程基础 -> 数据库编程

最简单的11gActiveDataGuard(ADG)搭建配置过程（项目步(九)

2015-11-21 01:57:03 · 作者: · 浏览: 45
标签: 简单 11gActiveDataGuard ADG 搭建 配置 过程 项目
3 insert into test001 values (1,'ww'); 4 end loop; 5 end; 6 / PL/SQL procedure successfully completed. SQL> commit; Commit complete. #standby端查询scott用户是否解锁，以及test001表是否创建并且插入了10000行数据： SQL> conn scott/tiger; Connected. SQL> select * from tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- BONUS TABLE DEPT TABLE EMP TABLE SALGRADE TABLE TEST001 TABLE SQL> select count(*) from test001; COUNT(*) ---------- 10000 SQL>
#至此Oracle 11g ADG就已经配置完成了
四、ADG三种模式切换及介绍

14、#ADG有三种(PROTECTION|AVAILABILITY|PERFORMANCE)模式，具体参考:探索Oracle11gR2 之 DataGuard_03 三种保护模式

--primary操作步骤也就是命令之差：
SQL> select database_role,protection_mode,protection_level from v$database;    ----当前为最大性能

DATABASE_ROLE    PROTECTION_MODE      PROTECTION_LEVEL
---------------- -------------------- --------------------
PRIMARY          MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE

SQL> 
SQL> alter database set standby database to maximize availability;            ----切换为最大可用

Database altered.

SQL> select database_role,protection_mode,protection_level from v$database;

DATABASE_ROLE    PROTECTION_MODE      PROTECTION_LEVEL
---------------- -------------------- --------------------
PRIMARY          MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY

SQL> alter database set standby database to maximize protection;            ----切换为最大保护   

Database altered.

SQL> select database_role,protection_mode,protection_level from v$database;

DATABASE_ROLE    PROTECTION_MODE      PROTECTION_LEVEL
---------------- -------------------- --------------------
PRIMARY          MAXIMUM PROTECTION   MAXIMUM PROTECTION

SQL>


--#standby端切换到最大保护是需要重启数据库到mount模式的:
SQL> select database_role,protection_mode,protection_level from v$database;    ----当前为最大性能

DATABASE_ROLE    PROTECTION_MODE      PROTECTION_LEVEL
---------------- -------------------- --------------------
PHYSICAL STANDBY MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE

SQL> alter database set standby database to maximize availability;            ----切换为最大可用

Database altered.

SQL> select database_role,protection_mode,protection_level from v$database;

DATABASE_ROLE    PROTECTION_MODE      PROTECTION_LEVEL
---------------- -------------------- --------------------
PHYSICAL STANDBY MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY

SQL> alter database set standby database to maximize protection;            ----切换为最大保护模式报错，需要将standby端启动到mount状态切换.
alter database set standby database to maximize protection
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any instance


SQL> shutdown immediate                                                     ----将数据库启动到mount状态
Database closed.
Database dismounted.
ORACLE instance shut down. 

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1188511744 bytes
Fixed Size                  1364228 bytes
Variable Size             754978556 bytes
Database Buffers          419430400 bytes
Redo Buffers               12738560 bytes
Database mounted.

SQL> alter database set standby database to maximize protection;            ----再次切换为最大可用，成功。

Database altered.

SQL> recover managed standby database using current logfile disconnect from session;
Media recovery complete.

SQL> select database_role,protection_mode,protection_level from v$database;

DATABASE_ROLE    PROTECTION_MODE      PROTECTION_LEVEL
---------------- -------------------- --------------------
PHYSICAL STANDBY MAXIMUM PROTECTION   MAXIMUM PROTECTION

五、切换测试

15、ADG做(swit