Database Backup and Recovery (MOSC)

MOSC Banner

archived logs, FRA not being purged as I expect

edited Aug 1, 2016 12:45AM in Database Backup and Recovery (MOSC) 10 commentsAnswered

Hello, SuSE 11, x86-64, Oracle 11.2.0.3

log_archive_dest_1 = location=<path1>

log_archive_dest_2 = USE_DB_RECOVERY_FILE_DEST

rman "show all" includes:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

rman backup statements regarding archived log backups: The following rman job is run nightly. 

sql "alter system archive log current";

backup

filesperset = 32

format='<CVJOBID>_%d_%U'

(archivelog  all   delete input );


show parameter recovery_file_dest reveals:

NAME                       TYPE        VALUE                                     

-------------------------- ----------- ------------------------------------------

db_recovery_file_dest      string      /u19/oracle/oradata/proddb/recovery_files

db_recovery_file_dest_size big integer 6G 


Total space used in recovery file destination as of now = 1.6G. 

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