Re: controlfile backup obsolete above 2 days

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).