Re: controlfile backup obsolete above 2 days

Thanks chip
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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.
: >dwilliams_at_lifetouch.com
: >
: >
: >-----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: <ORACLE-L_at_fatcity.com>
: >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: ocp-dba_at_earthlink.net
:
: 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: ListGuru_at_fatcity.com (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: <bulbultyagi_at_now-india.net.in
  INET: bulbultyagi_at_now-india.net.in

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: ListGuru_at_fatcity.com (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).