ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 【RAC】启用 Active Dataguard on 11gR2 RAC Standby

【RAC】启用 Active Dataguard on 11gR2 RAC Standby

原创 Linux操作系统 作者:杨奇龙 时间:2012-06-24 21:55:45 0 删除 编辑
    对于已经建立的rac dataguard 环境,standby rac和主库对应拥有两个节点并且可以应在一个节点用日志!在此情况下 启用 ADG 特性
主库:rac1 rac2
备库: rac3 rac4
一 非dataguard·broker 情况下:
1. 日志已经在rac3上应用,所以只需在节点rac3上取消日志应用,注意:对于节点rac4 不用做任何操作!
rac3> alter database recover managed standby database cancel;
Database altered.
2. Since database added to cluster to startup default on mount mode with
打开数据库至 read only 模式,需要注意的是向集群添加节点的时候一般是以mount状态启动的,对于备库要以read only 方式打开!
在节点rac3上
rac3> alter database open read only;
Database altered.
rac3> select open_mode from v$database;
OPEN_MODE
---------
READ ONLY
对节点rac3操作完之后,节点rac4依然是mounted状态
rac4>  select open_mode from v$database;
OPEN_MODE
---------
MOUNTED
以read only方式打开节点rac4的实例
rac4> alter database open read only;
Database altered.
rac4> select open_mode from v$database;
OPEN_MODE
---------
READ ONLY
3. 在一个节点上进行应用日志,执行如下命令:
rac3> alter database recover managed standby database using current logfile disconnect;
Database altered.
4. 在两个备库实例上查看数据库的打开方式:
rac3> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
rac4> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY

二 如果配置的dataguard broker,并且已经应用日志了,按照如下方法进行:
1.用dgmgrl 停止应用日志!
DGMGRL> edit database rac set state='APPLY-OFF';
Succeeded.
DGMGRL> show database rac

Database - rac

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-OFF
  Transport Lag:   0 seconds
  Apply Lag:       0 seconds
  Real Time Query: OFF
  Instance(s):
    rac1 (apply instance)
    rac2

Database Status:
SUCCESS
2. 进行非dataguard broker的第二步!
alter database open read only;

3. 使用 dgmgrl 重新开始应用日志!
DGMGRL> edit database rac set state='APPLY-ON';
Succeeded.

三 停止ADG
1. 取消日志应用!
rac3> alter database recover managed standby database cancel;
Database altered.
open_mode 将由 READ ONLY WITH APPLY 变为 READ ONLY
rac3> select open_mode from v$database;
OPEN_MODE
---------
READ ONLY

2. 关闭并重启standby 至mount状态!
srvctl stop database -d rac
srvctl start database -d rac
rac3> select open_mode from v$database;
OPEN_MODE
---------
MOUNTED
3. 重新开启日志应用!
rac3> alter database recover managed standby database using current logfile disconnect;
Database altered.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22664653/viewspace-733690/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
MySQL DBA NoSQL DEVOPS

注册时间:2009-10-07

  • 博文量
    1026
  • 访问量
    7510993