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

Control files issue

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2011 at 08:05 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2011 at 08:21 AM

    Hai...

    There are two options

    1) Recheck the control files from other locations also and if exist then copy it to all locations

    i.e. /oracle/<SID>/sapdat1/cntrl

    /oracle/<SID>/mirrorlogA/cntrl

    /oracle/<SID>/mirrorlogB/cntrl

    and then try to restart the database.

    2) Your have to recreate the control files by direct or to trace

    ALTER DATABASE BACKUP CONTROLFILE TO TRACE, which generates a SQL script in the trace file to re-create the controlfile. If your database contains any read-only or temporary tablespaces, then that SQL script will also contain all the necessary SQL statements to add those files back into the database. Please refer to the ALTER DATABASE "BACKUP CONTROLFILE Clause" for information creating a script based on an existing database controlfile.

    i.e. SQL> alter database backup controlfile to trace as '/tmp/ctrl.trc';

    rename the trace file to required format, and try to restart.

    Cheers

    KHS

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      From the restore logs:

      RMAN-03002: failure of set command at 09/13/2011 15:50:18 ORA-01507: database not mounted

      BR0522E 0 of 20 files/save sets processed by RMAN BR0536E RMAN call for database instance NEW_SID failed

      The restore itself has failed. Hence the files do not exist. Do you use third party backup/restore tools via the backint interface?

      Regards,

      Srikishan

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2011 at 08:21 AM

    Hai...

    There are two options

    1) Recheck the control files from other locations also and if exist then copy it to all locations

    i.e. /oracle/<SID>/sapdat1/cntrl

    /oracle/<SID>/mirrorlogA/cntrl

    /oracle/<SID>/mirrorlogB/cntrl

    and then try to restart the system.

    2) Your have to recreate the control files by direct or to trace

    ALTER DATABASE BACKUP CONTROLFILE TO TRACE, which generates a SQL script in the trace file to re-create the controlfile. If your database contains any read-only or temporary tablespaces, then that SQL script will also contain all the necessary SQL statements to add those files back into the database. Please refer to the ALTER DATABASE "BACKUP CONTROLFILE Clause" for information creating a script based on an existing database controlfile.

    i.e. SQL> alter database backup controlfile to trace as '/tmp/ctrl.trc';

    rename the trace file to required format, and try to restart.

    Cheers

    KHS

    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.