select OPEN_MODE,PROTECTION_MODE,PROTECTION_LEVEL,SWITCHOVER_STATUS from v$database; 此时查看备库,switchover_status是否为to primary状态,如果是,则可以正常切换。 如果switchover_status是not allowed,则说明主库进行switchover有问题,重新运行上面语句。 原主库(A)以备机模式挂载数据库 alter database mount s...
SWITCHOVER_STATUS为NOT ALLOWED: 解决方案:检查告警日志,通常是因为主备库的数据没有完全同步。可能需要使用RMAN重置备库的化身(incarnation)与主库保持一致。 sql RMAN> RESET DATABASE TO INCARNATION <incarnation_id>; SWITCHOVER_STATUS为FAILED DESTINATION: 解决方案:检查告警日志,通常是因为监听...
select recovery_mode from v$archive_dest_status where dest_id=2; 4、检查备库状态 select switchover_status from v$database; --发现状态not allowed 3、看看进程MRP是否存在 ps aux|grep mrp --发现进程不存在 4、如果不存在执行以下: alter database recover managed standby database using current logfil...
SWITCHOVER_STATUS为NOT ALLOWED,这是备库的正常状态。 在主库首先切换后,我们再查询备库状态会发现SWITCHOVER_STATUS有改变 2、对主库进行切换 SQL> alter database commit to switchover to physical standby with session shutdown; 此时主库已经开始切换到备库的过程了,而备库的SWITCHOVER_STATUS已经变成TO PRI...
select OPEN_MODE,PROTECTION_MODE,PROTECTION_LEVEL,SWITCHOVER_STATUS from v$database; 此时查看备库,switchover_status是否为to primary状态,如果是,则可以正常切换。 如果switchover_status是not allowed,则说明主库进行switchover有问题,重新运行上面语句。
SWITCHOVER_STATUS为NOT ALLOWED,这是备库的正常状态。 在主库首先切换后,我们再查询备库状态会发现SWITCHOVER_STATUS有改变 2、对主库进行切换 SQL> alter database commit to switchover to physical standby with session shutdown; 此时主库已经开始切换到备库的过程了,而备库的SWITCHOVER_STATUS已经变成TO PRI...
STATUS GAP_STATUS --- --- VALID NO GAP 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 2.执行切换 检查主库(ruiadg1)是否支持Switchover操作: SQL> select switchover_status from v$database; SWITCHOVER_STATUS --- TO STANDBY 1. 2...
not allowed-PHYSICAL STANDBY- EAD ONLY-MAXIMUM PERFORMANCE 步骤4:在主服务器上设置逻辑备用参数 --查看数据库状态 SQL> set line 300 SQL> SELECT SWITCHOVER_STATUS,DATABASE_ROLE,OPEN_MODE,PROTECTION_MODE FROM V$DATABASE; SWITCH_STATUS DATABASE_ROLE OPEN_MODE PROTECTION_MODE ...
SWITCHOVER_STATUS FLASHBACK_ON--- --- --- --- --- --- ---BJZZSKP PHYSICAL STANDBY READ ONLY WITH APPLY MAXIMUM PERFORMANCE ENABLED NOT ALLOWED NO 查询同步延迟 set pagesize 20;column name format a13;column value format a20;column unit format a30;column TIME_COMPUTED format a30;select n...
switchover_status from v$database; select database_role,switchover_status from v$database * ERROR at line 1: ORA-01507: database not mounted SQL> select * from test0001; select * from test0001 * ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views ...