状态确认查询
当前没有应用完的最小日志文件序列
Select min(Sequence#) From V$archived_Log where Applied!='YES';
mrp当前正在应用的日志序列
select process,status,sequence# from v$managed_standby;
通过查询可以看出当前应用日志卡在哪个日志文件
1scp 归档日志
2重新注册日志
手动:
ALTER DATABASE REGISTER LOGFILE '/u01/oracle/oradata/itilwx/archivelog/1_4140_891024108.dbf';
批量:
select 'ALTER DATABASE REGISTER LOGFILE ''/u01/oracle/oradata/itilwx/archivelog/1_' ||id||'_891024108.dbf'';'
from (select rownum id from CP_USER) where id>4141 and id<4206