My backed up archivelog file format is 'al_%U'. During recovery it shows the following error:

RMAN-06054: media recovery requesting unknown log: thread 1 seq 17 lowscn 671075

How to determine which archivelog is necessary? In RMAN format I can't indicate thread and seq yes(for simply finding archivelog during this error)?

I should have that archivelog... If I really have that archive log how to indicate it to my database?

Thank You a lot...

I wil be very glad if you provide me with some book that clearly explains backup and recovery strategy and examples(In Oracle)...


Partial Answer of my question:

If I type

RMAN> list backup; 

It shows me the thread, Seq and Low SCN of the logfiles in the backup set :D great!!

But there is one missing archivelog backup, what to do? How to register?(I am not using Catalog!)


You need to use the catalog command in RMAN to make the file known to the database (don't worry, this does not depend on a recovery catalog!)

  • @"Jack Douglas" Thank you, I also found it (happy) but ERROR: RMAN-03009: failure of catalog command on default channel.. ORA-19698 "achivelogName" is from different database: id=169869321, db_name=Bd?LORCL DATABASE NAME SHOULD BE ORCL not Bd?LORCL...What happened
    – kupa
    Jul 21 '11 at 19:39
  • is it possible that the archivelog file is indeed from another database as the error suggests? Jul 21 '11 at 20:09
  • @"Jack Douglas" No.. I was performing backups and recovery just for one database...very strange.. Also strange is db_name indicated in the error..What is "Bd?LORCL" very strange name..What happened don't know :? (Just for info My OS is Centos 5)
    – kupa
    Jul 21 '11 at 20:19
  • could the file be corrupt? Perhaps you can try alter system dump logfile Jul 21 '11 at 20:29
  • 2
    have you got some more backpieces to catalog? You can use catalog to catalog a whole directory at once (see start with in the page I linked) Jul 21 '11 at 21:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.