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 fix Oracle SQL Developer connection issue "Got minus one from a read call"

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

How to troubleshoot Long Running Concurrent Request in EBS 12.2

How to autopopulate user_guid in fnd_user table ( EBS Blank Page)

Opatch is getting faild for GI patch with error code 2 while doing prereq

Few Important steps of Oracle Database Clone

How to Check AD and TXK code levels in your EBS environment

The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException

CPU Patch Analysis

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