Home » RDBMS Server » Backup & Recovery » Loss of redo-log files (RHEL 4, Oracle 9.2)
Loss of redo-log files [message #319113] Fri, 09 May 2008 01:55 Go to next message
myana.srinivas1
Messages: 9
Registered: April 2008
Location: India
Junior Member
hi,

I have lost my current redo-log file.
How do i start the database without loosing the present data.
I have yesterday's backup.
Re: Loss of redo-log files [message #319123 is a reply to message #319113] Fri, 09 May 2008 02:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you lost your current redo logs, you also lost all modifications that was recorded in it.
The only thing you can do is to restore and recover till the last SCN of the last redo logs you have and then open reset logs.

[Edit:] I assumed you lost all the members of your current log group otherwise you can use the other member(s) to restart the database.

Regards
Michel

[Updated on: Fri, 09 May 2008 02:14]

Report message to a moderator

Re: Loss of redo-log files [message #319131 is a reply to message #319113] Fri, 09 May 2008 02:21 Go to previous messageGo to next message
myana.srinivas1
Messages: 9
Registered: April 2008
Location: India
Junior Member
Thanx for the reply.

srinu.
Re: Loss of redo-log files [message #319143 is a reply to message #319131] Fri, 09 May 2008 02:49 Go to previous message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read Recovering After the Loss of Online Redo Log Files: Scenarios

Regards
Michel
Previous Topic: recovery catalog
Next Topic: Backup of Tablespaces
Goto Forum:
  


Current Time: Mon Dec 05 10:57:16 CST 2016

Total time taken to generate the page: 0.21416 seconds