How to fix ORA-19571 during running of RMAN?

Received ORA-19571 error when running of archive log process, and found the the parameter control_file_record_keep_time was set to 0 so we changed to higher value which fixed the issue. Note this parameter can be changed without restart if using spfile, click on this link to find how to find if you are using spfile or not.

Log file:
archive log filename=/u01/oradata/TEST/arch/TEST_173673.arc recid=173475 stamp=668792442
Crosschecked 3146 objects

starting full resync of recovery catalog
full resync complete

sql statement: alter system archive log current

Starting backup at 22-SEP-08
channel t1: starting archive log backupset
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 09/22/2008
ORA-19571: archived-log recid 173477 stamp 668795179 not found in controlfile

One comment

  1. Check control_file_record_keep_time.
    sho parameter control

    ———————————— ———– ——————————
    control_file_record_keep_time integer 7

    The value must be low. So Increase.
    SQL> alter system set control_file_record_keep_time=90 scope=both sid=’*’;

    System altered.
    SQL> sho parameter control

    ———————————— ———– ——————————
    control_file_record_keep_time integer 90

    Run the backup.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.