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

Restore using brtools fail due to missing control files

Posted on Jun 08, 2011 at 12:13 PM 332 Views

Good day

i am trying to perform a restore an SAP Oracle 10 database using brtools and backint. I do not have the control files on disk. In brtools I used option 5 - Restore and recovery., then option 7 - Disaster recovery. I restore the profiles and log files from BRBACKUP backup. The option to restore the control file copy here is locked out. From the BRBACKUP logs I see the control file is being backed up though.

I then restore the profiles and log files from BRARCHIVE backup - it is possible here to restore the control file copy. The problem is that the control file was not backed up by BRARCHIVE - it does not show it in the logs either.

When I therefore choose option 1 - Complete recovery, the first task is to check the database files. The brtools utility stops because it does not find the control files.

how do I restore the control files?

Thanks

Wilhelm

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2011 at 12:35 PM
    0

    Good day

    >

    > i am trying to perform a restore an SAP Oracle 10 database using brtools and backint. I do not have the control files on disk. In brtools I used option 5 - Restore and recovery., then option 7 - Disaster recovery. I restore the profiles and log files from BRBACKUP backup. The option to restore the control file copy here is locked out. From the BRBACKUP logs I see the control file is being backed up though.

    >

    > I then restore the profiles and log files from BRARCHIVE backup - it is possible here to restore the control file copy. The problem is that the control file was not backed up by BRARCHIVE - it does not show it in the logs either.

    >

    > When I therefore choose option 1 - Complete recovery, the first task is to check the database files. The brtools utility stops because it does not find the control files.

    >

    > how do I restore the control files?

    >

    > Thanks

    > Wilhelm

    Hi Wilhelm,

    I assume that you are restoring the database into the same location. At this stage, you should check two foremost items, below;

    1) Oracle datafiles

    2) Offline redolog files

    If restored those files respectively, you can create a new controlfile and start your database respectively.

    Best regards,

    Orkun Gedik

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jun 08, 2011 at 12:45 PM

      I copied the procedure from my previous [answer|restore and apply online redologs into different directory;;

      1) Create control.sql by executing the command at the productive system, below;

      alter database backup controlfile to trace resetlogs;

      2) Goto "/oracle/<SID>/saptrace/usertrace" and open newly created trace file,

      3) Copy lines between "STARTUP NOMOUNT" and "-- Commands to re-create incarnation table" strings. Please note that these strings will not be included, just between of them

      4) Create a control.sql file by ora<sid> user and paste the SQL statement, at the 3rd step

      5) Now, you can change all the paths, regarding your needs in the file

      6) Now that you have a control.sql file, then you can create the control files,

      7) Delete all control files on the database. They have been determined in the SPFILE or init<SID>.ora file.

      8) On ora<sid> user

      a) sqlplus u201C/as sysdbau201D

      b) startup nomount

      c) @<path>\control.sql

      d) shutdown

      9) Now apply the online redolog files;

      a) startup mount

      b) recover database using backup controlfile until cancel;

      c) alter database open resetlogs;

      d) shutdown

      e) startup

      f) exit

      Best regards,

      Orkun Gedik

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2011 at 05:50 AM
    0

    Dear Wilhelm,

    5 Restore and recovery

    then

    4 Whole database reset

    will do it all.

    Kind regards,

    Gerd

    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.