RE: controlfiles being updated

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 11 Sep 2007 12:39:38 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A90150380D@usahm208.amer.corp.eds.com>

The Control file records the structure of the database so structural changes such as altering a tablespace to add a datafile, adding a log group, etc... would result in an update to the Control files.  

• Mark D Powell -- Phone (313) 592-5148

  ---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bradd Piontek

	Sent: Tuesday, September 11, 2007 10:10 AM
	To: lyallbarbour_at_sanfranmail.com; oracle-l_at_freelists.org
	Subject: Re: controlfiles being updated
	
	
	If using RMAN, backup information would be written there. (heck,
I tihnk even i fyou use a catalog, some info is put there).
	information on archivelogs are stored there
	Adding and removing datafiles, resizing datafiles, new

tablespaces.         

        I'm sure I'm missing some.         

        Bradd                  

• Original Message ---- From: Lyall Barbour <lyallbarbour_at_sanfranmail.com> To: oracle-l_at_freelists.org Sent: Tuesday, September 11, 2007 8:36:43 AM Subject: controlfiles being updated

	Hi all,
	    Just a general question about controlfiles.  I was ready the

archive messages for this list and found out that controlfiles are updated everytime a checkpoint happens. Can anyone list any other reasons an update would happen to the controlfiles?         

	Thanks,
	Lyall Barbour
	
	<http://www.freelists.org/webpage/oracle-l> 
	
	
	

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 11 2007 - 11:39:38 CDT