When you lost current online redo log(media failure) , you need to perform incomplete recovery.
Oracle says restore all data files and redo log files from the backup.
Under the 24 by 7 database, I can only make hot backups, in other words, I don't have redo log backups.
Does this mean I can not recover from this type of failure?
Please share your experience with me.
Since you say that you are taking hot backups you should be in Archivelog mode.You can restore the database until the online redolog file that is lost (until cancel) and open the database with resetlogs option.
what I want to know is if I need to restore online redo logs or not to perform this kind of recovery. As you know, you can not restore online redo log from hot backukp.
According to you guys, all I need to do is restore all data files from backup, and recover database until cancel.
Is this right?
Somehow, I thought the case in the book is about the database in the archive log mode.
All my fault.
Nothing better than actuall test.
I just tested recovery from hot backup when the current online redo log has a problem, due to the media failure.
I restored all data files (no redo logs) and issued
'recover database until cancel' it worked.
Thanks you for all your help.