There are no errors and no gaps anywhere except from the switchover status. I've tried restarting the redo apply services on the physical standby and switched log files various times. I'm not sure how to get from RESOLVABLE GAP to TO STANDBY....
SWITCHOVER_STATUS --- UNRESOLVABLEGAP standby： SQL>selectswitchover_statusfromv$database; SWITCHOVER_STATUS --- RECOVERYNEEDED 但是主备库之间是通的，也就是主库切换一个日志可以传输到备库上，但是没有应用 查看日志应用情况 SQL>SELECTSEQUENCE#,APPLIEDFROMV$ARCHIVED_LOGORDERBYSEQUENCE#; SEQUENC...
按照正常操作,先切换现在的主库102成从库,当操作完成的时候,101的 SWITCHOVER_STATUS就成 to_primary也就是说可以切换成主库了。 现在的主库102上执行: sql> select SWITCHOVER_STATUS,DATABASE_ROLE from V$DATABASE; --RESOLVABLE GAP PRIMARY 检查alert日志发现ora-00312错误,删除错误的log日志,后状态为TO ST...
按照正常操作,先切换现在的主库102成从库,当操作完成的时候,101的 SWITCHOVER_STATUS就成 to_primary也就是说可以切换成主库了。 现在的主库102上执行: sql> select SWITCHOVER_STATUS,DATABASE_ROLE from V$DATABASE; --RESOLVABLE GAP PRIMARY 检查alert日志发现ora-00312错误,删除错误的log日志,后状态为TO ST...
方法/步骤 1 1.查看服务器状态时，发现主库与备库数据无法同步，如下图 2 2.尝试切换主库日志，结果发现主库都无法做日志切换 3 3.查看主库双节点状态，发现switchover_status都为RESOLVABLE GAP 4 4.查看警报日志信息，发现出现很多警报信息，根据分析是因为FLASH磁盘组空间不足的原因，但查看磁盘组发现磁盘组...
如下是在node1没有完成执行完shutdown immediate的情况,查询的switchover_status为RESOLVABLE GAP SQL> show parameter instance_name NAME TYPE VALUE --- --- --- instance_name string devdb2 SQL> set line 300 SQL> select dbid,name,current_scn,protection_mode,data...
SQL> alter system switch logfile; 备注: 查看当前备库的SWITCH OVER状态,这个时候可能会出现RESOLVABLE GAP的状态,再等一会就好了。 7)查看备库当前的切换状态 SQL> select name,database_role,switchover_status from v$database; NAME DATABASE_ROLE SWITCHOVER_STATUS ...
CUUG 1329392875PRIMARYMAXIMUM PERFORMANCERESOLVABLE GAP SQL> alter system switch logfile; System altered. SQL> select name,dbid,database_role,protection_mode,switchover_status from v$database; NAME DBID DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS ...
CUUG 1329392875 PRIMARY MAXIMUM PERFORMANCE RESOLVABLE GAP SQL> alter system switch logfile; System altered. SQL> select name,dbid,database_role,protection_mode,switchover_status from v$database; NAME DBID DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS --- --- --- --- --- CUUG 1329392875 PR...
SQL> select database_role,switchover_status from v$database; DATABASE_ROLE SWITCHOVER_STATUS --- --- PRIMARY RESOLVABLE GAP ##转换后的备库正在应用日志,过会再看一下转换后的主库状态: SQL> select database_role,switchover_status from v$database; DATABASE_ROLE SWITCHOVER_STATUS --- --- PRI...