Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

archive log recovery error

Status
Not open for further replies.

deeway

MIS
May 8, 2006
16
0
0
NL
Hi,

We had a problem with one of our datafiles and it needed media recovery. So i looked into the v$recovery_log and saw that it needed the files from archxxxx43.arc to archxxxx80.arch.
I've managed to get these files from tape into the archive dir.
but when i started the "recover" process it got until archxxxx46.arc.
Then the following error appeared:
"Change 1415685 is needed.
log archxxxx45.arc is loaded. sequence# xxxx46.arc is needed."

The strange thing is that change 1415685 is in archxxxx46.arc!! He won't take it!!!

Why does he load arcxxxx45.arc when he needes arcxxxx46.arc?
 
try giving recover database command at svrmgr prompt and when promted for file names mention 'AUTO'. See if it works.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top