Re: ORA-00600: internal error code, arguments: [20533], [2230], [557557500]

bdbafh_at_gmail.com wrote:
> Joel,
>
> What was your controlfile_keep_time?

D'Ohhhh.... that is different than the RMAN thingee...

> I believe that the default setting is 7 days - hence the need to
> re-create the controlfile.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmconfg.htm#446238 and
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch126.htm#1015367 don't say anything about recreating the controlfile?

>
> This is sounding familiar, but I don't have more details in front of
me
> currently.

I think this may be one of those things we see, fix, and forget 'cause once figured out it is so obvious. So they never get properly documented. Maybe somewhere in the docs it explains the control_file_record_keep_time v. RMAN window.

Let's see: cfrkt means how often the reuseable records (like archived logs and backup records) in the controlfile can be reused, while RMAN retention policy specifies the earliest time of recovery. So what must be happening is the over-7-day records are being reused, and RMAN is barfing trying to get them to check the 30 day window. That _is_ starting to sound familiar somehow. But my little bit of googling seems to only find about increasing cfrkt (though the second post in metalink 528707.994 made me chuckle).

And it also suggests merely changing cfrkt rather than rebuilding the controlfile.

Does it imply cfrkt _must_ be larger than the Retention Policy for a Recovery Window? Or have I thought myself into a corner?

>
> -bdbafh

(Thanks for the kick in the brain I needed)

jg

--
@home.com is bogus.
http://www.zenhaiku.com/archives/usability_applied_to_life.html