Oracle 11g Data Guard Broker操作笔记

页面导航:首页 > 数据库 > oracle > Oracle 11g Data Guard Broker操作笔记

Oracle 11g Data Guard Broker操作笔记

来源: 作者: 时间:2016-01-29 09:07 【

转载请注明出处:http: blog csdn net guoyjoe article details 41548669一、设置 1、设置broker

一、设置

1、设置broker

2、在主库上操作

DGMGRL> help

DGMGRL> help create

DGMGRL> CREATE CONFIGURATION c1 AS PRIMARY DATABASE IS PROD1 CONNECT IDENTIFIER IS PROD1;

DGMGRL> help add

DGMGRL> ADD DATABASE DG AS CONNECT IDENTIFIER IS DG;

DGMGRL> help enable

DGMGRL> ENABLE CONFIGURATION;

DGMGRL> help show

DGMGRL> SHOW CONFIGURATION;

 

SQL> startup open read only;

最好加一下read only,因为有时broker有时会把它拉回到mount状态!!!

SQL> select open_mode from v$database;

OPEN_MODE

SQL> select flashback_on from v$database;

FLASHBACK_ON

SQL> show parameter recovery

NAME TYPE VALUE

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database flashback on;

 


二、snapshot


1、主库

DGMGRL> help convert

DGMGRL> CONVERT DATABASE DG TO SNAPSHOT STANDBY; ---如果这里有失败可能是监听DG_DGMGRL没设

DGMGRL> SHOW CONFIGURATION;

2、备库

Table created.

SQL> insert into t1 values(1,'AAAA');

1 row created.

SQL> commit;

Commit complete.

 

 


三、还原到物理备库


1、主库

DGMGRL> CONVERT DATABASE DG TO PHYSICAL STANDBY; ---如果这里有失败可能是监听DG_DGMGRL没设

 

 

四、来回切换库


1、在主库PROD1上操作

Configuration

Fast-Start Failover: DISABLED

Current status for "c1":

DGMGRL> help switch

Switch roles between the primary database and a standby database

Syntax:

SWITCHOVER TO <standby database name>;

DGMGRL> SWITCHOVER TO DG;

Database dismounted.

DGMGRL> SHOW CONFIGURATION

Configuration

Fast-Start Failover: DISABLED

Current status for "c1":

DGMGRL> SWITCHOVER TO PROD1

Database dismounted.

 

 

五、修改传输模式

 

DGMGRL> SHOW DATABASE VERBOSE PROD1

DGMGRL> help edit

DGMGRL> EDIT DATABASE PROD1 SET PROPERTY LogXptMode=SYNC; ---主库

Failed.

DGMGRL> EDIT DATABASE PROD1 SET PROPERTY LogXptMode=SYNC; ---主库

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability; ---主库

以上Error: ORA-16627: 错误马上消失。。。。

++++备库的一些基本命令可以记下:

Database altered.

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open;

Database altered.

 

 

 

六、故障切换


1、主库

DGMGRL> ENABLE FAST_START FAILOVER;

2、备库

DGMGRL> help start

DGMGRL> START OBSERVER

3、主库

4、备库

17:05:29.04 Friday, November 21, 2014

(2)stop observer(观察到上面的信息就停止掉,以防来回切换)

5、主库

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Nov 21 17:10:14 2014

Copyright (c) 1982, 2008, . All rights reserved.

Connected to an idle instance.

SQL> startup mount;

Total System Global Area 418484224 bytes

6、切回去

Configuration

Fast-Start Failover: ENABLED

Current status for "c1":

DGMGRL> SWITCHOVER TO PROD1

Failed.

DGMGRL> DISABLE FAST_START FAILOVER;

Failed.

DGMGRL> SHOW CONFIGURATION;

Configuration

Fast-Start Failover: DISABLED

Current status for "c1":

 

DGMGRL> switchover to prod1; ----------------------------------->这个错误的一般出现在VM中。。。
Performing switchover NOW, please wait...

Failed.

 

Current status for "prod1":

 

Database dismounted.

Configuration

Fast-Start Failover: DISABLED

Current status for "c1":

 

Database dismounted.

DGMGRL> show configuration;

Configuration

Fast-Start Failover: DISABLED

Current status for "c1":

Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<