It depend on system size and available time.
For small system you can do remote client copy.
Another option is to make client export on PRD system, then client import in Quality system.
For the large system is not any other way - just do system copy.
In few words:
make backup, remove Quality system from transport system and from CUA, resore on Quality system, re-create control files - to change the SID( Oracle), startup DB, several post-copy steps.
Here is plan that i follow :
Generally – follow note 147243. The difference in this procedure is that DB Load is not interrupted as is proposed in the note, but I wait for the initial installation to fully complete and then do the next steps.
1. Adjust memory parameters (Oracle, SAP) and page file of source system. If necessary adjust also number of work processes. This step is optional. Most often it is not done, instead of it the adjustments of the profiles are done later in the target system.
2. Trace the control file Control
3. Adjust created control file as for the target system – note 147243
4. Create new user with admin rights (put this user in ORA_DBA group)
5. Logon as this user (local/domain) and perform a new installation as per inst. guide
6. Do this only if this is a second SAP instance installed on the same host:
See note 576919 (Ora-12505). Oracle listener is changed during the installation. Adjust listener.ora
- if system fails on DBCONNECTTEST step (can occur if you install more than one instance on the same host), check if environment variable Local is defined. If it is, it should have the correct value for the SID and it must be defined as User variable, not as System variable. Also restart the computer. Then start the database of the new SID.
- Terminal services also can impact this error – note 441518. Note 556232 explains the environment settings.
- If error occurs on DIPGNTAB_NT see note 162266 and especially note 400241 (ora-1403 or ora 1017)
7. Patch Oracle of the target system, if necessary (to have the same patch level as in the source system)
8. Update Kernel of Target system (use the newest kernel available)
9. Stop Oracle
10. Delete on Target system
11. Copy or restore
12. Delete all copied in previous step Control files on the Target system !
13. Copy Oracle init
14. Adjust SAP profiles to the status of Target system (memory parameters, number of workprocesses, language parametrs, etc.)
15. Start Oracle Services
16. Modify Control
17. Database must be down. Execute Control
18. Start DB, Start SAP
19. If the system does not start, delete old OPS$ user and create it again (Note 50088) – only for R/3 4.6C
Only for BW (or system based on WAS 6.20):
- Use note 659509 in combination with 400241. Use the newest oradbusr.sql script to create new OPS$ user– it is attached to current version of note 50088. Change password/owner of SAPUSER table as described in 659509 – use old SID for the “ops$
ora
> connect / as sysdba
> insert into ops$
('
- Grant SAPDBA role to new OPS$ user:
GRANT CONNECT, RESOURCE TO “OPS$
In the examples below IPW is the source system, GRB is the target system.
- Give to the user default and temporary tablespace, for example:
ALTER USER "OPS$GRATHDB1\GRBADM" DEFAULT TABLESPACE PSAPIPWUSR
TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;
- Grant the necessary roles to new SAP
GRANT CONNECT, RESOURCE, SELECT_CATALOG_ROLE TO SAPGRB;
- Apply note 534765 to change dbs_ora_schema environment to the old SID (SID which owns SAP tables in the schema)
- Create OPS$SAPService user (example):
create user "OPS$GRATHDB1\SAPSERVICEGRB" DEFAULT TABLESPACE SYSTEM
TEMPORARY TABLESPACE SYSTEM IDENTIFIED EXTERNALLY;
- Grant necessary rights to OPS$SAPService user:
GRANT CONNECT, RESOURCE, SAPDBA TO "OPS$GRATHDB1\SAPSERVICEGRB";
- Create the synonym:
CREATE SYNONYM "OPS$GRATHDB1\SAPSERVICEGRB".SAPUSER FOR
"OPS$SAPBW\IPWADM".SAPUSER;
- Grant select update onto the SAPUSER table for SAPService user:
GRANT SELECT, UPDATE ON "OPS$SAPBW\IPWADM".SAPUSER TO "OPS$GRATHDB1\SAPSERVICEGRB”;
- Drop the old synonym:
DROP SYNONYM "OPS$SAPBW\SAPSERVICEIPW".SAPUSER;
- Start SAP system.
20. If the system does not start yet, apply note 8179
21. Post Implementation steps
These steps are derived from Homogeneous copy guide, section “post copy activities”
- Delete all irrelevant in SM59
- Delete old CUA settings, if exists (SCUA, BD64)
- SPAD – adjust printers
- Delete entries in tables:
sqlplus
connect sapr3/sap;
delete from DBSTATHORA;
delete from DBSTAIHORA;
delete from DBSTATIORA;
delete from DBSTATTORA;
delete from MONI;
delete from PAHI;
delete from OSMON;
delete from DBSNP;
delete from SDBAH;
delete from SDBAD;
delete from SDBAP;
delete from SDBAR;
delete from DDLOG;
delete from TPFET;
delete from TPFHT;
delete from TLOCK;
commit;
exit;
For systems based on WAS 6.20 check in Homogeneous Copy Guide for the tables, which entries must be deleted.
- Delete all unnecessary in SM37
- Execute SICK, SM28 (Installation check)
- SE06 (Choose DB Copy)
Start transaction SE06 and choose ‘Database copy or migration’. Click now the button Processing after installation [Execute].
Accept the given source system.
SAP will now ask if the originals have to changed from source system name to target system name. Only answer this question with yes if this installation doesn’t stay within the same landscape.
- SE38 -> execute report RSBTCDEL (mark field delete with force mode). This deletes old batch jobs by your criteria
- SP12 – Tempse Consistency
- Execute DB02
- Configure STMS
- RZ10 – import new profiles
- SE61 – adapt the logon text
- Adapt the picture after logon
- Delete unnecessary clients
- Import necessary requests
- Add the system CUA ?
- Install Documentation
Additional steps for BW only – follow closely note 184754
a) In the target BW, change the contents of field "target host" in all RFC connections (destinations) for R/3 and DataMart source systems (Transaction SM59) to a nonsensical, nonexistent address (such as 'nowhere'). Then delete ALL R/3 and DataMart source systems in the Administrator Workbench source system tree. Caution: This step deletes all PSA tables of these source systems - the data are lost! A message is generated stating that the source system cannot be accessed (since you deleted the host of the RFC connection). Select "Ignore".
Confirm on the request, until all transfer structures are not deleted – track this on “Transfer structure”. This operation deletes the transfer structures and transfer rules for the affected sourse systems. It asks also if you want to delete RFC destinations and Logical systems of the source systems (SALE).
“MySelf” Logical system (based on old
Release the request created during this procedure.
b) DO NOT create new Logical system (e.g. GRGRB400). In BDLS step this will be done automatically by the report RBDLSMAP
c) Follow note 121163
d) Before running BDLS, adapt ROLLBACK segments (if necessary)
No comments:
Post a Comment