Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#general-database-discussions
21 comments
4,387 views