The flash recovery area is Oracle
managed disk space that provides a centralized disk location for the backup and
recovery files.
The flash recovery area is defiled
by setting the database parameters
1. DB_RECOVERY_FILE_DEST and
2. DB_RECOVERY_FILE_DEST_SIZE (This
parameter specifies (in bytes) the hard limit on the total
space to be used by database
recovery files created in the recovery area location.)
The Oracle suggested using the flash
recovery area as the primary location for recovery. When the flash recovery
area is properly sized, files needed for repair are readily available. The
minimum recommended disk limit is the combined size of the database,
incremental backups, all archived redo logs that have not been copied to tape,
and flashback logs.
Step 1. check db_recovery parameter
Step 2. Command to
change db_recovery_file_dest
Step 3. Command to change
db_recovery_file_dest_size
----------------------------------------
No comments:
Post a Comment