System Copy preparation steps

[Former Member]

Hi Team,

We are using ECC6.0 SR3, Oracle 10.2.0.5 and OS - HP-UNIX

We need to perform system copy activity to refresh our QAS system with PRD data.

Now I checked all system copy guide but I do not find much information for steps which I need to perform before starting the DB export.

Like - User Master Record export, Steps for RFC destinations, Steps for ABAP varaint etc.

Please let me know what all steps I need to perform on my QAS System before import the PRD database on this system.

Regards,

Shivam Mittal

[Former Member]

Hi Shivam.

Homogeneous system copy procedure:

source system :

1. Take a backup from src system as files( xxx, xxx.log, xxx.afd, xxx.afd) and generate control file from src system and if system sid differs, make modification on the control files as changing into <sid>.

src system generation command : sqlplus

sql> alter database backup control file to trace;

Target system:

1. Install OS.

2. Install java and Oracle.

3. Install SAP with Distributed as 3 phases like 1) Global Host (3 of 28) 2) Database    (18/28), STop at Import Phase 18, and Do Restore  3)Central System

4. Now go to d-->oracle--> initsid.sap and change tape to disk and compress yes.

5. Stop Oracle Services.

6. Delete all datafiles

7. Go to cmd ,go to the path of sapbackup folder

   d:>brrestore -m full -b <filename>.afd(name same as folder available eg <file name>.afd) -c

   Here -m = mode

   -b backup type

   -c confirmation.(sql> brrestore -m full -b filemname.afd -c)

8. Now sap data files will be generated.

9. TRGT SYS- SQL> shutdown immediate (oracle shutdown)

11. SQL> @ control.sql

    controlfile created.

12. Now copy (ORADBUSR>SQL)

        SQL> alter database open reset logs:

    database open

    SQL>@Oradbusr.sql

    NOw  Enter the value 1: SAPSR3

    NOw  Enter the value 2: NT

    NOw  Enter the value 3: <Host name>

    NOw  Enter the value 4: Target <SID>

    Connected

14. Now go to SAPINST.exe start sap

    Phases will run and it ask ddic password (error comes)

    Install GUI --> Login with 000 client sap* password: admin pass admin123

15. now login to SAP and SLICENSE and get license key through hardware key and Install

    (Now you can create new users).

[nicholas_chang]

Hi Shivam,

From what i remembered:

1) Export user master data from source before refresh --> if you want to maintain QAS user data

2) Export RFC, secstore, saplicense table from source

3) Check STMS import history, since all imported TR will be removed once refresh from PRD data. You need to re-import TR which were imported to source QAS and not yet import to PRD

4) Do a screenshot on DB13, SCC4, STMS route and etc

5) backup SAP profiles & ora profile on source system

Hope it helps,

Cheers,

Nicholas Chang

[Former Member]

Hi Shivam,

I recommend you perform homogeneous system copy procedure. By doing so, you don't need to export the database(heterogeneous), and and prepare the new system faster by using backup/restore procedure (orabrcopy tool).

Because of you copied the database, you will be able to copy all the content such as variants, RFC destinations and so on.

Best regards,

Orkun Gedik