| Problem crash REDO Log files [message #109852] |
Tue, 01 March 2005 08:39  |
JMPERNELLE
Messages: 1
Registered: March 2005
|
Junior Member |
|
|
Hi,
With an Oracle 8.O.4 Instance on a SUN Enterprise, I have a crash of REDO LOG Files. The three files are corrupted (they are empty). When I want to restart my Oracle instance, I have an error message ORA-00341 - log name of thread num, wrong log # num in header.
Help me please. How to restart my Oracle Database when the REDO LOG Files are corrupted ?
Thank you for you help.
JM
|
|
|
|
| Re: Problem crash REDO Log files [message #111177 is a reply to message #109852] |
Mon, 14 March 2005 08:52  |
Frank Naude
Messages: 4589
Registered: April 1998
|
Senior Member |
|
|
Hi,
You need to do a restore from backup and perform incomplete recovery up to the most recent available redo log.
If required, the damaged logfiles can be reinitialized with the ALTER DATABASE CLEAR LOGFILE command.
However, before you start, read the RMAN manual - especially the section describing recovery scenarios.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
