Hi


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.