Tuesday, October 23, 2012

recovery file dest in Oracle database

ISSUE:
Archiver might hang due to space usage in recovery area space.

CAUSE:
You can set up recovery area for recovery files such as archived log , control file to speed up database recovery.
two parameters to configure
db_recovery_file_dest -- where recovery area located e.g /u01/app/database/rflocation, +RFGRP
db_recovery-file_dest_size -- how many space can be used from the area

If size is too large, it will use too much space.
if size is too samll, it will hang your db if you save archvied log in the area.


CHECK:
v$recovery_file_dest
v$recovery_area_usage

reference:
http://www.pafumi.net/Flash_Recovery_Area.html

No comments:

Post a Comment