Q

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?

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?

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:

  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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close