Loss of ORL

Data Loss : Yes (For transactions not recorded in Archived Logs)

Down Time : Yes

Archive Log Mode : Yes

1. Perform some transactions and delete online redo logs

I performed a log switch so that these transactions are preserved in Archived Log Files

2. Shut abort the database and Restore control files and data files from previous consistent backup (redo log files need not be restored) and perform recovery

SQL> startup mount;

SQL> alter database recover automatic using backup controlfile until cancel;

SQL> recover cancel;

SQL> alter database open resetlogs;

3. Check if all transactions are present

That's it!!!

Regards

Charan