System Copy - unable to create control file...

[Former Member]

Dear All,

After copying all the data files when I am trying to create a control file..it is getting created with .ctl extenstion.

controlfile/o1_mf_bxk3pysy_.ctl Iam unable to find .dbf control files after @control.sql command. Please assist.

Location where the control file is getting created - /oracle/RP1/oracleflash/SID/controlfile..

I am I missing any thing..why the .dbf control file is not getting created

Regards,
letz..

[Former Member · Accepted solution]

Hello Letz,

Please check following SAP link.

Point 6

Oracle Stage Copy Backup Restore for Non-Production Systems - Basis Corner - SCN Wiki

If the generated file in .trc format or any format. save it as name.sql.

Regards

Anand

[Former Member · Accepted solution]

Thanks..Anand Your solution work.

[Former Member]

Hello Letz,

where you able to resolve the issue.

Let us know if you have resolved it with solution.

Please close the thread if your query has been answered.

Regards

Anand

[former_member185239]

Hi Letz friend,

You need to run the below sql command to take the backup of control file

Alter database backup controlfile to trace,

It will create a trace file in usertrace directory.

/oracle/SID/saptrace/usertrace

With Regards

Ashutosh Chaturvedi

[former_member182657]

Hi,

Hope your issue has already been resolved by following Anand & the provided link by him.Anyways you need generate control file by execution of command "alter database backup controlfile to trace" & then convert or rename generated trace file with desired name of control.sql.(e.g)

Execution of control.sql will generate the control files for you.

In resume follow similar SCN thread at Homogeneous System Copy Steps Needed. | SCN

Hope this will help you.

Regards,