DG之物理Standby的failover
来源:互联网 发布:时光软件金牌店铺 编辑:程序博客网 时间:2024/04/29 05:50
1.检查归档文件是否连续
ORCLPRE:
ORCLPRE_STD >startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
ORCLPRE_STD >select thread#,low_sequence#,high_sequence# from v$archive_gap;
no rows selected
若有记录,把列出的记录号对应的归档转换到待转换的Standby,不然数据会不一致。并加入数据字典(Alter database register physical logfile 'filespecl')
2.检查归档文件是否完整
ORCLPRE_STD >select distinct thread#,max(sequence#) over(partition by thread#) A from v$archived_log;
THREAD# A
---------- ----------
1 39
ORCLPDG:
ORCLPDG_PRI >startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
ORCLPDG_PRI >select distinct thread#,max(sequence#) over(partition by thread#) A from v$archived_log;
THREAD# A
---------- ----------
1 39
若最大序号不同,需要复制到待转换的Standby。
3.启动failover
ORCLPRE_STD >alter database recover managed standby database finish force;//force停止当前活动的RFS进程(RFS是REDO传输服务)。
Database altered.
4.切换物理Standby为Primary
ORCLPRE_STD >alter database commit to switchover to primary;
Database altered.
5.启动新的Primary
ORCLPRE_STD >select status from v$instance;
STATUS
------------
STARTED
ORCLPRE_STD >alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted
ORCLPRE_STD >shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
ORCLPRE_STD >startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
ORCLPRE_STD >select * from scott.test;
ID
----------
1
2
3
4
5
6
6 rows selected.
- DG之物理Standby的failover
- DG 物理Standby角色切换及Failover
- 物理standby的Failover
- DG之物理Standby的switchover转换
- 【DATAGUARD】物理dg的failover切换(六)
- 物理STANDBY的FAILOVER切换(失败切换)
- 一步一步学DataGuard(7)物理standby之failover
- 物理DG之Primary增删表空间(数据文件)对Standby的影响
- 逻辑Standby之failover
- 物理dg failover 后 system01.dbf 不一致
- DG物理standby主备库切换(swithover)
- DG(1)Performing a Failover to a Physical Standby Database
- DG Broker failover的过程
- 【DATAGUARD】物理dg配置客户端无缝切换 (八.2)--Fast-Start Failover 的配置
- 逻辑DG之Standby角色转换
- Oracle DG之--构建Physical Standby
- Oracle DG 之故障--standby dg 通讯错误
- oracle 之物理DG 创建
- mybatis --- 以接口的方式进行编程
- 去IOE真相:亚马逊BAT们,对传统IT的深刻颠覆
- Spring Resource通配符路径
- MFC 学习心得
- TraceView
- DG之物理Standby的failover
- discuz 开发笔记
- 第04周:项目四扩展:类;new,delete的运用;从文件读出;读入到文件
- sqlserver 和Oracle中 order by(排序)的区别
- JAVA URL用法:
- VC++ 调用C#DLL方法(备忘)
- Quartz入门
- 会用到的一些按钮样式
- C++类模板友元声明的几种情况