Restore using brtools fail due to missing control files

[Former Member]

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

[Former Member]

Dear Wilhelm,

5 Restore and recovery

then

4 Whole database reset

will do it all.

Kind regards,

Gerd

[Former Member]

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

[Former Member]

I copied the procedure from my previous [answer|;;

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.

😎 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