How to do the system copy ?
can u plz expalin me step by step process
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / swathi
chk link
http://www.saptechies.com/system-copy-guides/
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
how to install sap help in sap 4.7
I also wanna work with Webdynpros? What are the requirements? I mean SAP 4.7 ee or ECC 5 or 6? Netweaver developer Studio? Also with win 2003 i have the activation problem every month. SO do i get a cd that doesnt ask for the activation? i have win 2000 but can it be installed on HP pavilion laptops that are coming preinstalled with Vista OS?
if a user says he couldn't print more than 312 records,what will you do?
What is organization level ?
When we install sap r/3 enterprise 4.7, there are several error messages in the sapview.log. What does this mean?
When you are Locking/Unlocking accounts what happens behind the scenes? Why is the good to know?
I want to find all non executed transaction list (user wise) for last three months one option is through st03n but in that i have to find by each and every t-code there is any facility to get this list user wise
What are common background jobs that will run in your system?
what is static profiles and dynamic profiles?
what is the prerequisite for doing sap release upgrade
what will you do when you cannot login to a dialog server ?
ABAP Service Pack level can be found in SPAM, but how to find the Java Stack Level?