Recover database problem from a hot backup [message #150150] |
Tue, 06 December 2005 09:25 |
loilik
Messages: 2 Registered: March 2005
|
Junior Member |
|
|
I have a very urgent database recover case. I only have test format control file and all database files online backup ( Hot backup mark begin and end backup) No online redo log files, No Archived log files. How to recover database and let it open. please help to find solution. thanks. very very urgent.
|
|
|
Re: Recover database problem from a hot backup [message #150254 is a reply to message #150150] |
Tue, 06 December 2005 22:51 |
tarundua
Messages: 1080 Registered: June 2005 Location: India
|
Senior Member |
|
|
loilik wrote on Tue, 06 December 2005 20:55 | I only have test format control file and all database files online backup ( Hot backup mark begin and end backup) No online redo log files, No Archived log files.
|
You dont have archived log files then i believe complete recovery is impossible. Look for incomplete recovery in the manuals.
--> Restore the backup
--> open the database with resetlogs option.
let others chip in and throw their comments.
|
|
|