Database Backup and Recovery (MOSC)

MOSC Banner

RMAN- retention policy setting

edited Jun 27, 2013 6:38AM in Database Backup and Recovery (MOSC) 8 commentsAnswered
Hi,
here are the setting in my prod database,

1 and 2 are set on my rman backup script as we have policy of deleting backup after 35 days.
do I need this 2 points to set or  #2 is enough ?

whatever it is , what is the effect of #3 on backup and recoverability ? 

I'm using oracle 11.2.0.3 on Linux VMware............



1.  CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 35 DAYS;


2.  delete noprompt  backupset completed before 'sysdate-35';


3.  SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7


Thanks in advance.
TCY



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