We are planning to setup RMAN for our production database. Present status: We take hot backups daily (takes about 2.5 hrs) and a cold backup weekly. This hot backup is used to create a reporting database daily.

What we want:
1) Hot backup time reduced. 2) Ability to create reporting database using this backup daily. This process also should be faster than what we have now. I would like to know how RMAN can help our scenario.

    Requires Free Membership to View

RMAN can help in both of your requests. First, you need a baseline backup. With RMAN, this baseline backup can be hot or cold. You can then perform incremental backups on a daily basis. These incremental backups can replace your nightly hot backups. Since these nightly backups are incremental, your backup time should be significantly reduced. Only those blocks that have changed since the last baseline backup or incremental backup will be backed up. Those blocks that haven't changed will not be backed up.

Now that RMAN is backing up your database, you can use RMAN to create a clone of that database on another server for your reporting applications. RMAN doesn't care if the clone is created from a full database backup or from the baseline plus incrementals. RMAN will handle all of this for you!

Please read the RMAN documentation as it contains all of the information you'll need for incremental backups and for creating clones of the database.

This was first published in July 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: