controlfile backup obsolete above 2 days

From: <bulbultyagi_at_now-india.net.in>
Date: Fri, 20 Jun 2003 12:27:25 -0700
Message-ID: <F001.005B6B1A.20030620120527@fatcity.com>

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 .

My control_file_record_keep_time=7
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 )
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 ;'
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). Received on Fri Jun 20 2003 - 14:27:25 CDT