On restore of Oracle Database using Control File backup set, database recovery fails with an error RMAN-06054: media recovery requesting unknown archived log.

Problem

After completion of the Oracle database restore using Control File backup set, RMAN output reports database recovery failed with an error RMAN-06054: media recovery requesting unknown archived log.

Error Message

RMAN output in job log will report the following

channel ch0: starting archived log restore to default destination
channel ch0: restoring archived log
archived log thread=1 sequence=15391
channel ch0: reading from backup piece BE_mk123456
channel ch0: piece handle=BE_mk123456 tag=TAG20231102T131650
channel ch0: restored backup piece 1
archived log file name=X:\Path\filename.ARC thread=1 sequence=15391
unable to find archived log
archived log thread=1 sequence=1
released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/03/2023 08:24:52
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 1 and starting SCN of 145747199

Cause

Oracle does not stop recovery at the last available archive log as per the restored control file.

Solution

Once the Restore job is complete and during recovery, Oracle does not stop recovery at the last available archive log in the database backup sets as per the restored control file. It keeps on requesting next available archive log sequence number. Run the command below to open the database.

sqlplus '/ as sysdba'
sql> alter database open resetlogs;

After running the above command, it will display the message Database altered, which indicates that the database opened successfully.