Thursday, February 2, 2012

HOMOGENEOUS / HETEROGENEOUS / DB REFRESH PROCEDURE IN INTERVIEW PATRON POST & PRE STEPS


SYSTEM COPY. HOMOGENEOUS/HETEROGENEOUS/DB REFRESH.
  • System copy is a process of setting up a new system using a copy/backup of existing system.
  • It is required in the following scenarios.
                                I.            H/w migration.
                              II.            Os/db migration.
                            III.            Testing the backup of sap system.
                            IV.            Patch application and kernel upgrade.
                              V.            Sap upgrade.
                            VI.            To test the developed objects before moving to production.
                          VII.            To setup a sandbox, testing of training system in the landscape.
  • There are various ways to perform a system copy.
§  Homogeneous system copy- if there is no change in the database of operating system. Homogeneous system copy can be performed by following methods.
1.       File system copy.
2.       Database backup and restore (db specific method).
3.       Sapinst tool export and import.
Note: option 3 is the only method for heterogeneous copies/Unicode conversions, net weavers system based on java. For heterogeneous system based on oracle and db2. Sap also supports db specific methods using br tools.
§  Heterogeneous system copy- if there is a change either in the os or db of the target system. It has to be performed by a os/db migration certified consultant.
  • If the system is setup as new system then it is referred as system copy/installation os,  db, erp, restore/import is required for which no [re steps are required i.e the system is completely built from os, db and r/3 without changing os or db.
DB REFRESH:
The system exists with os, db, erp (sap component). Which is refreshed (replaced) by the database of any other system mostly PRD in the landscape. In such cases the source dependencies need to be documented or transported to revert them back after the refresh.
HOMOGENEOUS SYSTEM COPY(FILE SYSTEM COPY)
1.       Take full offline backup of database using  BR Tolls/DB 13.
Directly using the single line command of brtools
Brbackup –u –p init<sid>.sap –d disk –t offline –m all
or go through the br tools menu
Select 4th option –backup and database copy
Select 1st option –database backup
Select 2nd to change backup device type to disk
Select 6th to change backup type to offline_force type c for continue
Select 3rd option of menu for compression mode and set to yes. And the backup starts and in b/w asks for prompt continue, then type c to continue.
2.       Generate of control file.
è By generating trace file at os level (this method is used for /DB refresh )
Sql> alter database backup controlfile to trace
We can find the trace file in oracle/sid/saptrace/usertrace. Copy it on the desktop and do the modifications.
Remove all the lines above “STARTUP NOMOUNT” below CHARACTER SER UTF8;  save the file.
Replace S_sid with T_sid.
Replace REUSE with SET.e
Replace NORESETLOGS with RESETLOGS.
Replace ARCHIVELOG with NOARCHIVELOG.
Copy the init<sid>.ora and init<sid>.sap from source system(oracle/sid/102/database) and change the source S_sid with T_sid.
è  By using ORABRCOPY tool (java tool to generate control file)
ORABRCOPY is available as .SAR file in instmaster/im_windows_i386/common/dbtools/install /ora
Create a new directory copy the .sar file full permission, login to <Sid>adm and uncar using the command SAPCAR –XVF ORABRCOPY.SAP
It will generate 3 files
1.       Ora_br_copy.sh ------- used for linux os.
2.       Ora_br_copy.bat -------used for windows os.
3.       Orabrcopy .jar.
Now generate the control file using (orasid)
Ora_br_copy.bat -generateFiles –forceLogSwitch –targetSid < **> -password <******>  -listnerPort 1521
It will generate control.sql(target system) and control.trc(source system) and init<sid>.ora (target system).
Compare control.sql with control.trc and change according to control.trc file in control.sql file.
Copy the init<sid>.sap from /oracle/sid/102/database of the source system and change S_sid with T_sid.
3.       Target system preparation
Ø  Install os and oracle with same patch level as source.
Ø  Go to installation master and run Sapinst and select as below
n  Sap net wear 2004’s support release.
n  Sap system.
n  Additional life cycle tasks.
n  System copy.
n  Oracle.
n  Target system.
n  Central instance as abap.
Ø  Click ok.
Select the custom option. It will ask for log off click ok.
Select the java component.
Select the jdk directory.
Select the jce policy archive.
Provide sap sid .<T01>
Installation drive<e:>.
Enable Unicode system.
Ø  Provide the password.
Ø  Select local installation.
Ø  Provide os user password.
Ø  Select homogeneous system copy.
Ø  Provide db sid. it will show a reference error
Ø  Go to installation directory (pf/sap_instdir/nw045/lm/copy/ora/system/central/as/edit control.xml.
Search for update ORACHECK_PAR                 and delete line row. Create Db= false and restart the installation.
Ø  Provide the DB system parameters.
Ø  Select the DB system driver for installation
Ø  Provide standard database users
Ø  Click next for 4 times
Ø  Select kernel and oracle client path
Ø  Now it will ask to restore the db data. Click ok
Ø  Copy the init<dbsid>.sap from source system. Replace S_sid with T_sid and place it in target system /oracle/sid/102/database directory.
Ø  Copy the init<dbsid>.ora from source system and replace S_sid with T_sid and place database directory.
Ø  Copy control.sql file and place it in the target system installation directory.
Ø  Change S_sid with T_sid in b*****.afd log file which is generated during the offline backup.
Ø  Create the folders mirrlogA, mirrlogB, oraarch, saparch, origlogA/cntrl, origlogB/cntrl, sapbackup. Sapcheck, sapdata1/cntrl, sapdata2, sapdata3, sapdata4, sapreorg, saptrace/background and usertrace.
Ø  Copy the backup of source system and keep in the target system sapbackup directory.
Ø  Switch the user  <sid>adm and restore the db using
brrestore –u –b b*****.afd –d disk –k yes –m all
-k denotes compress  mode
-d means device type
-b backup log file
Ø  Click ok to continue and the target system installation will complete itself.
Ø  To ensure that the system copy is done successfully or not. We have to calculate the count of the tables before and after the system copy
RSTABLESEZE, TADIR, DD02L, TFDIR, TSTC, patch level, tables related to material master (MARA), vendor master (LFA1), plants and storage locations (T001l),RFCDES for RFC connections.
Ø   RSTABLESIZE is the report used to find the size of client patch level (ABAP,BASIS,APPL & HR) –screen shots.

 See Related posts
26.DISABLE SAP USERS TO LOGON MULTIPLE TIMES27.SUPPRESS SAP MULTI LOGIN MESSAGE28.ADDING TEXT TO THE SAP LOGON/LOGIN SCREEN


Reactions:

8 comments:

Hello Sir,
The information you gave is very handy to get an skillsets.I am very much satisfied with your info. we also provide online training
on SAP OS DB MIGRATION ONLINE TRAINING .This ensures that the required "know-how" is available to deal with the
complexity of the situation. SAP OS DB MIGRATION ONLINE TRAINING check for the operating system or
the database to migrate production systems.

SAP OS DB MIGRATION ONLINE
TRAINING

Best Post about SAP Courses and the Training. Helps the readers to get better knowledge on Current SAP Technologies.The service delivery then includes all the systems in that system landscape. If you want full support for the migration (be it a production system or not) then you must secure the services of a technical consultant with special certification for OS/DB migration.
SAP OS DB MIGRATION ONLINE TRAINING

hi, nice explanation about sap sd online training . It is more effective and interest for learners.

Hi Sir, you provided great info on sap wm online training it is interesting and useful for the starters, i feel it is right place to get info, thanks for the info and keep posting more.

This comment has been removed by the author.

SAP HANA training in hyderabad,This is the best path You can Learn COmplete Course with full fledge knowledge of SAP.SAP HANA training in hyderabad

CALFRE handles oracle fusion financials online training and its modules maintaining classroom based training with the self-paced videos. An expert having ten plus years of self-experience handles the training period through online and explains each and every point perfectly. We recently launched our institute in the USA and getting the best reputation over there


Oracle fusion Financials Online Training in Ameerpet

Oracle Fusion Financials Training in Ameerpet

Hi!!

The information has been given by this blog,which is very informative and truly helpful,for who are looking for SAP MM TRAINING in Hyderabad.sieve software is the best
sap mm training and placements in Hyderabad.

Post a Comment