Oracle 12c, Windows 2008 R2.
hi everyone - have a question about best way to clean up and reclaim log space. below are the setups. what would be the easiest way to reclaim the 33.79 space. I am able to shutdown db if I do this on a weekend. thanks for any tips/advice.
SQL> show parameter flashback
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target integer 2880
SQL> select FLASHBACK_ON from v$database;
FLASHBACK_ON
------------------
YES
SQL> show parameter db_recovery;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string g:/oraclebase/flash_recovery_area
db_recovery_file_dest_size big integer 200G
SQL> select space_used/(1024*1024*1024),space_limit/(1024*1024*1024) from v$recovery_file_dest;
SPACE_USED/(1024*1024*1024) SPACE_LIMIT/(1024*1024*1024)
--------------------------- ----------------------------
71.2387466 200
SQL> select * from v$flash_recovery_area_usage;
8 rows selected.
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 0 0 0 0
BACKUP PIECE 0 0 0 0
IMAGE COPY 0 0 0 0
FLASHBACK LOG 35.62 33.79 331 0
FOREIGN ARCHIVED LOG 0 0 0 0
AUXILIARY DATAFILE COPY 0 0 0 0
8 rows selected.