SOLVED

The control file error#ORA-00205#ORA-00202

Asked by OracleDba••13 views•oracle

#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
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>
OracleDba•

Post Your Solution