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!

check fra/archive size

859486Jun 24 2011 — edited Jun 24 2011
two node rac
asm
version 10.2..0.4
windows

i have backup all archives and delete input

but still archive size is showing as follows

SQL> Select file_type, percent_space_used from v$flash_recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED
------------ ------------------
CONTROLFILE .01
ONLINELOG .18
ARCHIVELOG 26.48
BACKUPPIECE 0
IMAGECOPY 0
FLASHBACKLOG 0

6 rows selected.

pleasee let me know what is problem,any other queries to check archive location used size
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2011
Added on Jun 24 2011
12 comments
3,171 views