Re: controlfile backup obsolete

Mladen , I do not get a problem if I use : configure retention policy to redundancy n ; (n=> integer)
However I am having my controlfile backup reported as obsolete when : configure retention policy to recovery window of n days ; (n=>integer , I use 4) and my control_file_record_keep_time=7

Please advise

...................

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 20, 2003 08:09

: Obsolescence of a backup is defined by existance of other, redundant
backups.
: Give a "redundant" option to your backup command and RMAN will wait
for 30
: backups before declaring the current one obsolete.
:
: On 2003.06.19 22:09, [EMAIL PROTECTED] wrote:
: > Hello List, sorry about posting this again but , no one responded
and
: > I am really stuck
: > I am using Oracle 9i release 2 enterprise edition on win32
: >
: > After connecting thru rman , I made sure that I did not have any
: > backupsets by running
: > delete backup ;
: > and then checked with list backup ;
: >
: > I have set a recovery window of 4 days with :
: > CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
: >
: > And enabled autobackup of controlfiles and spfiles :
: > CONFIGURE CONTROLFILE AUTOBACKUP ON;
: > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
: > 'D:\%F';
: >
: > Then I created a backup of the entire database :
: > backup database ;
: > (This created a separate backup piece :
D:\C-2202427048-20030619-05)
: >
: > This is the only backup of the control file I have. I checked
with
: > RMAN> LIST BACKUP OF CONTROLFILE;
: >
: > List of Backup Sets
: > ===================
: >
: > BS Key Type LV Size Device Type Elapsed Time Completion
Time
: >
:

> ------- ---- -- ---------- ----------- ------------ ----------------

--


: > --

: > 60      Full    672K       DISK        00:00:02     19-Jun-2003

08:04:


: > 42

: >         BP Key: 60   Status: AVAILABLE   Tag:

: >         Piece Name: D:\C-2202427048-20030619-05

: >   Controlfile Included: Ckp SCN: 190854       Ckp time:

19-Jun-2003


: > 08:04:40

: >

: > Now when I run report obsolete ;

: > Its gives me the following o/p

: >

: > RMAN retention policy will be applied to the command

: > RMAN retention policy is set to recovery window of 4 days

: > Report of obsolete backups and copies

: > Type                 Key    Completion Time    Filename/Handle

:

> -------------------- ------ ------------------ --------------------


: > Backup Set         60     19-Jun-2003 08:04:42

: > Backup Piece      60     19-Jun-2003 08:04:42

: > D:\C-2202427048-20030619-05

: >

: > Why is this sole backup of the controlfile , obsolete ?

: > If someone runs a delete obselete; they will delete this backup.

: >

: > --

: > Please see the official ORACLE-L FAQ: http://www.orafaq.net

: > --

: > Author: <[EMAIL PROTECTED]

: >   INET: [EMAIL PROTECTED]

: >

: > Fat City Network Services    -- 858-538-5051

http://www.fatcity.com


: > San Diego, California        -- Mailing list and web hosting

services


:

> --------------------------------------------------------------------
-


: > To REMOVE yourself from this mailing list, send an E-Mail message

: > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and

in


: > the message BODY, include a line containing: UNSUB ORACLE-L

: > (or the name of mailing list you want to be removed from).  You

may


: > also send the HELP command for other information (like

subscribing).


: >

:

: --

: Mladen Gogala

: Oracle DBA

: --

: Please see the official ORACLE-L FAQ: http://www.orafaq.net

: --

: Author: Mladen Gogala

:   INET: [EMAIL PROTECTED]

:

: Fat City Network Services    -- 858-538-5051 http://www.fatcity.com

: San Diego, California        -- Mailing list and web hosting

services


: --------------------------------------------------------------------

-


: To REMOVE yourself from this mailing list, send an E-Mail message

: to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

: the message BODY, include a line containing: UNSUB ORACLE-L

: (or the name of mailing list you want to be removed from).  You may

: also send the HELP command for other information (like subscribing).

:


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).