Restore Backup log file back<SID>.log and be*****.ant

[Former Member]

Dear all,

I have to restore sap oracle online backup from source server to target server. We have taken the backup of source server on tape. Now we have to restore that tape backup on target server. We don't have back<SID>.log and be*****.ant with us.

How can we restore the back<SID>.log and be****.ant tape first by which we can start the restore online backup on target server or without this back<SID>.log and be****.ant can we restore the backup on other location ( which i tried but not working, it is asking for back<SID>.log file.

Thanks

Ward

[Former Member]

We have taken the backup of source server on tape. Now we have to restore that tape backup on target server. We don't have back<SID>.log and be*****.ant with us.

Did you check these files on tape itself as you have taken the backup of the source server?

[former_member256254]

Hi Ward,

As long as you have complete oracle datafiles, restore without logfiles can be done.

1. As a precauition, copy all /oracle/<SID> to a safe place during offline state (SAP down, Oracle down)

2. Replace each datafile from tape to the current datafile location. e.g /tape/sr3.data1 -> /oracle/<SID>/sapdata1/sr3_1/sr3.data1

3. Make sure that archive logs is complete from the point where you start online backup.

4. sqlplus /nolog

5. startup mount

6. You will likely found error with controlfile. Replace all oracle controlfiles from tape backup, then repeat the startup

7. recover database until cancel using backup controlfile

8. choose the archive where you want the point of restore

Good luck