DG的一些查询和操作
1. Check the gap <br><br>-- on physical standby, checking:<br>SELECT * FROM V$ARCHIVE_GAP;<br><br>-- on logical standby, checking:<br>-- If there are no gaps, the query will show only one file for each thread.<br>COLUMN FILE_NAME FORMAT a55<br>SELECT THREAD#, SEQUENCE#, FILE_NAME FROM DBA_LOGSTDBY_LOG L<br>WHERE NEXT_CHANGE# NOT IN<br>(SELECT FIRST_CHANGE# FROM DBA_LOGSTDBY_LOG WHERE L.THREAD# = THREAD#)<br>ORDER BY THREAD#,SEQUENCE#;<br><br><br>select sequence#,first_change#,next_change#,timestamp,applied from dba_logstdby_log;<br><br><br><br>2. Copy the missing archive log file from primary and register this log:<br><br>-- physical standby:<br>alter database register logfile '/physical_standby/xxx.arc';<br><br>-- logical standby:<br>alter database register logical logfile '/logical_standby/xxx.arc';<br><br>3. Restart the redo apply or sql apply:<br><br>-- restart redo apply, issue on physical standby database:<br>-- stop redo apply<br>alter database recover managed standby database cancel;<br><br>-- start redo apply<br>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;<br><br><br>-- restart sql apply, issue on the logical standby database:<br>-- stop sql apply<br>ALTER DATABASE STOP LOGICAL STANDBY APPLY;<br><br><br>-- start sql apply<br>ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;<br><br><br><br>
页:
[1]