Fw: controlfile backup obsolete above 2 days

From: <bulbultyagi_at_now-india.net.in>
Date: Sun, 29 Jun 2003 00:19:47 -0700
Message-ID: <F001.005BBCB7.20030628230921@fatcity.com>

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

-- 
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 Sun Jun 29 2003 - 02:19:47 CDT