ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN Backup Fails With ORA-19571 [ID 563219.1]

RMAN Backup Fails With ORA-19571 [ID 563219.1]

原创 Linux操作系统 作者:尛样儿 时间:2012-11-12 20:21:37 0 删除 编辑

附上报错截图:



参考文章:

RMAN Backup Fails With ORA-19571 [ID 563219.1]

修改时间:2012-5-24类型:PROBLEM状态:PUBLISHED优先级:3

In this Document

Symptoms
Cause
Solution

Applies to:

Oracle Server - Enterprise Edition - Version 9.0.1.4 and later
Information in this document applies to any platform.
***Checked for relevance on 24-May-2012***


Symptoms

RMAN backups are failing with the below error :

RMAN-00571: =========================================================== 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== 
RMAN-00571: =========================================================== 
RMAN-03002: failure of backup plus archivelog command at 04/10/2008 16:18:43 

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/10/2008 16:18:24 
ORA-19571: archived-log recid 85 stamp 650564644 not found in control file 
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/10/2008 16:18:19 
ORA-19571: archived-log recid 63 stamp 650478279 not found in control file 
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/10/2008 16:17:35 
ORA-19571: archived-log recid 58 stamp 650396427 not found in control file

 

Cause

It seems that the Controlfiles records are over-written.

Solution

You need to catalog the archivelogs to make the backup run without errors. 

Find the archivelog location and catalog the archivelogs using the below command : 

For example if the archivelogs are stored in '/disk1/archive' then you need to do the below : 

RMAN> catalog start with '/disk1/archive';

The above commands works in 10g but in previous releases of oracle we need to catalog the archivelog as below :-

RMAN> run 
   { 
  catalog archivelog '/gsdprd01/oraarch01/ahdp/arch/ahdp_arch_19328.arc'; 
  catalog archivelog '/gsdprd01/oraarch01/ahdp/arch/ahdp_arch_19329.arc'; 
  catalog archivelog '/gsdprd01/oraarch01/ahdp/arch/ahdp_arch_19333.arc'; 
  .... 
  }

Perform. the below steps so that you will not hit this error again in future :

+ Increase the value of CONTROL_FILE_RECORD_KEEP_TIME or use recovery catalog

Example : 

SQL> alter system set control_file_record_keep_time=14;

Recommendation : 
============== 
+  The backup and the deletion of the archive logs should be done only by RMAN 
+  The archiving should be set to AUTO. 
+  Always use a catalog database so that you will have the information in catalog even if the information is aged out from controlfile.





QQ截图20121112163601.jpg

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23135684/viewspace-749051/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle数据库管理员,Oracle数据库系统构架员;2012年7月出版《构建最高可用Oracle数据库系统:Oracle 11gR2 RAC管理、维护与性能优化》一书;Oracle 10g OCM。

注册时间:2010-01-05

  • 博文量
    483
  • 访问量
    5261826