Control File of Oracle)

1: Description of Oracle Database Files

2: Oracle Doc definition of control file

3: three methods for searching ORACLE data files

4: FAQ

A control file is a small binary file that is part of the Oracle database. It is used to record the database status and physical structure.

Each database must have at least one control file, but it is strongly recommended that more than one control file be created. The backup of each control file should be stored on different disks.

1. The control file contains the following information:

1: Database Name

2: database creation Timestamp

3: data file name and location

4: redo log (online redo log file) name and location

5: Serial number of the Current Log

6: Checkpoint Information

7: Recent RMAN backup (I don't know what this is ?)

2. Search control file information in three ways

1: query the control file information in the V $ controlfile table.

SQL> select status, name from  v$controlfile;STATUS  NAME------- --------------------------------------------------        D:\APP\TOPWQP\ORADATA\ORCL\CONTROL01.CTL        D:\APP\TOPWQP\ORADATA\ORCL\CONTROL02.CTL        D:\APP\TOPWQP\ORADATA\ORCL\CONTROL03.CTL

2: You can use the control_files parameter to find the control file.

As previously mentioned, the control file information is defined in the startup parameter file spfile or pfile, so you can view this parameter to find the control file:

SQL> show parameter control_files;NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------control_files                        string      D:\APP\TOPWQP\ORADATA\ORCL\CON                                                 TROL01.CTL, D:\APP\TOPWQP\ORAD                                                 ATA\ORCL\CONTROL02.CTL, D:\APP                                                 \TOPWQP\ORADATA\ORCL\CONTROL03                                                 .CTL

3: run the following command to search for a file in the operating system:

D: \> DIR/s control *. the volume in CTL drive D is the soft volume serial number 000b-1fae D: \ app \ topwqp \ oradata \ orcl directory 9,781,248 control01.ctl2013/06/18 9,781,248 control02.ctl2013/06/18 9,781,248 control03.ctl 3 files 29,343,744 bytes

V $ controlfile_record_section lists the information in control_file.

You can modify the location of the control file in the following ways:

Alter system set control_files = 'file path/file name' scope = spfile

Scope = spfile indicates modifying the file address of control_file in spfile.

Note:
When oracle is started, it reads the startup initialization information,
The initialization information contains the location of the control file.
The control file contains the location of online redo log files and data files.

The size of these three control files is the same. It is best to place the three control files on different physical disks and write information to the control files concurrently, therefore, the content of the three control files is the same,
However, only the first control file is read. If one of the three control files fails, Oracle cannot be started.