First page Back Continue Last page Graphics

…Control File Creation

CREATE DATABASE MAXLOGFILES 5
- Control file contains 5 records of type “REDO LOG”.
CREATE DATABASE MAXDATAFILES 100
- Control file contains 100 records of type “DATAFILE”.
CREATE DATABASE MAXLOGHISTORY 1
- But, control file created 226 records of type “LOG HISTORY”.

Notes:

Here are some notable comparisons between the CREATE DATABASE on the previous page and this example:
CREATE DATABASE MAXLOGFILES 5 – And the control file contains 5 records of type “REDO LOG”. Only 3 are used because the CREATE DATABASE command only specifies 3 log files.
CREATE DATABASE MAXDATAFILES 100 – And the control file contains 100 records of type “DATAFILE”. Only 6 are used because so far only 6 datafiles have been created.
CREATE DATABASE MAXLOGHISTORY 1 – But the control file created 226 records of type “LOG HISTORY”. These record information about log switches. This is not documented, but I believe this is the minimum (and default) for a Windows 2000 system.
Note that only 13 records have been created for “ARCHIVED LOGS”. There is no documented control for this on the CREATE DATABASE command. Certainly, we will want to keep history for more than 13 archived logs. This will happen because additional records will be dynamically added to the control file, causing the control file size to increase. See the next page for more information…