Ora-19571 archived-log recid stamp not found in control file

ORA 19571 ARCHIVED LOG RECID STAMP NOT FOUND IN CONTROL FILE FREE

Specification does not match any datafile copy in the repository RMAN retention policy is set to redundancy 1 RMAN retention policy will be applied to the command Using target database control file instead of recovery catalogД¬hannel ORA_DISK_1: SID=286 instance=CDBTEST2 device type=DISKД¬rosschecked backup piece: found to be вЂAVAILABLEвЂ™Д«ackup piece handle=+FRA/CDBTEST/AUTOBACKUP/2021_02_20/s_1065046948.263.1065046949 RECID=1 STAMP=1065046948 RMAN> connect target to target database: CDBTEST (DBID=807098105) ROUND((SPACE_USED вЂ“ SPACE_RECLAIMABLE) / SPACE_LIMIT * 100, 1) AS PERCENT_FULL ((SPACE_LIMIT вЂ“ SPACE_USED + SPACE_RECLAIMABLE) / 1024 / 1024 / 1024) AS SPACE_AVAILABLE_GB, SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE According to the situation, reclaim space on Flash Recovery Area can be done with below commands. SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 20G SCOPE=BOTH SID=вЂ™*вЂ™ ДЄfter db_recovery_file_dest_size is increased, database can be opened normally. INCREASE DB_RECOVERY_FILE_DEST_SIZE ACCORDING TO SITUATION.

ORA 19571 ARCHIVED LOG RECID STAMP NOT FOUND IN CONTROL FILE FREE

In order to check free disc space run below command.ДATABASE SHOULD BE IN MOUNT ~]$ srvctl start database -d CDBTEST -o mount

As a solution, database should be in mounted mode and db_recovery_file_dest_size should be increased. One day when you want to open database, you can see ORA-19815 error in alert log and database can not be opened in rac environment.

Ora-19571 archived-log recid stamp not found in control file