oracle 11g ADG做(switchover)切换测试
来源:互联网 发布:大型企业网络设计方案 编辑:程序博客网 时间:2024/05/29 12:56
- --primary 做如下操作
- SQL> alter database commit to switchover to physical standby;
- Database altered.
- SQL> shutdown immediate
- ORA-01012: not logged on
- SQL> conn / as sysdba
- Connected to an idle instance.
- SQL> startup
- ORACLE instance started.
- Total System Global Area 1188511744 bytes
- Fixed Size 1364228 bytes
- Variable Size 754978556 bytes
- Database Buffers 419430400 bytes
- Redo Buffers 12738560 bytes
- Database mounted.
- Database opened.
- SQL> alter database recover managed standby database disconnect from session;
- Database altered.
- SQL> select database_role,switchover_status from v$database;
- DATABASE_ROLE SWITCHOVER_STATUS
- ---------------- --------------------
- PHYSICAL STANDBY TO PRIMARY
- SQL>
- --standby 端做如下操作
- SQL> alter database commit to switchover to primary;
- Database altered.
- SQL> shutdown immediate
- ORA-01109: database not open
- Database dismounted.
- ORACLE instance shut down.
- SQL> startup
- ORACLE instance started.
- Total System Global Area 1188511744 bytes
- Fixed Size 1364228 bytes
- Variable Size 754978556 bytes
- Database Buffers 419430400 bytes
- Redo Buffers 12738560 bytes
- Database mounted.
- Database opened.
- SQL> alter system switch logfile;
- System altered.
- SQL> select database_role,switchover_status from v$database;
- DATABASE_ROLE SWITCHOVER_STATUS
- ---------------- --------------------
- PRIMARY SESSIONS ACTIVE
如果切换过程中发生ora-01093的错误,请参考
http://blog.csdn.net/yanfalee/article/details/50886570
0 0
- oracle 11g ADG做(switchover)切换测试
- 配置ORACLE 11G ADG
- Oracle 11g Data Guard之主备库切换(switchover不使用DG Broker)
- oracle 11g physical standby switchover
- oracle 11g physical standby switchover
- oracle 11g physical standby switchover steps
- Oracle 11g logical standby switchover
- oracle dataguard switchover切换
- ORACLE 11G ADG的STATSPACK性能报表配置方法
- Oracle 11G Active DataGuard(ADG)搭建配置过程
- Oracle 11g搭建DG(ADG方式)
- Oracle 11g Dataguard 配置,维护与详解 (ADG)
- Oracle Data Guard Switchover 切换
- Oracle Data Guard Switchover 切换
- Oracle Data Guard Switchover 切换
- Oracle 11g Dataguard SwitchOver 主备日志不一致
- Oracle 11g Data Guard Role Transitions: Switchover
- Oracle 11g Data Guard Broker Switchover Fast_start Failover
- 移动端H5各种各样的列表的制作方法(二) by FungLeo
- 死锁的原因、条件和避免死锁的方法
- C++第一次实验+1
- (一般)POJ-2718 DFS套DFS
- 64位 SSIS连接Oracle
- oracle 11g ADG做(switchover)切换测试
- java 垃圾收集器
- sublime text 3的初步配置
- mybatis入门到精通01
- Android将Log写入文件
- "此证书的签发者无效",系统认证证书(AppleWWDRCA.cer)过期或删除
- Android判断asset中是否存在某个文件
- webapp开发技巧
- 链表的游标实现