Thanks chip ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 02, 2003 11:10
: MetaLink Bug 2458246 (fixed in 9.2.0.2) : : DENNIS WILLIAMS wrote: : : >Offhand it sounds to me like you may have uncovered an error. I would search : >metalink and if you don't find an error matching this situation, I would : >file a TAR. : > : >Dennis Williams : >DBA, 80%OCP, 100% DBA : >Lifetouch, Inc. : >[EMAIL PROTECTED] : > : > : >-----Original Message----- : >Sent: Friday, June 20, 2003 9:34 PM : >To: Multiple recipients of list ORACLE-L : > : > : >Hello list : >sorry to trouble you all so much, : >I tried all that I stated below on another database I created, and as : >long as I don't use an spfile , no problem. As soon as I start using : >an spfile , I always get my backup shown as obsolete , irrespective of : >the number of days (the value of n) I specify in ''report obsolete : >recovery window of n days; '' . : >Also a few more details , previously i was getting the problem on a : >9.2.0.1.0 enterprise edition database in noarchivelog mode. The : >problem I stated above is on a 9.2.0.1.0 enterprise edition database : >in archivelog mode with automatic archiving enabled. All this on : >win32. : > : > : > : >----- Original Message ----- : >To: <[EMAIL PROTECTED]> : >Sent: Saturday, June 21, 2003 00:28 : > : > : >: Hello list : >: I was having problems with my controlfile backups being reported as : >: obsolete ; : >: I have narrowed down the problem to the number of days specified in : >: the recovery window . : >: : >: 1. My control_file_record_keep_time=7 : >: : >: 2. Suppose I start rman and there are no backups yet. (This is : >: confirmed by the commands : : >: delete noprompt force backup ; : >: delete nopromt force copy ; : >: list backup ; (This shows no o/p confirming that there are no : >: backups ) : >: list backup of controlfile ; (This shows no o/p confirming that : >there : >: are no backups ) : >: : >: 3. All the rman configuration settings are at their default values : >. : >: I did not modify any , and just to be sure I checked using 'show all : >: ;' : >: : >: 4. Now I backup the database : : >: backup database ; : >: : >: As expected it creates a single set with a single piece whose name : >is : >: in the o/p: : >: : >: channel ORA_DISK_1: finished piece 1 at 21-Jun-2003 00:13:01 : >: piece handle=D:\ORACLEXP\ORA92\DATABASE\03EQ6ARH_1_1 comment=NONE : >: channel ORA_DISK_1: backup set complete, elapsed time: 00:00:28 : >: Finished backup at 21-Jun-2003 00:13:01 : >: : >: : >: 5. I confirm this by using 'list backup ;' and : >: list backup of controlfile ; : >: : >: 6. NOW THE PROBLEM IS : : >: : >: : >: RMAN> report obsolete recovery window of 1 days ; : >: : >: no obsolete backups found : >: : >: : >: RMAN> report obsolete recovery window of 2 days ; : >: : >: no obsolete backups found : >: : >: : >: : >: RMAN> report obsolete recovery window of 3 days ; : >: : >: Report of obsolete backups and copies : >: Type Key Completion Time Filename/Handle : >: ----------------- ------ ------------------ -------------------- : >: Backup Set 3 21-Jun-2003 00:12:52 : >: Backup Piece 3 21-Jun-2003 00:12:52 : >: D:\ORACLEXP\ORA92\DATABASE\03EQ6ARH_1_1 : >: : >: Why is this happening for all values above 2 days ? : >: Please advise : >: ................. : >: : > : > : > : : : : -- : Please see the official ORACLE-L FAQ: http://www.orafaq.net : -- : Author: Chip : 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).
