Fast Recovery area is full, presence of a guaranteed restore point and no reusable flashback logs.

Error: the Fast Recovery Area (FRA) is full due to the presence of a guaranteed restore point, which prevents flashback logs from being reused or deleted.

Solution:

Check Existing Restore Points

SELECT NAME, GUARANTEE_FLASHBACK_DATABASE, SCN, TIME FROM V$RESTORE_POINT;

Drop Unneeded Guaranteed Restore Points

DROP RESTORE POINT restore_point_name;

Disable Flashback Database

select flashback_on from v$database;

-- Disable
ALTER DATABASE FLASHBACK OFF;

Manually Delete Archive Logs (If Needed)

RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';

Increase FRA Size (If Space Is Still Tight)

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 50G;
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply