Home » RDBMS Server » Backup & Recovery » Recover database problem from a hot backup
Recover database problem from a hot backup [message #150150] Tue, 06 December 2005 09:25 Go to next message
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 Go to previous message
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.
Previous Topic: Database not Open
Next Topic: recover old datafile
Goto Forum:
  


Current Time: Fri Mar 29 09:33:33 CDT 2024