DomainKey-Signature: a=rsa-sha1; c=nofws;        d=gmail.com; s=gamma;        h=mime-version:date:message-id:subject:from:to:content-type;        b=QYp+mo3yVbeUU110M2YBNszOeRNxmlPUlainfP30vLVUs2WE7sw7upBw4norfK0hj5         OLYkFvjGAlGIXUQsLa+IDGQd3RcUezpdaLsGm74YPqc6azlQS9SuIelgqVvPyYE5thXZ         QYZ6/BoSOfLxTFmcAzdIfn0yeZrChbhnEWHCE=
MIME-Version: 1.0
Date: Sat, 30 Oct 2010 13:59:59 +0530
Message-ID: <AANLkTi=sHQY4r+_DF7b-9=iEwkvgGHLN7rb6xG3xu3VR@mail.gmail.com>
Subject: RMAN backup retention policy - doubt
From: Subodh Deshpande <deshpande.subodh@gmail.com>
To: oracle-l <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary=0016367f96787476c20493d1618e
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: deshpande.subodh@gmail.com
--0016367f96787476c20493d1618e
Content-Type: text/plain; charset=ISO-8859-1

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..

a) 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
==============================

--0016367f96787476c20493d1618e
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hi all,</div>
<div>=A0</div>
<div>I want to know..in=A0 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.</div>
<div>=A0</div>
<div>I could not exlain to my friend and so I wanted to know</div>
<div>=A0</div>
<div>assumtion - all are complete backup not incremental..</div>
<div>=A0</div>
<div>a)=A0is there any relation between number of channels=A0and backup pol=
icy based on number of copies, only</div>
<div>I know that channels can be configured for different devices..</div>
<div>=A0</div>
<div>so lets say if I have three 3 sbt devices=A0and configured 7 channels =
(3 for sbt backup,=A0 3 maintenace backup and 1 for disk backup)</div>
<div>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 devi=
ces can be used simultaneiously and average backup time will be less</div>

<div>=A0</div>
<div>b) if suppose I want to alter my backup retention policy from number o=
f days (5) to number of days (7)=A0plus number of copies(from1 to 3) and ab=
ove is the configuration..what changes I should do.</div>
<div>=A0</div>
<div>c) Following is sample environment setup</div>
<div>=A0</div>
<div>Recovery Manager: Release 9.2.0.8.0 - Production</div>
<div>Copyright (c) 1995, 2002, Oracle Corporation.=A0 All rights reserved.<=
/div>
<div>connected to target database: TESTIMCGS (DBID=3D1702101194)<br>connect=
ed to recovery catalog database</div>
<div>RMAN&gt; show all;</div>
<div>RMAN configuration parameters are:<br>CONFIGURE RETENTION POLICY TO RE=
DUNDANCY 1; # default<br>CONFIGURE BACKUP OPTIMIZATION OFF; # default<br>CO=
NFIGURE DEFAULT DEVICE TYPE TO DISK; # default<br>CONFIGURE CONTROLFILE AUT=
OBACKUP ON;<br>
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO &#39;%F&#39=
;; # default<br>CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default<br>CONF=
IGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default<br>CONFIG=
URE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default<br>
RMAN configuration has no stored or default parameters<br>RMAN configuratio=
n has no stored or default parameters<br>CONFIGURE MAXSETSIZE TO UNLIMITED;=
 # default<br>CONFIGURE SNAPSHOT CONTROLFILE NAME TO &#39;/usr/oracle/produ=
ct/9.2/dbs/snapcf_TESTIMCGSSRN.f&#39;; # default<br>
<br>Thanks!</div>
<div>Subodh</div>
<div>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D<br>DO NOT FORGET TO SMILE TODAY<br>=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<br=
></div>

--0016367f96787476c20493d1618e--
--
http://www.freelists.org/webpage/oracle-l