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;