Home » Error recover database RMAN-06054

Error recover database RMAN-06054

by tuanlp

 I deleted the test database, and now I want to restore it back, when I try to recover the database I get this error. Everything I had at the database is there and everything works fine.

unable to find archived log
archived log thread=1 sequence=2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/28/2019 11:49:40
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 2 and starting SCN of 422743

SQL> select sequence# from v$archived_log;

 SEQUENCE#
----------
    11
    12
     1
    11
     1
    12

This is normal when performing an incomplete recovery without specifying where recovery should stop.

If sequence 1 is the last log sequence that was backed up, you can avoid the above error by using instead of:

recover database;

this:

recover database until sequence 2;
sqlplus '/ as sysdba'

sql>alter database open resetlogs;

You may also like