Answer Posted / 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.

What are the errors you got while applying support pack?

1777

---

can any send unix admin doc? if u have please send it to chanduk29@gmail.com

1970

---

I am installing a sap j2ee engine at crm. When it reaches phase 22 it halts for more than 10 minutes and gives up starting the system. What should I do?

1099

---

What are the categories to execute sap background jobs?

1085

---

Why can't we do it thru some other client?

2002

---

How can you define login policy for users in sap system?

1111

---

Explain what is the importance of table t000?

1133

---

How to apply job on OS Level?

1775

---

What is private mode? When does user switch to user mode?

1166

---

What is R/3? and what is basis version?

1332

---

you want to do a system-copy. List the steps you will take.

982

---

I have solman 7.1 Stack3. I want to upgrade to stack13. My question is can I directly download stack13 files from marketplace, if yes, will those files includes xml file ? (MOPZ is not configured in my system).

1760

---

How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?

2322

---

What is the use of profile paramater ztta/roll_area?

1074

---

I want to let sap skip printing cover pages during printing for any kind of report. How can this be done?

1128

---