查看两天前最大sequence号,这个天数需要根据主备库同步失败的天数确定,如果两天前同步失败,则
a.completion_time<=sysdate-2,如果三天前同步失败则a.completion_time<=sysdate-3
select max(sequence#)
from v$archived_log a,v$database b
where a.RESETLOGS_TIME=b.RESETLOGS_TIME and a.dest_id=1
and a.applied='YES' and a.completion_time<=sysdate-1
group by thread# order by thread#;
备库查看日志同步序列号
select thread#,pid,process,status,sequence# from v$managed_standby;
THREAD# PID PROCESS SEQUENCE# STATUS
---------- ---------- --------- ---------- ------------
1 4616 ARCH 107196 CLOSING
1 1496 ARCH 107195 CLOSING
0 6176 ARCH 0 CONNECTED
1 780 ARCH 107197 CLOSING
0 1056 RFS 0 IDLE
0 3728 RFS 0 IDLE
0 2848 RFS 0 IDLE
1 7400 RFS 107198 IDLE
1 5504 MRP0 107198 APPLYING_LOG
已选择9行。
主备库同时rman连接,删除107197之前的归档日志,主库空间如果足够最好不删除
RMAN>delete archivelog until sequence 107197;