v$database Switchover_Status值的含义 NOT ALLOWED 当前的数据库不是带有备用数据库的主数据库, 主库关闭前为“NOT ALLOWED”,关闭后从库变为“TO_PRIMARY” PREPARING DICTIONARY 该逻辑备用数据库正在向一个主数据库和其他备用数据库发送它的重做数据,以便为切换做准备 ...
SWITCHOVER LATENT –The switchover was in pending mode, but did not complete and went back to the primary database. TO PRIMARY –This is a standby database, with no active sessions, that is allowed to switch over to a primary database. TO STANDBY –This is a primary database, with no...
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> select OPEN_MODE,PROTECTION_MODE,PROTEC...
Before we initiate the switchover, we check the synchronization status between primary and physical standby. They are in perfect sync. Physical standby has applied the lastly generated archived redo log sequence. But in physical standby v$database.switchover_status shows "not allowed"...
SWITCHOVER_STATUS NOTALLOWED-Onaprimarydatabase,thisstatusindicatesthattherearenovalidandenabledstandbydatabases.Onastandbydatabase,thisstatusindicatesthataswitchoverrequesthasnotbeenreceivedfromtheprimarydatabase. SESSIONSACTIVE-Thedatabasehasactivesessions.Onaphysicalstandbydatabase,theWITHSESSIONSHUTDOWNSQLclausemust...
PDG MOUNTED PHYSICAL STANDBY NOT ALLOWED SQL> select instance_name from v$instance; INSTANCE_NAME --- sdg 第二步、在primary庫上執行切換 primay庫上執行切換 SQL> alter database commit to switchover to physical standby; Database altered. 在執行切換的過程正式開始之前...
NOT ALLOWED 当前的数据库不是带有备用数据库的主数据库 PREPARING DICTIONARY 该逻辑备用数据库正在向一个主数据库和其他备用数据库发送它的重做数据,以便为切换做准备 PREPARING SWITCHOVER 接受用于切换的重做数据时,逻辑备用配置会使用它 RECOVERY NEEDED
NAME DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS --- --- --- --- RMANPRI PHYSICAL STANDBY MAXIMUM PERFORMANCE NOT ALLOWED 解决。