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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
