Difference between revisions of "Recovery as Normal Files(SAP R3)"
| Line 1: | Line 1: | ||
| − | Below documentation shows how to restore SAP R3 data after it has been recovered as normal files using steps as shown in [[ Recovery as Normal Files | Recovery as Normal Files ]]. Please recover the SAP R3 data files, | + | Below documentation shows how to restore SAP R3 data after it has been recovered as normal files using steps as shown in [[ Recovery as Normal Files | Recovery as Normal Files ]]. Please recover the SAP R3 data files, control file and backup id file as shown below. Once you have the files, please follow the steps to restore. |
{| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 600px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; | {| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 600px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; | ||
| Line 23: | Line 23: | ||
-rw-r--r-- 1 orats2 dba 20267008 Oct 21 11:57 cntrlTS2.dbf | -rw-r--r-- 1 orats2 dba 20267008 Oct 21 11:57 cntrlTS2.dbf | ||
| + | |} | ||
| + | |||
| + | |||
| + | ===Step 1=== | ||
| + | |||
| + | Copy/Move the backup id file (file with extension of .anf or .pff ) to default SAP backup location on the SAP R3 server. | ||
| + | i.e. /oracle/<SID>/sapbackup | ||
| + | |||
| + | e.g. bezoagvv.anf is the backup id file in our case and we have restored it to our sapbackup location which is /oracle/TS2/sapbackup/bezoagvv.pff | ||
| + | |||
| + | |||
| + | ===Step 2=== | ||
| + | |||
| + | Copy/Move the other files(data file, control file) to the SAP R3 client under a folder with the name of a backup id without the extension. | ||
| + | |||
| + | e.g. We have created a folder under /oracle/TS2/sapbackup named bezoagvv. And we have copied the files already there as shown below. | ||
| + | |||
| + | {| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 600px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; | ||
| + | | | ||
| + | sap-ora:orats2 66> pwd | ||
| + | /oracle/TS2/sapbackup | ||
| + | sap-ora:orats2 67> cd bezoagvv/ | ||
| + | sap-ora:orats2 68> ls -ltr | ||
| + | total 22445512 | ||
| + | -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 10:51 sr3.data1 | ||
| + | -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 10:57 sr3.data2 | ||
| + | -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:04 sr3.data3 | ||
| + | -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:10 sr3.data4 | ||
| + | -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:17 sr3.data5 | ||
| + | -rw-r--r-- 1 orats2 dba 1614815232 Oct 21 11:23 sr3.data6 | ||
| + | -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:30 sr3740.data1 | ||
| + | -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:37 sr3740.data2 | ||
| + | -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:44 sr3740.data3 | ||
| + | -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:50 sr3740.data4 | ||
| + | -rw-r--r-- 1 orats2 dba 1059069952 Oct 21 11:53 sr3740.data5 | ||
| + | -rw-r--r-- 1 orats2 dba 20979712 Oct 21 11:53 sr3usr.data1 | ||
| + | -rw-r--r-- 1 orats2 dba 734011392 Oct 21 11:55 undo.data1 | ||
| + | -rw-r--r-- 1 orats2 dba 209723392 Oct 21 11:56 sysaux.data1 | ||
| + | -rw-r--r-- 1 orats2 dba 450895872 Oct 21 11:57 system.data1 | ||
| + | -rw-r--r-- 1 orats2 dba 20267008 Oct 21 11:57 cntrlTS2.dbf | ||
| + | -rw-r--r-- 1 orats2 dba 18605 Oct 22 16:16 bezoagvv.anf | ||
|} | |} | ||
Revision as of 14:52, 30 October 2020
Below documentation shows how to restore SAP R3 data after it has been recovered as normal files using steps as shown in Recovery as Normal Files . Please recover the SAP R3 data files, control file and backup id file as shown below. Once you have the files, please follow the steps to restore.
|
sap-ora:orats2 62> ls -ltr total 22445512 -rw-r--r-- 1 orats2 dba 18605 Oct 22 16:16 bezoagvv.anf -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 10:51 sr3.data1 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 10:57 sr3.data2 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:04 sr3.data3 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:10 sr3.data4 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:17 sr3.data5 -rw-r--r-- 1 orats2 dba 1614815232 Oct 21 11:23 sr3.data6 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:30 sr3740.data1 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:37 sr3740.data2 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:44 sr3740.data3 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:50 sr3740.data4 -rw-r--r-- 1 orats2 dba 1059069952 Oct 21 11:53 sr3740.data5 -rw-r--r-- 1 orats2 dba 20979712 Oct 21 11:53 sr3usr.data1 -rw-r--r-- 1 orats2 dba 734011392 Oct 21 11:55 undo.data1 -rw-r--r-- 1 orats2 dba 209723392 Oct 21 11:56 sysaux.data1 -rw-r--r-- 1 orats2 dba 450895872 Oct 21 11:57 system.data1 -rw-r--r-- 1 orats2 dba 20267008 Oct 21 11:57 cntrlTS2.dbf |
Step 1
Copy/Move the backup id file (file with extension of .anf or .pff ) to default SAP backup location on the SAP R3 server.
i.e. /oracle/<SID>/sapbackup
e.g. bezoagvv.anf is the backup id file in our case and we have restored it to our sapbackup location which is /oracle/TS2/sapbackup/bezoagvv.pff
Step 2
Copy/Move the other files(data file, control file) to the SAP R3 client under a folder with the name of a backup id without the extension.
e.g. We have created a folder under /oracle/TS2/sapbackup named bezoagvv. And we have copied the files already there as shown below.
|
sap-ora:orats2 66> pwd /oracle/TS2/sapbackup sap-ora:orats2 67> cd bezoagvv/ sap-ora:orats2 68> ls -ltr total 22445512 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 10:51 sr3.data1 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 10:57 sr3.data2 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:04 sr3.data3 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:10 sr3.data4 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:17 sr3.data5 -rw-r--r-- 1 orats2 dba 1614815232 Oct 21 11:23 sr3.data6 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:30 sr3740.data1 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:37 sr3740.data2 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:44 sr3740.data3 -rw-r--r-- 1 orats2 dba 2097160192 Oct 21 11:50 sr3740.data4 -rw-r--r-- 1 orats2 dba 1059069952 Oct 21 11:53 sr3740.data5 -rw-r--r-- 1 orats2 dba 20979712 Oct 21 11:53 sr3usr.data1 -rw-r--r-- 1 orats2 dba 734011392 Oct 21 11:55 undo.data1 -rw-r--r-- 1 orats2 dba 209723392 Oct 21 11:56 sysaux.data1 -rw-r--r-- 1 orats2 dba 450895872 Oct 21 11:57 system.data1 -rw-r--r-- 1 orats2 dba 20267008 Oct 21 11:57 cntrlTS2.dbf -rw-r--r-- 1 orats2 dba 18605 Oct 22 16:16 bezoagvv.anf |