show parameter db_recovery
NAME TYPE VALUE
-------------------------- ----------- ----------------------
db_recovery_file_dest string F:\flash_recovery_area
db_recovery_file_dest_size big integer 900G
show parameter db_flashback
NAME TYPE VALUE
----------------------------- ------- -----
db_flashback_retention_target integer 720
select space_used/(1024*1024*1024) gb_used, space_limit/(1024*1024*1024) gb_limit from v$recovery_file_dest;
GB_USED GB_LIMIT
---------- ----------
427.937144 900
select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
----------------------- ------------------ ------------------------- --------------- ----------
CONTROL FILE 0 0 0 0
REDO LOG 0 0 0 0
ARCHIVED LOG .03 .01 13 0
BACKUP PIECE 46.85 0 13 0
IMAGE COPY 0 0 0 0
FLASHBACK LOG .68 .65 122 0
FOREIGN ARCHIVED LOG 0 0 0 0
AUXILIARY DATAFILE COPY 0 0 0 0
8 rows selected.
Set FRA limit to be 90% of the drive size
alter system set db_recovery_file_dest_size=900G SCOPE=BOTH;
No comments:
Post a Comment