System Copy With MaxDb ver. 7.5

[Former Member]

Hi!

I'm trying to perform a System copy of my MaxDB (rel. 7.5).

I want to restore a backup of my production system on my TEST system.

I have read the SAP notes:

129352 and even 457425.

This my procedure in brief:

1. perform a full backup on PRD system

2. Copy the backup file from PRD system to TST system

3. Try to start with the Recover (with initialization) of my backup. I choose the option Recover a medium. The medium is the same as I have on the source system (same properties).

Receive this error:

In the error log file:

ERR 52012 RESTORE error occured, basis_err 3700

ERR 18499 IO Wrong path 'G:\BCKPRD\PRD_BACKUP_COMP' (this is the path to my backup file)

In the Dialog file:

ERR 52012 RESTORE error occured, basis_err 3700

CONNECT Connection released, T4

CONNECT Connect req. (T4, Node:'', PID:2380)

CONNECT Connect req. (T37, Node:'', PID:2380)

VOLUMEIO Attaching volume 'O:\sapdb\TST\sapdata\DISKD0001

Any suggestion ?

Is there something I missing ??

regards

Pierfrancesco

[Former Member · Accepted solution]

Hello ,

there is no easy way how to find out SAPPRD password

however you can change the password if you know superdba

password

following SAP notes should be your guides:

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

39439 - XUSER entries for SAP DB 6.x and 7.x

25591 change user passwords

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

1)

log in SQLstudio with superdba and execute command:

alter password SAPPRD <new pw>

2)

configure xuser data with correct pasword for

user/users starting sap (like <sid>adm and foe WIN also SAPService<sID>)

dbmcli -n <database server> -d <DBNAME> -u SUPERDBA,<password> -uk

DEFAULT -us SAP<SID>,<new_password>

3)

change integration information in transaction db59

Regards

Ivan

[Former Member]

THX to everybody!

[Former Member]

hello Pierfrancesco,

this is only guess but from:

G:\BCKPRD\PRD_BACKUP_COMP

is this path : G:\BCKPRD

and this is backup file it self ? PRD_BACKUP_COMP

or this is whole destination only and backup file have different name

G:\BCKPRD\PRD_BACKUP_COMP\<backupfile>

in DBMGUI you need to specify whole location/file

if this does not help please provide relevant part of dbm.mmm file

Ivan

[Former Member]

Hi Ivan

this G:\BCKPRD\PRD_BACKUP_COMP is the full path (PRD_BACKUP_COMP is the name of the backup file).

Which files do you need ??

regards

[Former Member]

This is my dbm.mmm (only the part of interest)

[PRD_BACKUP_COMPLETE]

LOCATION=G:\BCKPRD\PRD_BACKUP_COMP

TYPE=FILE

SAVETYPE=DATA

SIZE=0

BLOCKSIZE=0

OVERWRITE=YES

AUTOLOADER=NO

OSCOMMAND=

EXTERN=NONE

CREATED=20080917162937

MODIFIED=20080917162937

[PRD_TEST]

LOCATION=G:\PRDBACKUP

TYPE=FILE

SAVETYPE=DATA

SIZE=0

BLOCKSIZE=0

OVERWRITE=NO

AUTOLOADER=NO

OSCOMMAND=

EXTERN=NONE

CREATED=20080917181926

MODIFIED=20080917181926

This last Medium was created only to apply (yust to try!!) the NOTE 864650 - Homogeneous system copy with DBMGUI 7.5.

But do not work !!

[former_member229109]

Hello Pierfrancesco,

-> Is the G: Network drive?

-> Please copy the databackup file to the local device & create the new medium pointed to this databackup file.

After that repeat the Recovery with initialization using DBMGUI & select the new medium.

Let me know the results after that.

Thank you & best regards, Natalia Khlopina

[Former Member]

Hi,

the disk G:\ is a local disk, but I have user the command "subst" to reproduce the PRD disk layout.

G:\ is not a network drive (is local) but is the result of:

subst G:\ D:\Appoggio

where D:\appoggio is local drive

[Former Member]

I have also created a new medium with a real path and repeat the RECOVERY with initialization, but no way.

Still no work!!

[Former Member]

Hi last message was wrong.

RECOVERY start as you suggested.

After the recovery the DB start, but now SAP won't to start anymore.

In the dev_w0 I found:

C Thu Sep 18 10:39:37 2008

C *** ERROR => Connect to database failed : sqlcode=-4008 (Unknown user name/password combination)

[dbadautl.c 173]

B ***LOG BY2=> sql error -4008 performing CON [dbsh#3 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> Unknown user name/password combination [dbsh#3 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error -4008 performing CON [dblink#2 @ 419] [dblink 0419 ]

B ***LOG BY0=> Unknown user name/password combination [dblink#2 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1284]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9598]

I have also run the command (as per note 457425):

dbmcli -d <LC_name> -u <dbm_userid>,<password> load_systab -u <dba_userid>,<password> -ud <domain_user_password>

But still have error connecting to DB.

Any idea ?

[Former Member]

The problem is that the sapSID user do not connect to DB (wrong pswd, because I do not know the sapprd pswd!!!)

Is where a way to discover the sapSID pswd on the source system, or

can I reset the sapSID pswd on target system so that SAP can connect to DB with this user ??