DBA Hub

📋Steps in this guide1/1

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

in this blog i have explained you how to resolve ORA-00205 AND ORA-00202

oracle configurationintermediate
by OracleDba
13 views
1

Overview

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

Code/Command (click line numbers to comment):

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
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>

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

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>

Comments (0)

Please to add comments

No comments yet. Be the first to comment!