From rafiq9857@hotmail.com Sun, 29 Jun 2003 09:13:20 -0700 From: "M Rafiq" Date: Sun, 29 Jun 2003 09:13:20 -0700 Subject: Re: Fw: controlfile backup obsolete above 2 days Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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: "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).