Ask the Expert

Difference between RMAN and traditional backup methods

What is the difference between RMAN and the traditional backup methods (like hot/cold backup and import and export)? What are the major benefits of RMAN that make it more prominent than traditional backups?

    Requires Free Membership to View

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:

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:

  1. Ability to perform incremental backups.
  2. Ability to recover one block of a datafile.
  3. Ability to perform the backup and restore with parallelization.
  4. Ability to automatically delete archived redo logs after they are backed up.
  5. Ability to automatically backup the control file and the SPFILE.
  6. Ability to restart a failed backup without having to start from the beginning.
  7. Ability to verify the integrity of the backup.
  8. Ability to test the restore process without having to actually perform the restore.

This was first published in February 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: