Home » RDBMS Server » Server Administration » recovering redo logs
recovering redo logs [message #52168] Sat, 06 July 2002 01:47 Go to next message
Praveen
Messages: 57
Registered: November 2001
Member
Hi,
i lost my redo log files and When I try to open the database I get

ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'F:ORACLEORADATAOWBREPOSREDO04.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file

Is it possible to get those files back?

Thanks in advance,
Praveen

Report message to a moderator

Re: recovering redo logs [message #52169 is a reply to message #52168] Sat, 06 July 2002 02:37 Go to previous messageGo to next message
B.SUNIL KUMAR RAO
Messages: 5
Registered: February 2002
Junior Member
Hi,

It is possible if you have taken backup of redo log files.
replace the latest logfile it should work.
All the best.
Sunil.

Report message to a moderator

DON'T DO THAT ! [message #52181 is a reply to message #52168] Mon, 08 July 2002 02:53 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
Argh ! don't do what Sunil SAYS ! Never use a backup of REDOLOG, YOU DON'T NEED IT ! ( except in some cases ). You just have a redo log member corrupted.
Try just to drop the log file member ... And then recreate it, if due to Disk error recreate it somewhere else.

Report message to a moderator

Previous Topic: Oracle7.3 is very slow
Next Topic: Re: mismatch in redo log files and database is not open
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 20:36:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.