Re: Controlfile Section 28 - denied expansion of controlfile
- From: Ivan Ricardo Schuster <ivanrs79@xxxxxxxxx>
- To: averma@xxxxxxxxxxxxxxxxxxx
- Date: Wed, 21 Jul 2010 13:39:33 -0300
Amit, if you have your RMAN backups cataloged, it is not necessary to set
control_file_record_keep_time to 45 days, change it to default 7 days and be
happy!
On 21 July 2010 13:13, Amit Verma (IT - Otterbase) <
averma@xxxxxxxxxxxxxxxxxxx> wrote:
> @Mark –
>
>
>
> Thanks Mark.
>
>
>
> I saw the Metalink note 1131163.1; that’s how I found out that section 28
> is RMAN STATUS… Other than that I couldn’t find much info on what exactly
> does it mean by RMAN STATUS…
>
>
>
> One thing I forgot to mention in my earlier email that I am using catalog
> for RMAN. We get the list of handles from the catalog based on the retention
> policy and delete (change backuppiece delete) those backuppieces.
> Nonetheless, I have tried both the delete obsolete and
> crosscheck-delete-expired, but the error/warning is still there…
>
>
>
> I don’t mind the warning message so much, but it is probably causing an
> intermittent “Resync got ORA-235” during the backups… since the control file
> is being written at the time of the auto Resync during the backups.
>
>
>
> @Jon-
>
>
>
> I don’t think the error is because of the size of the control file, it has
> reached the max number of records allowed. The block size is 8k, the current
> size of the ctrl file is ~23m and there is plenty of space left on the file
> systems.
>
>
> ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Powell, Mark
>
> *Sent:* Wednesday, July 21, 2010 9:56 AM
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* FW: Controlfile Section 28 - denied expansion of controlfile
>
>
>
> forgot to copy list
>
>
> ------------------------------
>
> *From:* Powell, Mark
> *Sent:* Wednesday, July 21, 2010 9:56 AM
> *To:* 'averma@xxxxxxxxxxxxxxxxxxx'
> *Subject:* RE: Controlfile Section 28 - denied expansion of controlfile
>
> I think you need to run an rman delete obsolete operation
>
>
>
> The following support notes might be of interest
>
>
>
>
> WHAT DO CONTROLFILE SECTION NUMBERS MEAN? #1131163.1
>
>
>
>
> https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocTitle=WHAT%20DO%20CONTROLFILE%20SECTION%20NUMBERS%20MEAN?&viewingMode=1143&bmDocDsrc=KB&bmDocType=HOWTO&bmDocID=1131163.1&from=BOOKMARK<https://support.oracle.com/CSP/ui/flash.html#tab=KBHome%28page=KBHome&id=%28%29%29,%28page=KBNavigator&id=%28bmDocTitle=WHAT%20DO%20CONTROLFILE%20SECTION%20NUMBERS%20MEAN?&viewingMode=1143&bmDocDsrc=KB&bmDocType=HOWTO&bmDocID=1131163.1&from=BOOKMARK>
> ))
>
>
>
>
> Delete noprompt force obsolete does not remove ALL Obsolete entries in
> catalog #982996.1
>
>
>
>
> https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocTitle=Delete%20noprompt%20force%20obsolete%20does%20not%20remove%20ALL%20Obsolete%20entries%20in%20catalog&viewingMode=1143&bmDocDsrc=KB&bmDocType=PROBLEM&bmDocID=982996.1&from=BOOKMARK<https://support.oracle.com/CSP/ui/flash.html#tab=KBHome%28page=KBHome&id=%28%29%29,%28page=KBNavigator&id=%28bmDocTitle=Delete%20noprompt%20force%20obsolete%20does%20not%20remove%20ALL%20Obsolete%20entries%20in%20catalog&viewingMode=1143&bmDocDsrc=KB&bmDocType=PROBLEM&bmDocID=982996.1&from=BOOKMARK>
> ))
>
>
>
>
>
>
> ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Amit Verma (IT - Otterbase)
> *Sent:* Tuesday, July 20, 2010 4:38 PM
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Controlfile Section 28 - denied expansion of controlfile
>
> Hey Guys,
>
>
>
> Need some help here. Getting this error in the alert log…
>
>
>
> kccrsz: denied expansion of controlfile section 28 by 53619 record(s)
>
> the number of records is already at maximum value (65535)
>
>
>
> I searched online and metalink… the only info I could find was the section
> 28 is RMAN STATUS. Is there a way to clear out/limit the number of records
> for RMAN STATUS in the controlfile? What exactly does it store in these
> records?
>
>
>
> I can’t set the control_file_record_keep_time (currently set to 45) to 0
> since I have my RMAN retention set to 45 days.
>
>
>
> Oracle 10.1.0.5 on AIX 4.3
>
> RMAN level 0 backups and Arc backups scripted and scheduled.
>
>
>
>
>
>
>
Other related posts:
