Answer / harry

#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.
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_HOMEsapdata1sysaux

SAPDATA_HOMEsapdata1system

SAPDATA_HOMEsapdata1 emp

SAPDATA_HOMEsapdata1undo

SAPDATA_HOMEsapdata1cntrl

SAPDATA_HOMEsapdata2 sr3_1 ………sr3_n

SAPDATA_HOMEsapdata3 sr3702_1 ……… sr3702_n

SAPDATA_HOMEsapdata4sr3usr_1

SAPDATA_HOMEoriglogAcntrl

SAPDATA_HOMEoriglogBcntrl

SAPDATA_HOMEsapdata1cntrl

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

Open Cmd Prompt And Run This Command
BRRESTORE –m full –b xxxxxxxx.and –d disk –c

Now The Restoration Process Has Started

Again Delete Oracle Control Files under these directories that comes after restoration
SAPDATA_HOME origlogAcntrl

SAPDATA_HOME origlogBcntrl

SAPDATA_HOME sapdata1cntrl

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;

Copy all archive logs to SAPDATA_HOMEoraarch & Run these commands
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

SQL>ALTER DATABASE OPEN RESETLOGS;

Create Users as per note 50088.
Start SAP Services.

Answer / swathi

chk link
http://www.saptechies.com/system-copy-guides/

Answer / purushotham

If you want ms sql server upgarde from MS SQL server 2000
to 2005.
In this upgrade you have to perform system copy procedure .
As well as DB upgrade secreen shots i will send .
plz mail me on ppsr_reddy@yahoomail.com

what is System tuning ? what are the activities involved in system tining?

1 Answers   Fujitsu,

---

What is the difference between kernel replacement and support package?

0 Answers  

---

Hi Al I have a small querry in SAP there are different type of Users one of them is System User I want to know why the system user is created and if created what is use of them and how they are associated with the Dialogue User ,As we all know Dialogue user can perform all work in Sap by logging in the sap server , so why the system user is created and how they are associated with Dialogue user With Rgds

8 Answers  

---

describe how SAP handles Memory Management?

0 Answers   IBM,

---

How to find sap transaction codes?

2 Answers  

---

I'm getting the following runtime error in IDES "DYNPRO_MSG_IN_HELP". GUI is 720 final release and patch level:0

1 Answers  

---

can i delete any record from table. if yes, what is Tcode for display table?

4 Answers  

---

how many max user's can apply for one application server? last limitation pls tell me in figure.

4 Answers  

---

What is the start up Sequence of Dual stack(ABAP+ JAVA) SAP system??

4 Answers   ABC, IBM, TCS,

---

Which type of Backup and Redo log backup is performed daily? And which type of Backup and Redo log backup is performed Weekly in the organization?

3 Answers   Infosys,

---

What will happen during the import process?

1 Answers  

---

What is purpose user group in SU01?

0 Answers   CLSS,

---