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
Post a Comment