Skip to Content
avatar image
Former Member

How to build a new SAP system

Hello,

I am trying to find the steps to build a QA system from PRD online backup.

There was no prvious QA system and now i want to bring up a QA system. The direction that i need help with is around SAP build steps before and after DB restore using online backup. Any help to guide towards building this will be appreciated with points.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 30, 2006 at 04:39 PM

    You have to restore the databse with the PROD SID and it will end with warnings as the new QA SID will be different. Then script you will run to correct this is the one where you create the new controlfiles.

    once you create the controlfiles with the right SID, you have to Restore the database and your database will be restored.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2006 at 09:13 PM

    Hi learner,

    You have to change all profiles wherever necessary, change the names and the ports accordingly.

    Copying entire /usr/sap/SID directory will not do any harm, just change the names wherever necessary.

    You dont need to copy contents for origlog and mirrorlog dir's. Just have the dir's ready.

    You have to delete the cntrl files and create new ones because you have to restore the database first.

    Regards

    Suhail

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks Prince,

      I really appreciate your effort and time to help me.

      I am sorry that my question is not clear.

      I am aware that I have to rename the directories as /oracle/<Target SID> and substitute the <Source SID> with <Target SID> in all relevant places.

      Is there any explicit scrpits that i need to run to create the <SID>? That is my question.

      can i just substitute <Target SID> in place of <SourceSID> ? thats it?

  • avatar image
    Former Member
    Nov 28, 2006 at 07:20 PM

    Whats your OS and DB ?

    thanks

    Prince

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Prince,

      I have some questions regarding the system build. The thread link is very useful and i have posted the following in the link as well.

      Basically I have some specific questions as follows. Can you please guide me?

      1.Can you please specify if there is any other files needs to be changed for the SID and Hostname apart from .sapenv, .dbenv ,.login,.cshrc, .profile, start profile,instance profile, startsap script and stopsap script. Default profile needs to changed as well, am i right?

      2.Can i copy the /home/<SID>adm from Target or only specific files needs to be copied?

      3.When copying /oracle/ directory contents, does the contents needs to be copied for /oracle/<SID>/origlogA, /oracle/<SID>/origlogB, /oracle/<SID>/MirrorlogA and

      /oracle/<SID>/MirrorlogB?

      I belive during DB restore these contents will be deleted as a step so just the creation of these will be fine. Please let me know

      So this leaves the following oracle directories to be copied with its contents?

      /oracle/<SID>

      /oracle/<SID>/reorg

      /oracle/<SID>/oracleversion

      does the file structure creation be enough for /oracle/<SID>saparch since cntrl file and archive log files will copied from Source system?

      Please let me know