11g OCM备考6——DG搭建（2）

1. 打开备库，能够提供实时查询

sta端 

alter database open; SQL> select open_mode from v$database; OPEN_MODE -------------------- READ ONLY WITH APPLY     DGMGRL> show database verbose standby;   Database - standby     Role:            PHYSICAL STANDBY   Intended State:  APPLY-ON   Transport Lag:   0 seconds   Apply Lag:       0 seconds   Real Time Query: ON   Instance(s):     standby

 

2. 启用块修改跟踪

alter database enable block change tracking using file '/home/oracle/blk_chg.tra';   SQL> select status from v$block_change_tracking; STATUS ---------- ENABLED   SQL> select filename from v$block_change_tracking; FILENAME -------------------------------------------------------------------------------- /home/oracle/blk_chg.tra

 

3. convert 使用

将standby转换成快照数据库，可以用来测试用 DGMGRL> CONVERT DATABASE standby to SNAPSHOT STANDBY; GMGRL> show configuration;   Configuration - c1     Protection Mode: MaxPerformance   Databases:     woods   - Primary database     standby - Snapshot standby database   Fast-Start Failover: DISABLED   Configuration Status: SUCCESS   CONVERT DATABASE standby to PHYSICAL STANDBY;

 

4. 主备库切换

switchover

DGMGRL> SWITCHOVER TO standby;   DGMGRL> show configuration;   Configuration - c1     Protection Mode: MaxPerformance   Databases:     standby - Primary database     woods   - Physical standby database   Fast-Start Failover: DISABLED   Configuration Status: SUCCESS   SWITCHOVER TO woods;

 

 

5. 设置归档日志保留策略

rman target / CONFIGURE ARCHIVELOG DELETION POLICY TO shipped to standby; 会有这个报错：RMAN-08591: WARNING: invalid archived log deletion policy alter system set "_log_deletion_policy"=ALL scope=spfile ; 重启一下主库，再重新配置rman参数，就不会报错了

 

6. 配置Fast-start Failover

 

（1）主备库都启动快速闪回 alter database flashback on; （备库在应用日志，启动不了，可以先取消日志应用，启动闪回后再开启日志应用： alter database recover managed standby database cancel; alter database flashback on; alter database recover managed standby database using current logfile disconnect from session;）   （2）EDIT DATABASE woods SET PROPERTY FastStartFailoverTarget='standby'; （3）sta端      [oracle@sta ~]$ dgmgrl sys/oracle      DGMGRL> start observer; （4）DGMGRL> EDIT DATABASE woods SET PROPERTY FastStartFailoverTarget='standby'; DGMGRL> EDIT DATABASE woods SET PROPERTY LogXptMode='SYNC'; DGMGRL> EDIT DATABASE standby SET PROPERTY LogXptMode='SYNC'; DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability; （5）启动 DGMGRL> ENABLE FAST_START FAILOVER; Enabled. DGMGRL> show configuration;   Configuration - c1     Protection Mode: MaxAvailability   Databases:     woods   - Primary database     standby - (*) Physical standby database   Fast-Start Failover: ENABLED   Configuration Status: SUCCESS

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

转载于:http://blog.itpub.net/30935525/viewspace-2082389/