Restore a maxDB database

[Former Member]

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

[markus_doehr2 · Accepted solution]

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

[Former Member · Accepted solution]

Dear Markus,

We did not use MaxDB to start backup. Only VM backup.

Then, the P11 system has been restored to another VM.

I will test xuser command and contact you again if I have any issues.

With my best regards

SAP NetWeaverAdmin

[markus_doehr2 · Accepted solution]

> We did not use MaxDB to start backup. Only VM backup.

> Then, the P11 system has been restored to another VM.

I go that - and as of now this procedure is not supported to do system copies (as of now, there are developments ongoing). What you have done is basically a "host name change" of a system. See

Note 8307 - Changing host name on R/3 host: What do you do?

Markus

[Former Member · Accepted solution]

Dear Markus,

1. We stop SAP and Maxdb

2. We save all filesystem of our P11 system

3. We restart SAP and Maxdb

Then, we restore all fs to hostname33.

When we restart the P11 system in hostname33, it still connects to the MaxDB located in hostname11.

I will test "xuser -U ..." commands and send you back a feedback.

Thanks Markus

SAP NetWeaver Admin

[Former Member · Accepted solution]

Dear Markus,

The xuser commands does not work.

Option -U or -u is not supported ?

Thanks for your feedback.

Command 01

==========

hostname33:p11adm 52> xuser u2013U DEFAUTL u2013u SAPP11,pwd u2013d P11 u2013n hostname33 set

Unknown action: u2013U

Syntax: xuser [] [action] xuser 7.7.06 Build 010-123-204-327 (record format version: 3) Usage: List, clear or setup user specific connection information Description: This tool is used to predefine and manage default values for user data and connection options. Every data set is stored with an XUSER key. When connecting to the database without specifying an XUSER key, the key DEFAULT is used. Additionally specified command line options override the XUSER data. Command 02 =========== hostname33:p11adm 51> xuser u2013U c -u control,pwd u2013d P11 u2013n hostname33 set Unknown action: u2013U Syntax: xuser [] [action]

xuser 7.7.06 Build 010-123-204-327 (record format version: 3)

Usage: List, clear or setup user specific connection information

Command 03

===========

hostname33:p11adm 53> xuser u2013U w -u superdba,pwd u2013d P11 u2013n hostname33 set

Unknown action: u2013U

Syntax: xuser [] [action]

xuser 7.7.06 Build 010-123-204-327 (record format version: 3)

Usage: List, clear or setup user specific connection information

SAP NetWeaverAdmin

[Former Member · Accepted solution]

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