| ORA-00322 [message #97327] |
Thu, 14 March 2002 02:47  |
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  |
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!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
