Oracle 11.2.0.4.0 Dataguard部署和日常维护(5)-Datauard 主备切换和故障转移篇

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Oracle 11.2.0.4.0 Dataguard部署和日常维护(5)-Datauard 主备切换和故障转移篇，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含5037字，纯文字阅读大概需要8分钟。

内容图文

sequence#,first_time,next_time,archived,applied from v$archived_log where SEQUENCE#=(select max(SEQUENCE#) from v$archived_log); SEQUENCE# 　　FIRST_TIME 　 NEXT_TIME 　　　　 ARCHIVED 　　 APPLIED ---------- 　　------------------- 　　------------------- 　　--------- 　　 --------------------------- 51 　　　　2017-07-03 22:00:41 　　 2017-07-04 17:04:55 　　YES IN-MEMORY select sequence#,first_time,next_time,archived,applied from v$archived_log where SEQUENCE#=(select max(SEQUENCE#) from v$archived_log); SEQUENCE# FIRST_TIME NEXT_TIME ARCHIVED APPLIED ---------- ------------------- ------------------- --------- --------------------------- 51 2017-07-03 22:00:41 2017-07-04 17:04:55 YES IN-MEMORY select PROCESS,SEQUENCE#,STATUS from v$managed_standby; PROCESS 　　　　SEQUENCE# 　　STATUS --------------------------- ---------- ------------------------------------ ARCH 　　47 　　　　　　CLOSING ARCH 　　50 　　　　　　CLOSING ARCH 　　0 　　　　 CONNECTED ARCH 　　51 　　　　　　CLOSING RFS 　　 0 IDLE RFS 　　 52 　　　　　　IDLE RFS 　　 0 　　　　　　IDLE MRP0 　　52 　　　　　　APPLYING_LOG

 

 

•  on master

select SEQUENCE#,STATUS from v$log order by SEQUENCE#;

 SEQUENCE# 　　STATUS
---------- ------------------------------------------------
    50 　　　　INACTIVE
    51 　　　　INACTIVE
    52 　　　　CURRENT

column DATABASE_ROLE format a20
column OPEN_MODE format a15
column PROTECTION_MODE format a20
column SWITCHOVER_STATUS format a20
select DATABASE_ROLE,OPEN_MODE,PROTECTION_MODE,SWITCHOVER_STATUS from v$database;

DATABASE_ROLE         OPEN_MODE       PROTECTION_MODE      SWITCHOVER_STATUS
-------------------- --------------- -------------------- --------------------
PRIMARY          　　  READ WRITE      MAXIMUM PERFORMANCE  TO STANDBY

 

 

  1.2. 将主库转换为备库

alter database commit to switchover to physical standby with session shutdown;
startup mount;
alter database recover managed standby database using current logfile disconnect from session;
select DATABASE_ROLE,OPEN_MODE,PROTECTION_MODE,SWITCHOVER_STATUS from v$database;

DATABASE_ROLE         OPEN_MODE        PROTECTION_MODE      SWITCHOVER_STATUS
-------------------- --------------- -------------------- --------------------
PHYSICAL STANDBY      MOUNTED          MAXIMUM PERFORMANCE  TO PRIMARY

 

  1.3. 将备库转换为主库

column DATABASE_ROLE format a20
column OPEN_MODE format a15
column PROTECTION_MODE format a20
column SWITCHOVER_STATUS format a20
select DATABASE_ROLE,OPEN_MODE,PROTECTION_MODE,SWITCHOVER_STATUS from v$database;

DATABASE_ROLE        OPEN_MODE       PROTECTION_MODE      SWITCHOVER_STATUS
-------------------- --------------- -------------------- --------------------
PHYSICAL STANDBY     MOUNTED         MAXIMUM PERFORMANCE  TO PRIMARY

alter database commit to switchover to primary;
alter database open;
select DATABASE_ROLE,OPEN_MODE,PROTECTION_MODE,SWITCHOVER_STATUS from v$database;

DATABASE_ROLE        OPEN_MODE      PROTECTION_MODE       SWITCHOVER_STATUS
-------------------- --------------- -------------------- --------------------
PRIMARY              READ WRITE     MAXIMUM PERFORMANCE   TO STANDBY

 

  1.4. 测试主备数据同步状态

• on primary

select sequence#,first_time,next_time,archived,applied from v$archived_log where SEQUENCE#=(select max(SEQUENCE#) from v$archived_log);

 SEQUENCE# FIRST_TIME          NEXT_TIME       　　 ARCHIVED  APPLIED
---------- ------------------- ------------------- --------- ---------------------------
    54 　　2017-07-05 02:30:34 2017-07-05 02:30:40  YES       NO
    54 　　2017-07-05 02:30:34 2017-07-05 02:30:40  YES       YES

alter system archive log current;
alter system archive log current;

select sequence#,first_time,next_time,archived,applied from v$archived_log where SEQUENCE#=(select max(SEQUENCE#) from v$archived_log);

 SEQUENCE# FIRST_TIME           NEXT_TIME          ARCHIVED  APPLIED
---------- ------------------- ------------------- --------- ---------------------------
    56 　　2017-07-05 02:40:01  2017-07-05 02:40:03 YES       NO
    56 　　2017-07-05 02:40:01  2017-07-05 02:40:03 YES       NO

 

• on standby

select sequence#,first_time,next_time,archived,applied from v$archived_log where SEQUENCE#=(select max(SEQUENCE#) from v$archived_log);

 SEQUENCE# FIRST_TIME          NEXT_TIME           ARCHIVED  APPLIED
---------- ------------------- ------------------- --------- ---------------------------
    56     2017-07-05 02:40:01 2017-07-05 02:40:03 YES       IN-MEMORY

 

2. dataguard故障转移

  2.1. 前提:主库已经挂掉

  2.2. 将备库强制转换为主库

  2.3. 重建备库

Oracle 11.2.0.4.0 Dataguard部署和日常维护(5)-Datauard 主备切换和故障转移篇

标签：lte   sequence   role   active   roc   mod   over   转换   cti   

本文系统来源：http://www.cnblogs.com/ilifeilong/p/7122670.html

内容总结

以上是互联网集市为您收集整理的Oracle 11.2.0.4.0 Dataguard部署和日常维护(5)-Datauard 主备切换和故障转移篇全部内容，希望文章能够帮你解决Oracle 11.2.0.4.0 Dataguard部署和日常维护(5)-Datauard 主备切换和故障转移篇所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---