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).
Received on Fri Jun 20 2003 - 21:35:14 CDT
