How To Manage Space of The FRA in the Oracle DB


Delete Old files

connect with the target database using RMAN

RMAN target /
Delete the old files
RMAN> delete obsolete;

Remove Restore Points

SQL> SELECT name, storage_size FROM gv$restore_point;

Drop the restore point

SQL> DROP restore point RP;
Delete the archive logs
RMAN> DELETE archivelog ALL

Increase the Space

SQL> ALTER SYSTEM SET db_recovery_file_dest_size = 20G scope=both;

Disable the Flashback

ALTER DATABASE flashback off;


Popular posts from this blog

How to fix Oracle SQL Developer connection issue "Got minus one from a read call"

Few Important steps of Oracle Database Clone

How to troubleshoot Long Running Concurrent Request in EBS 12.2