Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

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

share|improve this question

1 Answer

up vote 2 down vote accepted

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

share|improve this answer
@"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? – Jack Douglas♦ 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 – Jack Douglas♦ Jul 21 '11 at 20:29
1  
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) – Jack Douglas♦ Jul 21 '11 at 21:03
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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