Specific steps for failure recovery control file

Assuming that the control file is missing or corrupted, the instance is typically aborted.

Then, you must perform the following steps:

1. Close the instance (assuming it is still open).

2. Restore the lost control file by copying the existing control file. 3. Launch the instance.
Experiment:
1. When viewing the current control file
Show Parameter Control_files

2. Analog control File loss failure
!rm/home/oracle/control_bak/control03.ctl

Show parameter Control_files--the deleted control file still exists

3. Trigger Checkpoint Action
Alter system checkpoint;

4. Check the output of alert log
SELECT * from V$diag_info;

View in Alert
/u01/app/oracle/diag/rdbms/orcl/orcl/trace

Adrci--Under Oracle Users

   adrci> Show HomePath
   ADR Homes:
   DIAG/RDBMS/ORCL/ORCL
    adrci> set HomePath DIAG/RDBMS/ORCL/ORCL
   adrci> show HomePath
   ADR Homes: br>   DIAG/RDBMS/ORCL/ORCL
   adrci>
   adrci> help show alert
    adrci> Show Alert-tail
  --Error
Errors in file/u01/app/oracle/diag/rdbms/orcl/orcl/trace/ ORCL_M000_22432.TRC:
Ora-00210:cannot Open the specified control file
...
linux-x86_64 error:2: No such file or directory
  --related error log

5. Forcing the database to close
[email protected]>shutdown Immediate--Close database error
Ora-00210:cannot Open the specified control file
Ora-00202:control file: '/home/oracle/control_bak/control03.ctl '
Ora-27041:unable to open File
linux-x86_64 error:2: No such file or directory
Additional Information:3

[email protected]>shutdown abort
ORACLE instance shut down.

[email protected]>startup--still error when starting the database
ORACLE instance started.

Total System Global area 839282688 bytes
Fixed Size 2257880 bytes
Variable Size 507513896 bytes
Database buffers 327155712 bytes
Redo buffers 2355200 bytes
Ora-00205:error in identifying control file, check alert log for more info
--Unable to open database

6. Replace the control file with another control file
[Email protected] control_bak]$ Cp/u01/app/oracle/oradata/orcl/controlfile/o1_mf_b0fh9927_.ctl

Control03.ctl
[[email protected] control_bak]$ ls
Control03.ctl

7. Start the database
[email protected]>startup
--Successful start of the library

Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.

Specific steps for failure recovery control file