OSI NetExpert Online Community - Tip: Backing up your Oracle Database

Home

Tip: Backing up your Oracle Database

Written by Duane Boeck
Friday, 05 June 2009
To back up your Oracle database here are some tips which we use at OSI. The main Oracle solution in version 10g is to use Oracle’s utility RMAN to backup a database. You don’t have to shutdown the database to run RMAN, your database needs to be in archive mode. Also the best way to reduce I/O and decrease the time needed to backup a database and the best way to reduce time it takes to do database backups is put database in block change tracking mode. SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/rman_change_track.f' REUSE; This will reduce resources on the database while backing it up Significantly reduce I/O during backups. Save at least 2 times the size of your database in disk space. Example: One of our databases was 225 Gig in size. It was taking over 2.5 hours to backup. I/O during that time was off the charts. Now backup takes 20 minutes which saved over 400 Gig of disk space Here is a little tutorial. » No Comments There are no comments up to now. » Post Comment Only registered users can write a comment. Please login or register.
Last Updated ( Friday, 05 June 2009 )

< Prev		Next >