今天早上nbu 备份报如下错误
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ch01 channel at 01/11/2017 01:40:05
ORA-19571: archived log RECID 56695 STAMP 932087836 not found in control file

RMAN> RMAN>

Recovery Manager complete.

SQL> show parameter control

NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time       integer    7
control_files                      string    +xxx/xxxx/controlfile/curr
                                             ent.624.838868905
control_management_pack_access    string    DIAGNOSTIC+TUNING

发现控制文件中的信息保存为7天

select recid,SEQUENCE#,ARCHIVED,STATUS,COMPLETION_TIME from v$archived_log l order by l.RECID asc

1       57130       8804       YES       A       2017/1/4 8:20:50
2       57131       8805       YES       A       2017/1/4 8:35:31
3       57132       6706       YES       A       2017/1/4 8:36:08
4       57133       8332       YES       A       2017/1/4 8:51:35

发现最早的一条是  57130  ,相比 56695 要高很多.初步估计是由于控制文件中的信息不正确导致.

解决办法1:
alter system set control_file_record_keep_time=15 scope=spfile sid='*';
解决办法2:
$RMAN target $TARGET_CONNECT_STR catalog rman/rman@catalog msglog $RMAN_LOG_FILE append << EOF
DELETE NOPROMPT FORCE ARCHIVELOG UNTIL TIME 'SYSDATE-1';
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';

在NBU 脚本中加入如上代码

ITPub博客

ORA-19571: archived log RECID 56695 STAMP 932087836 not found in control file

最新文章