Oracle DBA Study Notes-Control Files

Previous:Oracle DBA Study Notes-start and close Databases
Next article: Oracle DBA Study Notes-log files (using logminer to analyze logs)
1Control File

 Control File Information:
The size of the control file is related to the settings when the database is created.

(1)Database creation time information

(2)Database Name, table space name

(3)Related data file, redo log file name, location, online status information

(4)Redo log archival information

(5)Sequence Number of the current redo log(Log sequence number).

(6)CheckpointInformation

(7)Undo the start and end information of a segment

(8)RMAN(Recovery Manager).

Query Control File Information

V $ controlfile
V $ controlfile_record_section

Information contained:

Desc v $ controlfile

Name status

StatusIf it is null, the control file is normal.

Select * from V $ controlfile

Select * from V $ controlfile_record_section (InMountWhen the status is queried, The nomount status only uses the initialization parameter file and does not use the control file.)

 

How to prepare sub-Control Files(The database must be closed.)
The control file must be backed up in multiple ways on different disks.

A.DatabaseShutdown

B. Two Methods

(1)Alter system set

Control_files = 'd: \ oracle \ oradata \ work \ control01.ctl ', 'd: \ oracle \ oradata \ work \ control02.ctl', 'd: \ oracle \ oradata \ work \ control03.ctl ',

'E: \ control04.ctl'

(2)Directly modify the parameterized FileInit. ora (D: \ oracle \ admin \ work \ pfile)

C. Two Methods
(1) ManualCopyA control file.(You mustCloseStatus to be copied. Otherwise, some information may be lost.)
(2) SQL> host Copy D: \ oracle \ oradata \ work \ control01.ctl E: \ control04.ctl

 
D.Restart