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)?

    Requires Free Membership to View

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

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: