Control files issue

[Former Member]

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

[Former Member · Accepted solution]

Hi,

Which method do you use for the system refresh? As far as I understand, in a system refresh - we copy the data and log files onto the target and have to run the modified control.sql which actually creates the control files on the target system.

Can provide you more details if we know what method have you used.

Regards,

Srikishan

[Former Member · Accepted solution]

Hi,

How to find the control.sql ?

Yes, I have copied the data and the log files on the target system.

but I did not know anything about the control.sql. How can I find ? or where ?

Thanks,

J.

[Former Member · Accepted solution]

Hi,

the control file can be generated from the source system using the 'alter' command. This generates a file which needs to be copied to the target host and modified so as to contain the target SID details.

Detailed steps here: http://www.sap-img.com/basis/system-copy.htm

Please also check http://basissap.blogspot.com/, topic SAP Test Refresh. Pay special attention to step 17.

Regards,

Srikishan