Database Backup and Recovery (MOSC)

MOSC Banner

How to reduce FRA usage alert from 85% to 60% or less?

edited Feb 27, 2018 4:04AM in Database Backup and Recovery (MOSC) 7 commentsAnswered

If you are using Fast Recovery Area (FRA) for the archive log destination and the destination is set to USE_DB_RECOVERY_FILE_DEST,

Archive log auto deletion is configured using CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK;

In case of FRA space crunch, oracle deletes files from FRA and this triggered at 85% , in our setup we want file deletion should be triggered at 60% or less.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center