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

Restore a maxDB database

Dear SAP,

I want to restore my SAP P11 system (ERP, MaxDB 7.x) to another VM server.

But the restore system connects to the source database, not to its own database.

Let's summarize :

1. P11-Source is my ERP-Source system, which runs on hostname11.

2. P11-Restore is my ERP-Restore system, which is restored on hostname33.

I have saved (VM backup) my P11-Source into hostname33 VM server.

1. I have changed all DEFAUTL.PFL profile (replace hostname11 by hostname33).

2. I have copied START_DVEBMGS00_hostname11 to START_DVEBMGS00_hostname33

I have also modified the START_DVEBMGS00_hostname33 (replace hostname11 by hostname33).

3. I have also copied P11_DVEBMGS00_hostname11 to P11_DVEBMGS00_hostname33

Now, when I start my P11-Restore system on hostname33, it works.

BUT, P11-Restore system connects to P11-Source database from hostname11.

Which parameter do I have to change to connect P11-Restore system to its own database in hostname33 ?

With my best regards

SAP NetWeaverAdmin

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 23, 2011 at 01:10 PM

    Doing "manual" system copies using cloning is not (yet) officially supported. The logic of changing the hostname and SIDs in all necessary locations is done by sapinst, if you use that tool to do system copies you won't have those problems.

    However, to change the database connections you need to modify the xuser profiles of <sid>adm and SAPService<SID>. You have to change the keys DEFAULT, c (control) and w (superdba).

    xuser -U DEFAULT -u <user>,.<password> -d <SID> -n <hostname> set
    xuser -U c -u control,<controlpassword> -d <SID> -n <hostname> set
    xuser -U w -u superdba,<password> -d <SID> -n <hostname> set

    You have to do this for both <sid>adm and SAPService<SID> (if you run Windows).

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Markus,

      I have restarted the xuser command. It works, there is now no error.

      But it does not change the user definition :

      =================================================================

      XUSER Entry 4

      -


      Key :w

      Username :SUPERDBA

      UsernameUCS2:S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .

      Password :?????????

      PasswordUCS2:?????????

      Dbname :P11

      Nodename :hostname11

      Sqlmode :SAPR3

      Cachelimit :-1

      Timeout 🤯

      Isolation 🤯

      Charset :<unspecified>

      hostname33:p11adm 57> xuser set u2013u SUPERDBA,pwd u2013d P11 u2013n hostname33 u2013U w

      Result :

      XUSER Entry 4

      -


      Key :w

      Username :SUPERDBA

      UsernameUCS2:S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .

      Password :?????????

      PasswordUCS2:?????????

      Dbname :P11

      Nodename :hostname11

      Sqlmode :SAPR3

      Cachelimit :-1

      Timeout 🤯

      Isolation 🤯

      Charset :<unspecified>

      Any idea ?

      Best regards

      SAP NetWeaver Admin

      Edited by: SAP NetWeaverAdmin on Sep 26, 2011 6:18 PM

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.