FW: Controlfile Section 28 - denied expansion of controlfile
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Jul 2010 13:56:11 +0000
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))
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))
________________________________
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.
Amit Verma | 734.477.4850 (Work) | 734.223.2728 (Cell)
averma@xxxxxxxxxxxxxxxxxxx<mailto:averma@xxxxxxxxxxxxxxxxxxx>
Other related posts:
- » FW: Controlfile Section 28 - denied expansion of controlfile - Powell, Mark
