how to remove flashback logs in oracle 19c

Dec 9, 2022 1:55AM

Hi,

It hits ORA-19815: WARNING: db_recovery_file_dest_size 93% full on Oracle database(19.17 db version at platform solaris 5.11)

SQL> show parameter db_recovery_file_dest%

NAME TYPE VALUE

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

db_recovery_file_dest string /backup/JKEDCON/flash_recovery_area

db_recovery_file_dest_size big integer 110G

The window retention is 1 day => CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

We've found that there are 839 flashback logs:

SQL> 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 0 0 0 0

BACKUP PIECE 18.28 0 13 0

Database Administration (MOSC)