Previous Topic: Restore to an Alternate Server that Cannot Support Exact Directory StructuresNext Topic: Sample util_par_file and Parameter Definitions


Restore Data to an Alternative Server Using the SAP BACKINT Agent

You can restore to an alternate location using the SAP BACKINT agent using the Arcserve Backup server. You must install the Arcserve Backup on Computer A and the SAP options on Computer B and Computer C.

To restore data to an alternate server using the SAP BACKINT agent

  1. Install the Arcserve Backup server component on Computer A.
  2. Install the Arcserve Backup Enterprise Option for SAP R/3 for Oracle on Computer C.
  3. From the Windows Start menu, click Start, All Programs, Arcserve, Arcserve Backup and click SAP R3 Oracle Option BACKINT Configuration on Computer C.

    Enterprise Option for SAP R/3 for Oracle Configuration dialog opens.

  4. Enter the Arcserve Backup name as Computer A and other details on the Enterprise Option for SAP R/3 for Oracle Configuration dialog.
  5. Install Enterprise Option for SAP R/3 for Oracle and Client Agent on the Computer B.
  6. Enter the Backup Server Name as Computer A in the Enterprise Option for SAP R/3 for Oracle Configuration dialog to configure the agent and server.

    Enterprise Option for SAP R3 for Oracle Configuration dialog

  7. Create a temporary folder SAPRestore under the C: Drive on the Computer B.
  8. Run brbackup.exe –d util_file –t online –m all on Computer C to back up full database.

    The backup process is complete.

    brbackup command

  9. Run brarchive -d utl_file -s on Computer C to back up archived logs.

    The archive logs are backed up.

  10. You must shutdown the CER database on Computer B.
  11. On the Restore Manager on Computer A, select Source, Restore by Session, and select the session, backed up in the step 8, containing the Configuration Files and Backup History Files of the Option.

    The files are selected.

    Configuration files and Backup History files

  12. Select Destination and clear Restore files to their original location(s) option.

    Restore files to their original locations option

  13. Add Computer B under the Windows Systems. Browse the Computer B, and select the temporary folder SAPRestore.

    Temporary Folder_Windows Explorer View

  14. Click Submit and start the restore process.

    The restore process is complete.

  15. On the Restore Manager on Computer A, select Source, Restore by Session and select the session, backed up in the step 9, containing the Configuration Files and Backup History Files of the Option.

    Select destination and clear Restore files to their original location(s) option.

  16. Add Computer B under the node Windows Systems. Browse the Computer B, and select the temporary folder SAPRestore.
  17. Click Submit on the toolbar to submit the restore job.
  18. Open the temporary folder to view the directory hierarchy. The directory hierarchy has cer as the directory of SAP Software, while product is the directory of Oracle Software and Oracle Home.
  19. You must now navigate the directory “C:\SAPRestore\product\10.2.0\db_1\database for the following files:
  20. Copy all the files except initCER.utl to the folder C:\ product\10.2.0\db_1\database to the Computer B. InitCer.utl is created automatically by BACKINT Configuration option.
  21. Navigate the directory C:\SAPRestore\cer\sapbackup for the database backup history files of SAP and copy them to the folder C:\cer\sapbackup, which is the SAP Software on Computer B.
  22. Navigate the directory C:\SAPRestore\cer\saparch for the Archived Logs backup history files of SAP and copy them to the folder C:\cer\saparch, which is the SAP Software on Computer B.
  23. Navigate the directory C:\SAPRestore\cer\sapreorg and copy the spaceCer.log file to the folder C:\cer\sapreorg, which is the SAP Software on the Computer B.
  24. On Computer B, run brrestore -d util_file -b last -m 0 to restore the Control File.

    The Control file is restored.

  25. On Computer B, execute the brrestore.exe –d util_file –b last –m all to restore the Control File.

    The Control file is restored.

  26. On Computer B, execute the brrestore.exe –d util_file –a 1-152 to restore the Archived Logs. The Sequence number (1-152) depends on what it generated when back up.

    The archive logs are restored.

  27. Log into the Database on the Computer B and start up the database to mount and recover it.
  28. Verify if the data is the same as the one on Computer C to complete the restore process.