今天早上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 脚本中加入如上代码
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博客 ” ,链接:http://blog.itpub.net/7569309/viewspace-2132264/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7569309/viewspace-2132264/