RMAN is Oracle's backup and recovery utility. Before RMAN, DBAs had to use their own scripts to perform the backups. With RMAN, backups become as easy as:
BACKUP DATABASE;RMAN reduces the complexity of backup and recovery. RMAN can determine what needs to be backed up or restored and figure out the best way to do this. With Oracle 10g, RMAN backups can be automatically scheduled to the Flash Recovery Area so that you do not have to think about backups any more. OEM in 10g can be used to perform a manual backup if you need it.
RMAN has many other features that the traditional hot and cold backup scripts cannot perform. Those features include, but are not limited to:
- Ability to perform incremental backups.
- Ability to recover one block of a datafile.
- Ability to perform the backup and restore with parallelization.
- Ability to automatically delete archived redo logs after they are backed up.
- Ability to automatically backup the control file and the SPFILE.
- Ability to restart a failed backup without having to start from the beginning.
- Ability to verify the integrity of the backup.
- Ability to test the restore process without having to actually perform the restore.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading