Now ORACLE provides a free Media Management layer(MML) as part of its Oracle Secure Backup server software.
It offers a easy and convinent way to implement a tape backup statergy without using a third party MML where you must pay aditional licence fees.
If you have a single server, you can use Oracle Secure Backup Express.It is limited to a single host with one direct-attached tape drive.
Oracle Secure Backup Express is the replacement product for Legato Storage Manager (LSM) and Legato Single Server Version (LSSV).
One distinct advantage of OSB Express over LSSV is that OSB Express can do file system backup.
Oracle Secure Backup Express is bundled with the Oracle Database and its free.
Oracle's technical support organization will provide technical support, phone support, or updates to you for Oracle Secure Backup Express when it is used to back up another Oracle Product that has a valid Customer Support Identifier (CSI).
If you have a big environment you can use the full fledge Oracle Secure Backup.
Oracle Secure Backup is licensed by the number of tape drives utilized (clients are unlimited).
You can user OSB with Oracle Database 9i,10g and 11g.
Friday, December 14, 2007
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
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
Subscribe to:
Posts (Atom)
