Home » Infrastructure » Unix » ORA-00322
ORA-00322 [message #97327] Thu, 14 March 2002 02:47 Go to next message
Murali Krisna
Messages: 3
Registered: March 2002
Junior Member
Sir.,
I am using the ScoUnixware 7.1.1 version Oracle on my Server. While giving the Startup Command at SVRMGR prompt system is giving the Error of
ORA-00322 (Online redolog is not current copy).
One of my redoORL01.log file was corrupted.
How I have to restore my redolog file.
Please help me out.
Thanking you

Regards

MURALI KRISHNA N
Re: ORA-00322 [message #97328 is a reply to message #97327] Thu, 14 March 2002 10:39 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Bummer! Here is what I would do:

1. Shutdown the database.
2. Do a cold backup of all files if possible. If not hope for the best. I would highly recommend it. This will allow you to put it back if this doesn't work so you can try other options.
3. Issue the following commands at the svrmgrl prompt:
STARTUP MOUNT
SET AUTORECOVERY ON;
ALTER DATABASE RECOVER UNTIL CANCEL; REM Enter "CANCEL" when it promps you.
ALTER DATABASE OPEN RESETLOGS;
4. Backup

Good luck!
Previous Topic: Re: Oracle 8i on Solaris for Intel
Next Topic: Re: Return code from sqlldr
Goto Forum:
  


Current Time: Wed Apr 24 11:33:00 CDT 2024