Thanks rafiq , will hope that the gurus of Oracle smile upon us mortals soon.
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 21, 2003 03:14 : 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). : -- 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).
