Q

Improving backup speed and uses with RMAN

We want to reduce the time needed to take a daily hot backup with RMAN. How can we speed up this process?

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.

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

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