- 05 Nov, 2021
- 0 Comments
- 1 Min Read
The control file error#ORA-00205#ORA-00202
THE CONTROL FILE ERROR#ORA-00205#ORA-00202
I met the ORA-00205 error while I modified the control_files parameter just like the following steps…
SYS@PRODCDB> alter system set control_files=’/data/app/oracle/oradata/PRODCDB/control00001.ctl, /data/app/oracle/fast_recovery_area/PRODCDB/control02.ctl, /data/app/oracle/oradata/PRODCDB/control00003.ctl’ scope=spfile; System altered. SYS@PRODCDB> shu immediate; Database closed. Database dismounted. ORACLE instance shut down. SYS@PRODCDB> !cp /data/app/oracle/fast_recovery_area/PRODCDB/control02.ctl /data/app/oracle/oradata/PRODCDB/control00001.ctl SYS@PRODCDB> !cp /data/app/oracle/fast_recovery_area/PRODCDB/control02.ctl /data/app/oracle/oradata/PRODCDB/control00003.ctl SYS@PRODCDB> startup ORACLE instance started. Total System Global Area 838860800 bytes Fixed Size 2929936 bytes Variable Size 608176880 bytes Database Buffers 222298112 bytes Redo Buffers 5455872 bytes ORA-00205: error in identifying control file, check alert log for more info SYS@PRODCDB>
What is the reason???
We can check the alert log for detail informations
ORA-00210: cannot open the specified control file ORA-00202: control file: ‘/data/app/oracle/oradata/PRODCDB/control01.ctl,/data /app/oracle/fast_recovery_area/PRODCDB/control02.ctl,/data/app/oracle/oradata/PRO DCDB/control03.ctl’ ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3
Do you understand what is the reason???
The comma position!!!! We should be very careful with the parameter.
Reset the control_files and restartup
Use the following steps, we can starup the database.
SYS@PRODCDB> startup nomount; ORACLE instance started. Total System Global Area 838860800 bytes Fixed Size 2929936 bytes Variable Size 608176880 bytes Database Buffers 222298112 bytes Redo Buffers 5455872 bytes SYS@PRODCDB> SYS@PRODCDB> alter system set control_files=’/data/app/oracle/oradata/PRODCDB/control00001.ctl’,’/data/app/oracle/fast_recovery_area/PRODCDB/control02.ctl’,’/data/app/oracle/oradata/PRODCDB/control00003.ctl’ scope=spfile; System altered. SYS@PRODCDB> SYS@PRODCDB> shu immediate; ORA-01507: database not mounted ORACLE instance shut down. SYS@PRODCDB> startup ORACLE instance started. Total System Global Area 838860800 bytes Fixed Size 2929936 bytes Variable Size 608176880 bytes Database Buffers 222298112 bytes Redo Buffers 5455872 bytes Database mounted. Database opened. SYS@PRODCDB>