Q

Can I take a compressed backup with RMAN?

I am using RMAN for my backups. But it failed. The reason is the size of the backup -- the filesystem got filled before it started compressing the backup files. Is there any way I can take a compressed backup?

My database is Oracle8i on a Solaris platform. I am using RMAN for my backups. But it failed. The reason is the size of the backup -- the filesystem got filled before it started compressing the backup files. Is there any way I can take a compressed backup (as we do by using named pipes with Oracle export)?

There is no method that I have seen similar to using named pipes for export derived to the RMAN backups. RMAN does a form of compression when you do BACKUP DATABASE (not an incremental backup) by not backing up any blocks that are empty. But your backup destination needs to have enough space. Many who do not have enough disk space perform one of three options: 1) backup directly to tape, 2) backup to a network attached disk device or...

3) procure more disk.

Let's say that you were able to perform some sort of compression and saved 20% of the required space to back up your database. Then what happens when your database grows another 30%? You'll be out of space for your backups again. I'd solve this issue without compression because the space shortage can come up again in the future.

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

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close