Skip to Content
author's profile photo Former Member
Former Member

System Copy - unable to create control file...

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2015 at 05:43 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 24, 2015 at 03:36 AM

    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,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 24, 2015 at 09:27 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2015 at 05:17 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.