Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

Backup compression


If limited disk space is available, or a backup across a network environment imposes bandwidth restrictions, or if the backup is to be transported on media with a limited storage capacity, then a compressed backup is a good option.

Fast backup compression

The compressed backup can be directly configured as an option for the CONFIGURE CHANNEL command.

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;

Once the backup is performed, it will be done in a compressed format.

The compression can also be configured in a non-persistent way, it can be specified directly as a command option:

BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

In order for the DBA to recover from a compressed backup, they just need to issue the regular RESTORE/RECOVER commands. There are no specific parameters required to recover from a compressed backup set.

Let's take a look at the backup with compression enabled:

RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS...