Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ORA-00205: error in identifying control file

Dear all,

I copied the SAP Datafile 1,2,3,4 from source system (window server 2003 R2 and oracle 10.0.2.0.4) to Target system (Window server 2008 and 10.0.2.0.5) and took the trace file of source system. I changed the drive letters of Orig,Mirror and SAP Datafiles w.r.t. target system while the first line after edit the trace file is:

CREATE CONTROLFILE SET DATABASE "PRD" RESETLOGS ARCHIVELOG

SQL> startup
ORACLE instance started.

Total System Global Area 5251268608 bytes
Fixed Size                  2084872 bytes
Variable Size            2650804216 bytes
Database Buffers         2583691264 bytes
Redo Buffers               14688256 bytes
ORA-00205: error in identifying control file, check alert log for more info 

fyi...

please tell me. can we make data copy from different OS and oracle patch, if yes then how can i sort out the Error ORA-00205,

Regards,

replied

Hi,

Since your oracle version is on higher side it resembles a scenario of upgrade. In such a case you need to start your database using the command

SQL> startup upgrade;

Then run the script @catupgrd.sql

Post this you need to run the following commands

SQL> shutdown immediate;

SQL>startup

Regards,

Deepak Kori

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question