Oracle 10 Gb control file (1) -- restoration of partial control file loss

In oracle, the content of each control file is the same. A control file records the physical structure of the entire database. It contains the following information: 1. database Name 2. file Name and path of the data file and redo log file 3. for the sake of security, oracle usually sets 3-5 control files, which are specified in pfile or spfile, you can also specify some new control files in pfile or spfile. If some of the control files are lost, that is, if one or more of them are missing, the database cannot be enabled. Therefore, we can use the copy control file method to solve this problem. This process will be simulated below. When the database is opened, you can view the usage of the current control file in the v $ controlfile view: SQL> select name from v $ controlfile;

According to the above query results, we have used a total of three control files. Next we will delete part of the control03.ctl simulated control file in the/u01/app/oracle/oradata/orcl directory. Www.2cto.com $ rm control03.ctl

When the database is shut down and the database is restarted, a control file verification error is returned.

At this time, we can restore the control file by copying the control file, run the following command in the directory/u01/app/oracle/oradata/orcl where the control file is stored to copy a control file named control03.ctl. $ Cp control01.ctl control03.ctl

Therefore, the control file is restored. At this time, we try to open the database again. At this time, the database will certainly be able to be enabled successfully. As shown in:

Through the above steps, we can solve the problem that the database cannot be enabled due to the loss of some Database Control files. Author SkyWorld