Re: controlfile backup obsolete above 2 days

2003-07-03 Thread bulbultyagi
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 : >me

Re: controlfile backup obsolete above 2 days

2003-07-02 Thread Chip
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]

Re: Fw: controlfile backup obsolete above 2 days

2003-06-29 Thread M Rafiq
Congrats, Finally you found answer to your question...SPFILE is still not that much reliable Regards Rafiq Reply-To: [EMAIL PROTECTED] Date: Sat, 28 Jun 2003 23:09:22 -0800 Hello List, here is what metalink says fact: Oracle Server - Enterprise Edition 9.2.0 fact: Recovery Manager (RMAN

Fw: controlfile backup obsolete above 2 days

2003-06-29 Thread bulbultyagi
Hello List, here is what metalink says fact: Oracle Server - Enterprise Edition 9.2.0 fact: Recovery Manager (RMAN) symptom: Backupsets are incorrectly reported as obsolete cause: "RMAN thinks backups with SPFILE are OBSOLETE" fix: Ver. 9.2.0 is the first version that

RE: controlfile backup obsolete above 2 days

2003-06-21 Thread DENNIS WILLIAMS
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 P

Fw: controlfile backup obsolete above 2 days

2003-06-20 Thread bulbultyagi
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 speci

Re: controlfile backup obsolete

2003-06-20 Thread bulbultyagi
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 Rob

Re: controlfile backup obsolete

2003-06-20 Thread M Rafiq
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 ha

controlfile backup obsolete above 2 days

2003-06-20 Thread bulbultyagi
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 th

Re: controlfile backup obsolete

2003-06-20 Thread bulbultyagi
Mladen , I do not get a problem if I use : configure retention policy to redundancy n ; (n=> integer) However I am having my controlfile backup reported as obsolete when : configure retention policy to recovery window of n days ; (n=>integer , I use 4) and my control_file_record_keep_time=7 Please

Re: controlfile backup obsolete

2003-06-20 Thread bulbultyagi
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: F

Re: controlfile backup obsolete

2003-06-19 Thread M Rafiq
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:

Re: controlfile backup obsolete

2003-06-19 Thread Mladen Gogala
Obsolescence of a backup is defined by existance of other, redundant backups. Give a "redundant" option to your backup command and RMAN will wait for 30 backups before declaring the current one obsolete. On 2003.06.19 22:09, [EMAIL PROTECTED] wrote: Hello List, sorry about posting this again but

controlfile backup obsolete

2003-06-19 Thread bulbultyagi
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