Skip to Content
  1. Pre – Requisites :
  • No of Drives should be same in both Source Server & Target Server. (Not Mandatory)
  • Drive Names should be same in both Source Server & Target Server. (Not Mandatory)
  • Installation of Database & SAP should be same in both Source Server & Target Server.

  1. STOP SAP & Oracle SERVICES AND EMPTY FOLLOWING  DIRECTORIES :

Go to Target Server & Stop all services (oracle & SAP both).

Now Delete the All files inside the following Directories.

SAPDATA_HOME\sapdata1\sysaux

SAPDATA_HOME\sapdata1\system

SAPDATA_HOME\sapdata1\temp

SAPDATA_HOME\sapdata1\undo

SAPDATA_HOME\sapdata1\cntrl

SAPDATA_HOME\sapdata2\ sr3_1 ………sr3_n

SAPDATA_HOME\sapdata3\ sr3702_1 ……… sr3702_n

SAPDATA_HOME\sapdata4\sr3usr_1

SAPDATA_HOME\origlogA\cntrl

SAPDATA_HOME\origlogB\cntrl

SAPDATA_HOME\sapdata1\cntrl

  1. PLACE BACKUP FILE IN SAPBACKUP DIRECTORY

Place the xxxxxxxx.and File In Sap backup Folder

SAPDATA_HOME \sapbackup

The File Name Will Be Like This belerzpm.and

  1. Open Cmd Prompt And Run This Command

BRRESTORE –m full –b xxxxxxxx.and –d disk –c

Now The Restoration Process Has Started

  1. Again Delete Oracle Control Files under these directories that comes after restoration  

SAPDATA_HOME \origlogA\cntrl

SAPDATA_HOME \origlogB\cntrl

SAPDATA_HOME \sapdata1\cntrl

  1. Create trace file in source server using this command:

SQL>Alter database backup controlfile to trace;

Copy this trace file to target server and rename to control.sql.

Now modify this control.sql

Delete all before “startup mount” & after “CHARACTER SET UTF8;” in control.sql

Change

  • <source SID> to <target SID> 
  • REUSE –> SET
  • NORESETLOGS –> RESETLOGS

            Now, Put this Control.sql to C drive on <TARGET SID>   SYSTEM.        

              Start Oracle Services

             SQL> @C:\CONTROL.SQL;   

  1. Copy all archive logs to SAPDATA_HOME\oraarch & Run these commands

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;     

SQL>ALTER DATABASE OPEN RESETLOGS;

  1. Create Users as per note 50088.

  1. Start SAP Services.
To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

  1. Thiago Cavalheiro

    Hi Yojesh,

     

    Thanks for the guide. I have just one heads up, the correct syntax to generate the controlfile code in the trace is:

     

    alter database backup controlfile to trace;

     

    Cheers,

    Thiago

    (0) 
  2. Balaji Guru

    Hi ,

    I have a basic query. The constraint to performing Sysem copy with Oracle DB can be done only if the backup is taken using brtools?

    If the backup type is of native Oracle backup taken using RMAN and TSM can we perform the System copy using backup/restore method.. Please clarify..

    (0) 
    1. Thiago Cavalheiro

      Hi Balaji,

       

      I am not a migration expert, but I believe the process should work with any kind of backup. What I can guarantee to you is that SAP doesn’t provide support for backups taken without the use of BR*Tools. So in case you have any problem during the restore, we’ll not be able to help you.

       

      Regards,

      Thiago

      (0) 
      1. Balaji Guru

        Okay thank you very much for clarifying.

        IF you can share your experience on one more query- I am planning to do a fresh installation of ERP 6.0 EHP7 (NW 7.4) using system copy method and in my source system I have SSFS enabled, so what should I follow(take precaution) after restoring/recover the source system backup on the target system for the SAP to connect to Oracle DB.

        I know in the previous release we would delete and recreate the OPS$sidadm users for the ABAP schema to connect to DB.

        I am aware of the SSFS setup but just that I am interested to understand how exactly the SSFS connection will work on the target after system copy using backup/restore mechanism..

         

        Please clarify..

        (0) 
        1. Thiago Cavalheiro

          Make sure you use the latest SWPM and it should handle the SSFS automatically. Kernel 7.40 onwards the old OPS$ mechanism doesn’t even work any longer.

           

          Cheers,

          Thiago

          (0) 
          1. Balaji Guru

            Ok thanks for the recommendaton.. But still not clear how the ABAP schema password is picked from file system when SAP has to connect to the database.Please share info which wil be helpful to handle issues if any arises.

            (0) 
            1. Thiago Cavalheiro

              Hi Balaji,

               

               

              Read the following notes about the topic:

               

               

              1639578 – SSFS as password storage for primary database connect

              1611877 – Support for ABAP SSFS during database connect

              1622837 – Secure connection of AS ABAP to Oracle via SSFS

               

               

              Regards,

              Thiago

              (0) 

Leave a Reply