Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> controlfile backup obsoloete

controlfile backup obsoloete

From: <bulbultyagi_at_now-india.net.in>
Date: Wed, 18 Jun 2003 20:00:18 -0700
Message-ID: <F001.005B4A10.20030618194418@fatcity.com>


Hello list
I am using Oracle 9i release 2 enterprise edition on win32

After connecting thru rman , I made sure that I did not have any backupsets by running
delete backup ;
and then checked with list backup ;

I have set a recovery window of 4 days with : CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS; And enabled autobackup of controlfiles and spfiles : CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\%F';

Then I created a backup of the entire database :  backup database ;
(This created a separate backup piece : D:\C-2202427048-20030619-05)

This is the only backup of the control file I have. I checked with RMAN> LIST BACKUP OF CONTROLFILE; List of Backup Sets


BS Key Type LV Size Device Type Elapsed Time Completion Time

Now when I run report obsolete ;
Its gives me the following o/p

RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 4 days Report of obsolete backups and copies

Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set         60     19-Jun-2003 08:04:42
Backup Piece      60     19-Jun-2003 08:04:42
D:\C-2202427048-20030619-05

Why is this sole backup of the controlfile , obsolete ?

-- 
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 Wed Jun 18 2003 - 22:00:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US