RE: Controlfile Section 28 - denied expansion of controlfile
- From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
- To: <averma@xxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Jul 2010 12:07:27 -0400
The size of the control file is directly based on the blocksize of the
database, at least through 10g. 8k block size yields a maximum size of
control file of about 160m. I have not run into your specific problem
but you might need a reboot. What is your db block size ?
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
Other related posts:
