Re: controlfile backup obsolete

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Thu, 19 Jun 2003 19:32:44 -0700
Message-ID: <F001.005B5C07.20030619184448@fatcity.com>

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).
MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus

--

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 Thu Jun 19 2003 - 21:32:44 CDT