delete archive logs using flash recovery area...
Hi All,
In my environment, I also face one issue of db_recovery_file_dest is getting 100% usage and DB is in Hung mode.
when I check with "SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE" query , it shows me only Archvie log use this space. so I would think some process which delete this archvie logs automatically. I come across with RMAN and fine one configuration parameter as below:
"CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS",
will it elete all archvies?
can any one suggest me that my assumption is right or not?
Thanks...