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!

FRA space issue

AGanaOct 19 2015 — edited Oct 20 2015

Hallo,

I have got ORA-00257: archiver error. Connect internal only, until freed. (DBD ERROR: OCISessionBegin) in our Test Database.

I understand this has to do with FRA space. I have deleted all expired backups and archivelogs using RMAN.When i check FRA usage using the below query

select * from v$recovery_file_dest;

NAME	SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES

---------------------------------------- ----------- ---------- ----------------- ---------------

/db04/oracle/flash_recovery_area

9,6637E+11 2,9091E+12

I guess it is very clear that i have space in FRA, but still archivelogs cannot be copied and i get the below error message in alert.log.

ORA-19815: WARNING: db_recovery_file_dest_size of 966367641600 bytes is 100.00% used, and has 0 remaining bytes available.

Could anyone please help me on this?

This post has been answered by AGana on Oct 20 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 17 2015

Added on Oct 19 2015

#general-database-discussions

10 comments

1,563 views