Unable to restore the backup

[Former Member]

Dear All,

I have an ECC system which is running on oracle 10G.

I have taken the backup with BRTOOLS. now my system is crashed and including with my /oracle/SID/sapbackup directory also.

When i am trying to restore with the backup i have taken it is asking me for the offline log(.aft) and backSID.log

Please gude me how to restore with out those logs.

But i checked the backup log of other systems i found that finally it is writing those log files also into the tape.

how can i restore without those logfiles or how can i recover those 2 log files from tape.

Thanks in advance,

Chaitanya Krishna,

[Former Member]

Hi Krishna,

Recovering those 2 files from tape is simple.

Step 1. Use Brtools go to option 5 Restore and recovery

Then again select option 5 Restore of individual backup files

Then continue again conutinue.

Select option 3 Restore individual files from tape

Then give input for 3 Backup file name:- (your .aft file name and then .log filename)

Then give input for 4 Restore destination :- give restore location on your harddisk

Then continue

It will ask you for tape provide the tape and get those required 2 files and copy them to sapbackup folder.

Hope i answer your question.

Best luck,

Atil

[former_member204746]

put last tape backjup in your drive, then:

brrestore -n sum_log

brrestore -n det_log

now , you should have backSId.log and AFT.log

you can run a normal brrestore.

if unsure, run BRRECOVER, it will help you recover you system completely.