2

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)...

GREAT THANKS!!...

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!)

1 Answer 1

3

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!)

7
  • @"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
    Commented Jul 21, 2011 at 19:39
  • is it possible that the archivelog file is indeed from another database as the error suggests? Commented Jul 21, 2011 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
    Commented Jul 21, 2011 at 20:19
  • could the file be corrupt? Perhaps you can try alter system dump logfile Commented Jul 21, 2011 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) Commented Jul 21, 2011 at 21:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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