暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

ORA-19571: archived log RECID 56695 STAMP xx not found in

oracle分享技术 2021-02-06
2077


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


Recovery Manager complete.


SQL> show parameter control


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


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




解决办法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';

<span font-size:14px;white-space:normal;background-color:#dfdfdf;"="" style="word-wrap: break-word; font-family: 宋体, Arial; font-size: 12px; white-space: normal; background-color: rgb(255, 255, 255); color: rgb(68, 68, 68);">在NBU 脚本中加入如上代码

文章转载自oracle分享技术,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论