6 Maintaining the Control File Copyright Oracle Corporation

Objectives • Explaining the uses of the control file • Examining the contents of

Using the Control File Control files Data files Redo log files Database 6 -3

The Contents of the Control File Database name Data file location Redo log file

Parameters Affecting the Size of the Control File The size of the control file

Obtaining Information • V$CONTROLFILE - NAME • V$PARAMETER - NAME ( control_file) - VALUE

Multiplexing the Control File control_files=(/DISK 1/control 01. con, /DISK 2/control 02. con) 6 -7

Summary Multiplexing the control file helps to avoid a single point of database failure.

Slides: 8

Download presentation

Objectives • Explaining the uses of the control file • Examining the contents of the control file • Obtaining the control file information • Multiplexing the control file 6 -2 Copyright � Oracle Corporation, 1998. All rights reserved.

The Contents of the Control File Database name Data file location Redo log file location Tablespace names Current log sequence number Checkpoint information Log history Backup information 6 -4 Copyright � Oracle Corporation, 1998. All rights reserved.

Parameters Affecting the Size of the Control File The size of the control file is influenced by the following parameters: • MAXLOGFILES • MAXLOGMEMBERS • MAXLOGHISTORY • MAXDATAFILES • MAXINSTANCES 6 -5 Copyright � Oracle Corporation, 1998. All rights reserved.

Obtaining Information • V$CONTROLFILE - NAME • V$PARAMETER - NAME ( control_file) - VALUE • V$CONTROLFILE_RECORD_SECTION - TYPE - RECORDS_SIZE - RECORDS_TOTAL - RECORDS_USED 6 -6 Copyright � Oracle Corporation, 1998. All rights reserved.