Monday, December 10, 2007

RMAN and Online Redo logs

As you all know RMAN doesnt backup online redo logs

The online redo logs files are never backed up by RMAN or any hot backup method.

The online redo logs files contain the latest data or redo generated by the database.(The data comes from redo log buffer written by LGWR).

The contents of the current redo logs are not archived until a log switch occurs.
This means if all your members in a redo log group fails, you would lose the latest information.

To minimize these failures, here are some suggestions that you can implement to safeguard your online redo logs
1. Multiplex your groups to have redundancy members
2. Do not put same members of the same group in one disk controller
3. Use RAID for your online redo logs
4. Make sure switching happens at regular intervals (use archive_lag_target parameter)


Only Oracle Dataguard Implementation with Maximum Protection Mode can save all committed data in the event you lose all members of the current online redolog group

No comments: