RMAN Backup Fails With ORA-19571 [ID 563219.1]

附上报错截图：



参考文章：

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23135684/viewspace-749051/