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