| Loss of redo-log files [message #319113] |
Fri, 09 May 2008 01:55  |
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  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
