Let us assume that my database is running in Archive log mode, and suddenly my hard disk has crashed, which contains all datafiles, control files, online redolog files. Fortunately I had a hot backup just few mins before the hard disk crash, and no new archive log has been generated. Assume that some of the transactions were made to the database.
1. Can it be possible to recover the database fully? If yes, please let me know the steps to be performing to recover fully.
2. Do I need to backup online redologs, during my hot backup?
3. Do I need to keep my previous archive log files, after my hot backup performed successfully?
Any help in this regard highly appreciated.
Thanks In Advance.
1. If you loose your online redo logs as well then you can't recover your database "fully". Transactions recorded in online redo logs can not be revoverd if you lost them before it has been archived.
2. You do not backup your online redo log files during hotbackup.
3. You don't have to keep the archived log files after a successful hotback unless you want a PITR before that successful hotbackup.
That means, always one should prepare for the worst. Right?
To avoid this kind of circumstances, what would you suggest?
Thanks in Advance.
That is why we keep multiple log file members on different disks.
Click Here to Expand Forum to Full Width