SAP System Copy Backup Restore Method

          SAP System copy with "Backup and Restore Method" on Oracle database.

Restore Using Offline Backup: (System Copy Using Offline Backup) :

Source System:

OS- Windows Server 2003-64Bit, 

SAP: ECC6.0 SR3, 

Database: Oracle 10.2.0.4.0 64-BIT,

Backup Tool: BRTOOLS.

Backup Type: offline_force

SID: DEC

NOTE:- For Homogeneous System Copy OS, DB, SAP  Version and Patch Level should be same.
 Install  OS, Loopback Adapter, IP Address, Hostname,  JAVA, Set Environment Variables and Virtual Memory.
 Install DB & Required Patch
Start   sapinst
Install as Distributed System

                Navigate to Path

Next

 Next

       After Global Host Preparation then Install Database Instanse

Stop in Import ABAP phase

  Restoring The System with sap backup

Goto sapbackup

Delete all Data from sapdata1,sapdata2,sapdata3,sapdata4, origlogA,origlogB,mirrorlogA,mirrorlogB

Then Open  file bekgwyyr.afd with notepad and replace Source SID wid Target SID

Then Rename file backDEN.log as 

   Edit the  init<SID>.sap file

Open with notepad

Save the File 

then Open cmd and restore backup using Backup ( Login as <sid>adm )

Enter c

       After This edit Control file

Rename as control.sql

Delete everything Before STARTUP NOMOUNT and after “;” then save it.

Now open CMD and navigate to control.sql path

&
 Once the database is restored login as adm<sid> and run 

       NOTE:- Delete control files in target Systems from origlogA,origlogB,sapdata1 (create folder cntrl in    origlogA)
       sqlplus /nolog
      connect /as sysdba 
      startup nomount (if the database is already mounted shutdown it using the shutdown command)
      run the following command
     @controlfile.sql (file name of the control file contains the CREATE CONTROLFILE statement)

Now change the ownership of database  by running following script

Copy ORADBUSR.SQL and Paste any where 

      Paste in sapbackup and navigate the cmd path there open cmd and run following command in SQL

                And provide the following inputs in sequence Schema, OS, Hostname, SID

Now Drop the users  of old database

 Now login as administrator (OS user) and install  

Click Cancel

NOTE:- After that if you are unable to login with ddic then login with sap* and change the password of DDIC user and Apply SLICENSE.