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