Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> controlfile backup obsoloete
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:42D:\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-LReceived on Wed Jun 18 2003 - 22:00:18 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).