on 03-06-2011 5:01 AM
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.