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;

Comments

Popular posts from this blog

How to drop index and before dropping it how to get the DDL.

PRVG-11250 : The check "RPM Package Manager database" was not performed because

How to troubleshoot Long Running Concurrent Request in EBS 12.2

ORA-00257:archiver error, connect internal only until freed

Verifying Daemon “Avahi-Daemon” Not Configured And Running …FAILED (PRVG-1360)

Linux OL7/RHEL7: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm

CPU Patch Analysis

How to write to a CSV file using Oracle SQL*Plus

SKIP DNS RESLOV.CONF CHECK DURING RAC CONFIGURATION

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