附上报错截图：
参考文章：
RMAN Backup Fails With ORA-19571 [ID 563219.1]
修改时间:2012-5-24
类型:PROBLEM状态:PUBLISHED优先级:3In this Document
| Symptoms |
| Cause |
| Solution |
Applies to:
Oracle Server - Enterprise Edition - Version 9.0.1.4 and laterInformation in this document applies to any platform.
***Checked for relevance on 24-May-2012***
Symptoms
RMAN backups are failing with the below error :
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 :
The above commands works in 10g but in previous releases of oracle we need to catalog the archivelog as below :-
{
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博客 ” ，链接：https://blog.itpub.net/23135684/viewspace-749051/ ，如需转载，请注明出处，否则将追究法律责任。
