RE: RMAN backup retention policy - doubt

From: Michael Dinh <mdinh_at_XIFIN.Com>
Date: Sat, 30 Oct 2010 08:21:51 -0700
Message-ID: <D29F9902E534D5478F2E83FD6A44B3068CF2C9F5_at_mail02.mba.xifin.com>



http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/setup004.htm

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT TAPE TO 3; Since you do full backup every day and no incremental, then this might be possible as well.

CONFIGURE RETENTION POLICY TO REDUNDANCY 7; Keep in mind that I have not used RMAN since 9i, but still trying to keep up with it.

Please feel free to correct me if I am wrong.



From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Subodh Deshpande [deshpande.subodh_at_gmail.com] Sent: Saturday, October 30, 2010 1:29 AM To: oracle-l
Subject: RMAN backup retention policy - doubt

Hi all,

I want to know..in our environment we have backup retention policy set in terms of days and also we do not take more than one copy of backup..and I think this is what is generally followed.

I could not exlain to my friend and so I wanted to know

assumtion - all are complete backup not incremental..

  1. is there any relation between number of channels and backup policy based on number of copies, only I know that channels can be configured for different devices..

so lets say if I have three 3 sbt devices and configured 7 channels (3 for sbt backup, 3 maintenace backup and 1 for disk backup) and if suppose I want to change my existing backup policy from one set to three sets of backup..what I should do so that all these three sbt devices can be used simultaneiously and average backup time will be less

b) if suppose I want to alter my backup retention policy from number of days (5) to number of days (7) plus number of copies(from1 to 3) and above is the configuration..what changes I should do.

c) Following is sample environment setup

Recovery Manager: Release 9.2.0.8.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. connected to target database: TESTIMCGS (DBID=1702101194) connected to recovery catalog database
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default RMAN configuration has no stored or default parameters RMAN configuration has no stored or default parameters CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/usr/oracle/product/9.2/dbs/snapcf_TESTIMCGSSRN.f'; # default

Thanks!
Subodh



DO NOT FORGET TO SMILE TODAY
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Oct 30 2010 - 10:21:51 CDT

Original text of this message