RE: controlfiles being updated
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 Sep 2007 12:39:38 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bradd Piontek
Sent: Tuesday, September 11, 2007 10:10 AM
To: lyallbarbour@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
<//www.freelists.org/webpage/oracle-l>
Other related posts:
