How to do the system copy ?
can u plz expalin me step by step process
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.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
I am attempting to complete a system copy of bw. When I try to go in to rsa1 afterwards I get the error message, "entry in inbound table already exists." What should I do to solve the problem?
Difference between system refresh and client copy?
How you can assign an object to 100 roles at time?
What are the key activities that you perform as part of sap basis support?
What is sap market place?
before doing client copy you have to adjust table space at os level.what is the single command for that?(with out going through all the menu of brtools)
TMS Configuration?
Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?
What is your organization’s security philosophy? What level of security does your data require? How much risk are you willing to assume in each application area?
What is the use of profile paramater ztta/roll_area?
What is the use of Trusted system? I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system?
what post steps and pre steps db refresh
How to lock or unlock a transaction code using sm01?
dear friends, HOW TO CONFIGURE INTO ABAP WEB DYNPRO AND ADOBE OF ECC6.0 R/3 IDES SYSTEM?
How database extend?