Help - Search - Members - Calendar
Full Version: Best RMAN Backup Strategy
Oracle DBA Forums > Oracle > Oracle Forum
Tushar Kathe

I have 100GB of DB on Oracle 9i.
I am using following method for RMAN Backup
Plan - 1
Sunday-Level 0
Monday to Saturday - Differential Incremental Level 1

Plan - 2
Once a month - Level 0
Cummulative - Every Sunday
Differential Incremental - Monday to Saturday

Which plan is better and why? Also which level (1 or 2) should I use for cummulative and incremental plan 2?

Only you can answer which is better for your situation.

The primary reasons for making an incremental backup are

* To save tape when using a media manager or disk space when making disk backups
* To save network bandwidth when backing up over a network
* When the aggregate tape bandwidth available for tape write I/Os is much less than the aggregate disk bandwidth for disk read I/Os
* To be able to recover changes to objects created with the NOLOGGING option (direct load inserts do not log redo, although they do change data blocks and so are captured by incremental backups)
* To reduce backup sizes for NOARCHIVELOG databases. Instead of making a whole database backup every time, you can make incremental backups. Note that incremental backups of a NOARCHIVELOG database are only legal after a consistent shutdown.
Hello Tushar,

When choosing which approach is "best", you need a book.

I like the Robert Freeman book on RMAN:
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2016 Invision Power Services, Inc.