Congrats, Finally you found answer to your question...SPFILE is still not
that much reliable
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
Date: Sat, 28 Jun 2003 23:09:22 -0800
Hello List, here is what metalink says
fact: Oracle Server - Enterprise Edition 9.2.0
fact: Recovery Manager (RMAN)
symptom: Backupsets are incorrectly reported as obsolete
cause: <Bug:2458246>
"RMAN thinks backups with SPFILE are OBSOLETE"
fix:
Ver. 9.2.0 is the first version that supports backup of the server
side
parameter file (SPFILE).
RMAN backups are at risk for being incorrectly reported as obsolete,
and
deleted, under the following circumstances:
- CONFIGURE CONTROLFILE AUTOBACKUP is set to OFF, and
- RECOVERY WINDOW is used as retention policy.
If the REPORT OBSOLETE command lists any backups within the recovery
window, do
not issue DELETE OBSOLETE as this will delete backups needed for
recoverability.
The retention policy is by default set to REDUNDANCY. In an RMAN
environment
running with default settings the bug will not occur.
The recommended workaround is:
- Do not use AUTOBACKUP set to OFF. Set CONFIGURE CONTROLFILE
AUTOBACKUP to ON,
which forces the backup of the controlfile and SPFILE to be written to
a
separate autobackup piece. The bug does not affect backups where the
controlfile and SPFILE are in separate backupset from datafile 1. Also
an
explicit BACKUP CURRENT CONTROLFILE will place the controlfile in a
separate
backupset.
In addition the following workarounds prevent the bug from occurring:
- Do not use a retention policy based on recovery window. Use a
retention
policy based on the REDUNDANCY parameter, or no retention policy at
all. If the
retention policy is configured to NONE, then REPORT OBSOLETE and
DELETE
OBSOLETE do not consider any backups to be obsolete. Also
BACKUP...KEEP can be
used to override the retention policy.
- Do not use a server parameter file. Remove the existing SPFILE, and
use only
the ASCII based init.ora as parameter file.
Thanks for the help
..........................
----- 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
:
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
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 Sun Jun 29 2003 - 11:13:20 CDT
