RE: controlfile backup obsolete above 2 days

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: <[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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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).