Oracle10g RMAN Automated Disk-Based Backup and Recovery db_recovery_file_dest_size db_recovery_file

Oracle Tips by Burleson

Oracle 10g RMAN Automated Disk-Based Backup and Recovery

Prior to Oracle 10g, disk files that were created by the RMAN utility or ARCH process had no knowledge of one another. Furthermore, they were not aware of the sizes of the file system on which they created files. Database administrators needed to routinely clean up the old archive logs or old RMAN files.

It is better to have a unified disk storage location where you can manage all recovery-related files. Now you can achieve this in Oracle 10g by specifying a Recovery Area.

Recovery Area

The recovery area is a unified disk storage location for all recovery-related files and activities in an Oracle Database. Those files include:

Control file
Online redo log files
Archived log files
Flashback logs
Control file autobackups
Data file copies
RMAN files

Setting up a Recovery Area

The recovery area is defined by setting two initialization parameters. These two parameters can be dynamically altered or disabled.

The db_recovery_file_dest_size sets the disk limit, expressed in bytes
The db_recovery_file_dest sets the location for the recovery area

Enabling a Recovery Area

This statement sets the disk limit for recovery area to 100 GB:

SQL> ALTER SYSTEM
SET DB_RECOVERY_FILE_DEST_SIZE = 100G

This statement sets the recovery area destination:

SQL> ALTER SYSTEM
SET DB_RECOVERY_FILE_DEST = ‘/dba/backup/’;

Alter a Recovery Area

This statement alters the size of the recovery area:

SQL> ALTER SYSTEM
SET DB_RECOVERY_FILE_DEST_SIZE = 200G;

Disabling a Recovery Area

This statement disables a recovery area:

SQL> ALTER SYSTEM
SET DB_RECOVERY_FILE_DEST = ‘ ’;

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress. Written by top Oracle experts, this book has a complete online code deport with ready to use scripts.

To get the code instantly, click here:

http://rampant-books.com/book_2003_2_oracle10g.htm

Need an Oracle Mentor?

BEI is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle question.

Why risk an unplanned outage? You can now get telephone access to Don Burleson or any of his Oracle Certified DBAs with more than 20 years of full-time IT experience. Click here for details:

http://www.dba-oracle.com/service_oracle_backup.htm