StandBy> select switchover_status from v$database; SWITCHOVER_STATUS --- NOT ALLOWED NOT ALLOWED是因为主库还未变切换为standby 二、primary数据库切换为物理standby Primary—>StandBy Primary>alter database commit to switchover to physical standby; Database altered. 此时Primary数据库变为mount状态 Primary...
A 如果switchover_status为TO_PRIMARY 说明标记恢复可以直接转换为primary库 SQL>alter database commit to switchover to primary B 如果switchover_status为SESSION ACTIVE 就应该断开活动会话 SQL>alter database commit to switchover to primary with session shutdown; C 如果switchover_status为NOT ALLOWED 说明...
SYS@dg1>select switchover_status from v$database; SWITCHOVER_STATUS --- TO PRIMARY ### 2.dg2上的操作:--切换为主库 SYS@dg2>select switchover_status from v$database; SWITCHOVER_STATUS --- TO PRIMARY SYS@dg2>alter database commit to switchover to primary; Database altered. SYS@dg2>exit...
select switchover_status from v$database; 详细过程如下: idle 2024-07-26 16:16:11> select switchover_status from v$database; SWITCHOVER_STATUS --- TO PRIMARY 4.2. 切换原备库至新主库 命令执行完,数据库实例处于mount状态 alter database commit to switchover to primary with session shutdown; ...
两个从库状态应该均为TO PRIMARY 或 SESSIONS ACTIVE,SESSIONS ACTIVE说明还有活跃会话。 select switchover_status from v$database; 1. 补充:如果发现not allowed状态 根据文档 Physical Standby Switchover_status Showing Not Allowed. (文档 ID 1392763.1),如果确定切换前主从是同步的,可以忽略Not Allowed 状态直接...
SWITCHOVER_STATUS --- TO PRIMARY 此时待转换的Standby库switchover_status列值应该是“TO PRIMARY“如果不是就需要检查初始化参数文件。 (3)切换备库到主库: 一旦切换到主库,数据库此时为mount状态 SQL> alter database commit to switchover to primary; (4)查数据库的角色: SQL>...
--同主库一样,SWITCHOVER_STATUS是to primary或session active就可以切换 selectNAME,DATABASE_ROLE,SWITCHOVER_STATUSfrom v$database; 执行切换(执行后为mounted状态) 代码语言:javascript 复制 alter database commit to switchover to primary;alter database commit to switchover to primarywithsession shutdown;...
SQL>alter database commit to switchover to primary with session shutdown; C 如果switchover_status為NOT ALLOWED 說明切換標記還沒收到,此時不能 執行轉換。 切換中 : 備用庫 SQL> select DATABASE_ROLE from v$database; DATABASE_ROLE --- PHYSICAL STANDBY SQL>...
再切换备库--->primary DB 备库mount状态下操作 成功!!! 20:52:21 SYS @ gotime >select name,database_role,protection_mode,switchover_status from v$database; NAME DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS --- --- --- --- SLOW PHYSICAL STANDBY MAXIMUM AVAILABILITY NOT ALLOWED 1 row ...
Database Role: Primary database Ready for Switchover: Yes Flashback Database Status: orcl: Off 1. 2. 3. 4. 5. 6. 7. 8. 3.验证物理备库 DGMGRL> validate database orcldg; Database Role: Physical standby database Primary Database: orcl ...