RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence and starting SCN of

PROBLEM:
---------------

RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 8290 and starting SCN of 6062404529202



SOLUTION:
----------------

select scn_to_timestamp(6062404529202) from dual

output:
----------
01.07.2015 18:27:56,000000000

Also my backup finished at 18:34.But I couldn't recover at this point.

I found the 18:27 scn,then I set it.

select TIMESTAMP_TO_SCN (TO_TIMESTAMP ('20150701 18:27:00', 'YYYYMMDD HH24:MI:SS')) scn FROM dual;

output:
---------
6062404514529

Because redo didn't archived before the backup finished.So,this archive generated after finished backup.



RUN
{
allocate channel t1 type disk ;
allocate channel t2 type disk ;
allocate channel t3 type disk ;
allocate channel t4 type disk ;
set until scn 6062404514529;
SET NEWNAME FOR DATAFILE 1 to '+DATAC1';
SET NEWNAME FOR DATAFILE 15 to '+DATAC1';
SET NEWNAME FOR DATAFILE 2 to '+DATAC1';
SET NEWNAME FOR DATAFILE 4 to '+DATAC1';
SET NEWNAME FOR DATAFILE 23 to '+DATAC1';
SET NEWNAME FOR DATAFILE 24 to '+DATAC1';
SET NEWNAME FOR DATAFILE 41 to '+DATAC1';
SET NEWNAME FOR DATAFILE 42 to '+DATAC1';
SET NEWNAME FOR DATAFILE 5 to '+DATAC1';
SET NEWNAME FOR DATAFILE 6 to '+DATAC1';
SET NEWNAME FOR DATAFILE 26 to '+DATAC1';
SET NEWNAME FOR DATAFILE 27 to '+DATAC1';
SET NEWNAME FOR DATAFILE 28 to '+DATAC1';
SET NEWNAME FOR DATAFILE 29 to '+DATAC1';
SET NEWNAME FOR DATAFILE 30 to '+DATAC1';
SET NEWNAME FOR DATAFILE 31 to '+DATAC1';
SET NEWNAME FOR DATAFILE 32 to '+DATAC1';
SET NEWNAME FOR DATAFILE 33 to '+DATAC1';
SET NEWNAME FOR DATAFILE 34 to '+DATAC1';
SET NEWNAME FOR DATAFILE 37 to '+DATAC1';
SET NEWNAME FOR DATAFILE 38 to '+DATAC1';
SET NEWNAME FOR DATAFILE 39 to '+DATAC1';
SET NEWNAME FOR DATAFILE 40 to '+DATAC1';
SET NEWNAME FOR DATAFILE 7 to '+DATAC1';
SET NEWNAME FOR DATAFILE 8 to '+DATAC1';
SET NEWNAME FOR DATAFILE 9 to '+DATAC1';
SET NEWNAME FOR DATAFILE 10 to '+DATAC1';
SET NEWNAME FOR DATAFILE 11 to '+DATAC1';
SET NEWNAME FOR DATAFILE 12 to '+DATAC1';
SET NEWNAME FOR DATAFILE 13 to '+DATAC1';
SET NEWNAME FOR DATAFILE 14 to '+DATAC1';
SET NEWNAME FOR DATAFILE 17 to '+DATAC1';
SET NEWNAME FOR DATAFILE 18 to '+DATAC1';
SET NEWNAME FOR DATAFILE 19 to '+DATAC1';
SET NEWNAME FOR DATAFILE 20 to '+DATAC1';
SET NEWNAME FOR DATAFILE 22 to '+DATAC1';
SET NEWNAME FOR DATAFILE 60 to '+DATAC1';
SET NEWNAME FOR DATAFILE 25 to '+DATAC1';
SET NEWNAME FOR DATAFILE 3 to '+DATAC1';
SET NEWNAME FOR DATAFILE 16 to '+DATAC1';
SET NEWNAME FOR DATAFILE 21 to '+DATAC1';
restore database;
recover database;
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}

Finished restore at 03-07-2015 12:05:29

Starting recover at 03-07-2015 12:05:29

starting media recovery
media recovery complete, elapsed time: 00:00:07

Finished recover at 03-07-2015 12:05:37




RMAN> alter database open resetlogs;

database opened




Pray and tray:)