Wednesday, May 20, 2009

Benefits of RMAN Backup vs. Scripted Backups

RMAN was introduced in oracle8i. Before oracle8i, we used traditional backup or scripted backup. Why did oracle move to RMAN backup? Why do we need to use RMAN to backup our database? We may already be doing online backup with some wonderfully crafted, home-grown scripts. We may ask this question ourself. Why should we start using RMAN when my scripted backups are working fine?

We are moving to RMAN backup for two reasons. One is, when backup scripts breaks, the database backup would fail. Another issue is, when script fails, some one has to fix the backup scripts.

There are number of other positive reason to move to RMAN backup. Here are these....

1. RMAN will detect corrupted blocks and report them to us. RMAN also can recover only corrupted blocks. This is called Block Media Recovery(BMR). In traditional recovery, we need to restore and recover the whole data file. But in RMAN, it is not required to restore and recover the entire data file for just few corrupted blocks.

2. RMAN can back up your database online without having to put the tablespace in hot backup mode. Thus, the additional redo generated during a hot backup is reduced.

3. RMAN will automatically track new datafiles and tablespaces for us. In scripted backup, we might need to change the backup script when new tablespace or data file is added in the database.

4. RMAN will only backup up used data blocks(up to the high water mark(HWM)). So RMAN backup images typically are smaller than those of traditional online back images.

5. RMAN provides easy, automated backup, restore and recovery operations. RMAN tracks all the backups needed to recover the database.

6. RMAN can work fairly seamlessly with third-party media management products.

7. RMAN supports incremental backup strategies.

8. With RMAN, we can actually test backups without restoring them. We can validate the backup and make sure backup will work at the time of restore.

9. If we use the repository, then RMAN provides a nice, centralized reporting facility.

I have discussed some of the other topics which are related to this thread. Please go through below links in case if you are interested....

How do we enable archivelog in oracle? Click here

How do we set up RMAN in oracle? Click here

What are the new features in RMAN since Oracle9i? Click here

Different type of recovery scenario in RMAN? Click here

No comments: