Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cleaning FRA

3286641Nov 8 2016 — edited Nov 11 2016

Hello All,

I am using Oracle 11.2.0.4 with ASM storage. FRA has around 1.4TB space.

Today I have taken archivelogs backup as below:

rman> backup archivelogall delete input;

Now the FRA is showing as 73% full with 0 reclaimable space.

SELECT * FROM V$RECOVERY_FILE_DEST;

pastedImage_0.png

select * from V$FLASH_RECOVERY_AREA_USAGE;

Getting the below output:

pastedImage_0.png

Please let me know how can I manage FRA. How can I free space in this situation??

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 9 2016
Added on Nov 8 2016
21 comments
4,439 views