| help me [message #61191] |
Mon, 05 April 2004 01:13  |
what can I do now
Messages: 1
Registered: April 2004
|
Junior Member |
|
|
Sir:
When I startup my database (oracle8.0.5),I failed .
and give the message:
ORA-00322:log 3 of thread 1 is not current copy
ORA-00312:online log 3 thread 1: '/home3/oracle/
oradata/ora8/redoora803.log
And there are 3 redo log files under the direction.
They are redoora801.log ,redoora802.log ,redoora803.log.
Now ,how can I startup my database? Thanks.
|
|
|
|
|
|
| Re: help me [message #61193 is a reply to message #61191] |
Mon, 05 April 2004 01:58  |
sanu
Messages: 6
Registered: April 2004
|
Junior Member |
|
|
The reason you are getting this error is because when the database is trying to open the log header informations appears to be incorrect.
So before you do anything take a proper backup .
----------------------------------------------
There is a possibility that if you mention only one member of the corrupted group then the below statement will not work. If you have more than member in a group then you must include all the log file else issue the command
ALTER DATABASE CLEAR LOGFILE ('/home3/oracle/oradata/ora8/redoora803.log');
Take backup before you do anything..
best of luck
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
