Ask the Expert

Advantages of using RMAN in a 24x7 environment

What is the main advantage of using RMAN in a 24x7 operating system?

    Requires Free Membership to View

RMAN can be used in a 24x7 environment to perform hot backups. But hot backups were possible long before RMAN. So why use RMAN to perform hot backups? There are a couple of main reasons. If you are not using RMAN for your hot backups, you have to place tablespaces in BACKUP mode before you can begin to make a backup of that tablespace's datafiles. When you place a tablespace in BACKUP mode, all changes that occur to the tablespace are logged differently in the online redo logs than under normal operating conditions. This can cause an increase in the volume of information written to the online redo logs. RMAN does not have this same issue to deal with. RMAN performing a hot backup does not cause an increase in online redo log volume during the backup process.

RMAN can also help with incremental backups. The old backup scripts in use cannot perform incremental backups. This can save considerable time in your backup window.

There are many other advantages to RMAN as well. I would recommend reading a book titled "Oracle9i RMAN backup & recovery" by Robert Freeman on Oracle Press as well as the Oracle documentation.

This was first published in May 2004

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: