Re: control_file_record_keep_time

Note that starting from 8.0, the controlfile can dynamically grow, thus instead of overwriting reusable sections before their keep time expires, controlfile is expanded instead. Only reusable records can be overwritten after control_file_record_keep_time days. These include log history, archive history, rman records etc.. which are not crucial for running your database anyway. It might affect some custom backup scripts or rman nocatalog operations, though.

Select from v$controlfile_record_section to get a brief overview about your current controlfile state (check records_total, records_used to check % of record usage and first_index to see where writing occurring in full circularbuffer). If you want to get more information, you can dump controlfile information to trace using: alter session set events 'immediate trace name controlf level 3'; or use level 10 if you wan't very detailed information.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, September 20, 2003 12:39 AM

>
>
>

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch126.htm#1015367
>
> I backup once a week. Default as per the manual is 7 days.
> I might skip taking backup due to various reasons i a week. How will
> i ever know what % of my control file records are avbl.for
> rewriting and that i will not run into any error?
>
> Thanks
>
> Quriyat
>
> _______________________________________________
> No banners. No pop-ups. No kidding.
> Introducing My Way - http://www.myway.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: quriyat
> INET: quriyat_at_myway.com
>
> 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: ListGuru_at_fatcity.com (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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: ListGuru_at_fatcity.com (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).