Re: controlfile backup obsolete

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Fri, 20 Jun 2003 14:11:00 -0700
Message-ID: <F001.005B6D82.20030620134453@fatcity.com>

Sorry, I never used RMAN so far but this point came in my mind. I am surprised why Robert is not giving you a reply.

Regards
Rafiq

Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 20 Jun 2003 09:45:11 -0800
Rafiq that is a good point , but I have set my control_file_record_keep_time=7 (which is also the default , I think )
and recovery window is 4 days
Anything else to check ?

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

----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 20, 2003 08:14
: Is your control_file_record_keep_time database parameter value is
less than
: the time set for retention policy?
: I am not using rman but in Robert Freeman's 9i new features book I
saw
: aboves point.
:
: It might help or Robert may see your message and suggest some
solution.
:
: Regards
: Rafiq
:
:
:
:
: Reply-To: [EMAIL PROTECTED]
: To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
: Date: Thu, 19 Jun 2003 18:09:18 -0800
:
: 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).
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
 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).

Received on Fri Jun 20 2003 - 16:11:00 CDT