STEP BY STEP SYSTEM COPY ( Backup Restore)

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.