Maxdb Restoration Through DBMGUI

[Former Member]

Hi,

I have complete data backup on EIM server.

I installed new server with SMP,once the installation is completed.I restored the EIA backup in SMP server,showing message restoration successful,but iam unable to connect the server.Any query we have to run to change the SID.Guide me for the same how to change.

Mine environment is Linux with Maxdb.

Thanku

[markus_doehr2 · Accepted solution]

> I installed new server with SMP,once the installation is completed.I restored the EIA backup in SMP server,showing message restoration successful

How did you restore the instance?

> ,but iam unable to connect the server.

What error do you get?

> Any query we have to run to change the SID

did you follow the system copy guides?

Markus

[Former Member · Accepted solution]

Hi,

Thanks,I freshely installed sap server (with SID:SMP),installation was successfully completed.

Iam having another sap server(with SID:EIA),i took the completed backup of EIA Server.

Now i restored the EIA back up in SMP server through DBMGUI with Recovery option,its shoing restoration was successfull.

After restoration, with SMPADM : sap will starting successfully,but dispatcher is not running iam unable to connect sap server.

millprod:smpadm 23> startsap

Checking ADA db Database

-

---

Database is not available via R3trans

Running /usr/sap/SMP/SYS/exe/run/startdb

Trying to start database ...

Log file: /home/smpadm/startdb.log

Database already running

/usr/sap/SMP/SYS/exe/run/startdb completed successfully

Starting Startup Agent sapstartsrv

-

---

Instance Service on host lgsmillprod started

Starting SAP Instance DVEBMGS00

-

---

Startup-Log is written to /home/smpadm/startsap_DVEBMGS00.log

Instance already running

Starting SAP-Collector Daemon

-

---

18:48:56 27.08.2010 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.95 701 - v2.00, AMD/Intel x86_64 with Linux, 2007/02/16

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 4268) is already running .....

************************************************************************

saposcol already running

but dispatcher is not running :

dpmon pf=SMP_DVEBMGS00_millprod

DpMonInit failed - possibly no dispatcher running

DpMon: External/Internal dplib version: 110/241

Thnaku

[Former Member · Accepted solution]

Hi,

Any suggestions.

Thanku

[markus_doehr2 · Accepted solution]

- Did you do a Restore only or "Restore with initialization"?

- Did you load the system tables after the restore was done?

- Could you bring up the database normally?

Markus

[Former Member · Accepted solution]

Hi,

Thanks markus,

Did you do a Restore only or "Restore with initialization"?

I Restored with option : Restore with initialization"

- Did you load the system tables after the restore was done?

- I didnt do any thing after restoration

- Could you bring up the database normally?

- Database showing online mode only.

Thanku

[former_member229109 · Accepted solution]

Hello,

Please see the SAP note 1014782.

If you used backup and recovery to perform a homogeneous system copy of a MaxDB database instance,

Please follow recommended steps of SAP Note 129352< pay attention to c),d) and e) steps >.

Please login as smpadm to the server millprod and run:

R3trans u2013d

and post output.

Regards, Natalia Khlopina

[Former Member · Accepted solution]

Hi,

Thanks,

R3trans -d out put is below.

This is R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ADABAS D --- DBNAME = ''"

R3trans finished (0012).

Thanku