Skip to Content
author's profile photo Former Member
Former Member

SAP ECC System copy

Dear Friends,

I have to refresh my ECC qulaity server with my ECC production server using Databse restore method.

I have ECC 6.0 on HP-UX 11iv2 and Oracle 10g.

I have taken screenshot of all RFC connections, screenshot of STMS settings in our quality server and all the transport request have been transported in ECC prodcution from quality server.

What other things which needs to be taken care ?

If any one has does this activity, please share the steps ?

Regards

Ganesh Datt Tiwari

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2011 at 07:40 AM

    Hi,

    Addition to your steps, please find my first suggestion, below;

    1) Disabling scheduled jobs that does not need to be run on the QA system

    2) Changing logical client name by BDLS

    3) Disabling printers in order to avoid wrong outputs

    4) Scheduling DBA jobs on DBA calendar

    There tasks are additional tasks and can be applicable in your environment. You can find rest of it in the System copy guide

    Best regards,

    Orkun Gedik

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2011 at 12:18 PM

    Hi,

    When you performing the SYSTEM COPY using backup restore method we need to consider the below steps.

    1) Source system activities.

    Stop productive operation in source systems.

    a) Suspend the batch jobs using BTCTRNS1 report.

    b) Disable the communication in source system ( SM59 )

    c) Make sure redo log groups are archived.

    d) Generate the control file structure for the target database.Using below command.

    ora_br_copy.bat -generateFiles -forceLogSwitches -targetSid <Target_SID> -password <system_user_password> -listenerPort 1527.

    e) Create an offline backup of the source database.

    Re-enable all items that were deactivated prior to backing up <Target_SID>

    2) Target system activities.

    If the target system is being refreshed then first secure any information that you may require again once the restore is complete.

    a) Backup user master and authorization data from each client where this data needs to be used.

    b) Backup RFC tables to restore destinations afterwards.

    c) Printers devices backup.

    d) Release all open target system requests.

    e) Export ALE partner profiles.

    f) Document the registered developer's and objects if any.

    g) Document logon groups,STMS settings and client settings.

    h) Backup OS Level Files ( Profiles, exe and database)

    I hope above points will help you.

    And also recommend to go through the SAP guide before going to perform this activity.

    It will help you.

    Regards,

    Kiran .V

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Friends,

      I have restore all the tha data and created control file and database is up and running.

      But when i am trying to start SAP then it is giving the error message as below.

      Used parameter files:

      /usr/sap/QAR/SYS/profile/oracle/sqlnet.ora

      Used TNSNAMES adapter to resolve the alias

      Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = jkeccdq

      ) (PORT = 1527))) (CONNECT_DATA = (SID = QAR) (GLOBAL_NAME = QAR.WORLD)))

      OK (0 msec)

      tnsping: V2 connect to QAR

      -


      Thu Nov 17 10:16:51 IST 2011

      Connect to the database to check the database state:

      R3trans: connect check finished with return code: 12

      Database not available

      -


      Thu Nov 17 10:16:52 IST 2011

      Shutdown database

      First trying to shutdown the database - May be,

      the database is in the nomount or mount state

      -


      Thu Nov 17 10:17:15 IST 2011

      starting database

      SQL*Plus: Release 10.2.0.2.0 - Production on Thu Nov 17 10:17:15 2011

      Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

      Connected to an idle instance.

      ORACLE instance started.

      Total System Global Area 1.0469E+10 bytes

      Fixed Size 2067520 bytes

      Variable Size 1862271936 bytes

      Database Buffers 8589934592 bytes

      Redo Buffers 14708736 bytes

      Database mounted.

      Database opened.

      Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

      With the Partitioning and Data Mining options

      -


      Thu Nov 17 10:17:29 IST 2011

      Connect to the database to verify, that the database is now open

      R3trans check finished with return code: 12

      • ERROR: Startup of database failed

      Notify Database Administrator.

      /usr/sap/QAR/SYS/exe/run/startdb: Terminating with error code 12

      jkeccdq:qaradm 29>

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2011 at 09:09 AM

    Dear Friends,

    I am realy thankfull to all of you for valuable support.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.