Skip to Content
0
Former Member
Sep 14, 2011 at 07:56 AM

Control files issue

680 Views

Hello,

I am doing system copy (new sandbox) , and I have some troubles with the Oracle start.

SQL> startup

ORACLE instance started.

Total System Global Area 1929379840 bytes

Fixed Size 2097344 bytes

Variable Size 452988736 bytes

Database Buffers 1459617792 bytes

Redo Buffers 14675968 bytes

ORA-00205: error in identifying control file, check alert log for more info

-


SQL> show parameter control_files;

NAME TYPE

-


-


VALUE

-


control_files string

/oracle/SID/origlogA/cntrl/cnt

rlSID.dbf, /oracle/SID/origlog

B/cntrl/cntrlSID.dbf, /oracle/

SID/sapdata1/cntrl/cntrlSID.db

f

-


but I have no control files in those folders.

/origlogA/cntrl:] ls -lart

total 0

drwxr-xr-x 4 orasid dba 256 Sep 11 10:57 ..

drwxrwxrwx 2 root system 256 Sep 13 19:00 .

-


What can I do ?

Should I copy all the cntrlSID.dbf from the old server in the new one and rename the files and all their content with the new SID instead of the old one ?

Please help,

Jordan.

Edited by: Jordy_tof on Sep 14, 2011 9:57 AM

Edited by: Jordy_tof on Sep 14, 2011 10:02 AM