ORA-00221 ORA-00206 ORA-00202 ORA-27041 Error

Ora-00221 ora-00206 ora-00202 ora-27041 Error

In the SuSE Linux 11 + Oracle 11.2.0.3 environment,/oradata is mounted to the storage,

This evening, the storage controller was restarted due to a fault. However, the server had a dual-path mechanism. the restart of the storage controller did not affect the operating system's identification of the/oradata File System on the storage, that is, the file system can be accessed normally at the moment when the controller is restarted.

However, Oracle automatically shuts down and startup again. The error is as follows:

SQL> startup
Oracle instance started.

Total system global area 1.5667e + 10 bytes
Fixed size 2243752 bytes
Variable Size 7851737944 bytes
Database buffers 7784628224 bytes
Redo buffers 28151808 bytes
ORA-00221: Error on write to control file
ORA-00206: Error in writing (Block 1, # Blocks 1) of control file
ORA-00202: Control File: '/oradata/orcl/control01.ctl'
ORA-27041: Unable to open file
Linux-x86_64 error: 30: Read-Only File System
Additional information: 3

 

When this error is reported, it is first determined that/oradata may be interrupted when the storage controller is restarted, and then instantly switched to another controller. The control file control01.ctl is damaged. There are three control files in total, one of the control03.ctl files is stored on the local disk of the server. Therefore, you want to copy control03.ctl to replace/oradata with the corrupted control01.ctl file.

First, back up control01.ctl, but the error is that the read-only file cannot be modified,

[Email protected]:/oradata> Cd orcl/
[Email protected]:/oradata/orcl> ls
Abctest control01.ctl redo01.log redo02.log redo03.log redo04.log redo05.log redo06.log redo07.log sysaux01.dbf system01.dbf temp01.dbf login users01.dbf
[Email protected]:/oradata/orcl>MV control01.ctl control01.ctl. Bak
MV: cannot move 'control01. CTL 'to 'control01. CTL. Bak': Read-Only File System

 

Run the LS command to check whether control01.ctl has read and write permissions for oracle users.

[Email protected]:/oradata/orcl> LL
Total 1816884
Drwxr-XR-x 2 Oracle oinstall 4096 Oct 15 abctest
-RW-r ----- 1 Oracle oinstall 17154048 Oct 17 control01.ctl
-RW-r ----- 1 Oracle oinstall 52429312 Oct 17 redo01.log
-RW-r ----- 1 Oracle oinstall 52429312 Oct 17 redo02.log
-RW-r ----- 1 Oracle oinstall 52429312 Oct 17 redo03.log
-RW-r ----- 1 Oracle oinstall 52429312 Oct 15 redo04.log
-RW-r ----- 1 Oracle oinstall 52429312 Oct 15 redo05.log
-RW-r ----- 1 Oracle oinstall 52429312 Oct 15 redo06.log
-RW-r ----- 1 Oracle oinstall 52429312 Oct 15 redo07.log
-RW-r ----- 1 Oracle oinstall 629153792 Oct 17 sysaux01.dbf
-RW-r ----- 1 Oracle oinstall 744497152 Oct 17 system01.dbf
-RW-r ----- 1 Oracle oinstall 30416896 Oct 17 temp01.dbf
-RW-r ----- 1 Oracle oinstall 94380032 Oct 17 undotbs01.dbf
-RW-r ----- 1 Oracle oinstall 5251072 Oct 17 users01.dbf

It is strange that Oracle locks control01.ctl, but the Oracle instance is closed at this time.

 

Finally, I restarted the operating system of the server, and then started up without restoring control01.ctl.

That's strange ????

 

This article is from the "morning song muniu" blog, please be sure to keep this http://168ok8.blog.51cto.com/73394/1565341

ORA-00221 ORA-00206 ORA-00202 ORA-27041 Error