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

Oracle Online System Copy

We need to populate our T&D environment from the existing Prod environment. We can't do the OFFLINE database method for the system copy and I was wondering if it's possible to do the Online System copy using the database method. Our system is running on Oracle 10gR2. As a DBA I think that it should be possible, as I don't see any difference b/w the SAP Suggested Offline method and an Online consistent method. Any help would be greatly appriciated.

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 Oct 16, 2006 at 05:22 AM

    Dear Anup,

    Yes you can do that,Please refer the 'SAP Homogeneous System Copy Guide' for doing this.

    Steps involved for this are

    1)backup Control file to trace(On source system)

    2)Copy the datafiles,redologs & archive files from source to destination(make sure that datafiles should be in backup mode in source system)

    3)Edit the trace file(created at step 1) based on the requirements on the target system and create the control file.

    4)Mount the database and apply the logs to make it consistent.

    If you have any queries please revert back.

    Regards,

    Cherry

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 16, 2006 at 01:03 PM

    Is it true for all the SAP components? ABAP+Java?? Also can you supply me the link to the actual document that you are talking about? I have seen a document that talks about the offline system copy but not the online one. I will really appriciate it.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 17, 2006 at 08:02 AM

    Dear Anup,

    If u r a DBA U can do one thing which we tested for recovery drill

    Clone database by taking hot backup.( redo logs should not be backed up )

    Install SAP with Db exists option.

    You can ref above mentioned doc for guide lines.

    Let me know if u face any roblems

    Reply back

    Regards

    Vinod

    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.