| |
 |
|
Donald K. Burleson
Oracle Tips |
Oracle Developmental Responsibilities
* Names of the database and redo log
files
* Timestamp of database creation
* Begin/end of rollback segments
* Checkpoint information
* Current redo log file sequence number
This data is critical for database operation, and at least one
control file is required for database startup. There are methods for
rebuilding a control file, but it is much easier to maintain--or
rather have Oracle maintain--multiple copies of the control file.
Oracle recommends two copies on separate disk resources. For OFA
compliance, three are required. Obviously, if they are on the same
platter or are placed in the same stripe set, the same disaster can
waste all of them; therefore, they should be placed on different
physical disk arrays if possible. More than three copies is a bit
paranoid, but if it makes you feel safer, have as many as you wish;
only one usable, current file is required for startup.
This is an
excerpt by Mike Ault’s book “Oracle
Administration & Management”. If you want more current Oracle tips
by Mike Ault, check out his new book “Mike
Ault’s Oracle Internals Monitoring & Tuning Scripts” or
Ault’s Oracle Scripts Download.
|
