How to do restore from complete online backup

[Former Member]

Helllo,

I have a onlinecomplete backup of SAPDB on one server and wanted to restore this backup to my newly installed DB on other server.

1) hoe can i do that ,? is it possible by using DBMGUI?

2) how to select the backup file to restore in DBM GUI , I tried but the it was not taking the proper DAT_ ? file for the recovery.

Regards,

Bhavesh

[Former Member]

Hello I fix this issue my self,

Solution: i have restarted the server and that solved the issue.

Regards,

Bhavesh

[Former Member]

one more thing, when u define the backup template, make sure u specify to the backup file name, not just to the directory where the backup file resides.

for example -

Directory of C:\sapdb\data\TEST77\backup

08/24/2010 01:47 PM <DIR> .

08/24/2010 01:47 PM <DIR> ..

08/24/2010 01:47 PM 4,587,520 firstBack.bak

template definition should be looking like below

[D1]

LOCATION=C:\sapdb\data\TEST77\backup\firstBack.bak <===

TYPE=FILE

SAVETYPE=DATA

SIZE=0

BLOCKSIZE=8

OVERWRITE=NO

AUTOLOADER=NO

OSCOMMAND=

BACKUPTOOL=NONE

[Former Member]

Hi,

I didt the same steps as you have mentioned but i am getting this error:

-903 file is already used by some other pro 32

I dont know but I have copied the complete backup file to a share flder. when i defined the template ( backup medium) and try to see the lebel of bakupp file it show this error.

Can you guide me on this

Regards,

Bhavesh

[Former Member]

hi,

Sounds like ur trying to do a homogeneous system copy. Is it for MaxDB and not for liveCache?

Here are some useful SAP notes:

I. 1014782: FAQ: MaxDB system copy ... general

II. 129352: Homogeneous system copy with MaxDB (SAP DB)

=> step by step, using DBMGUI .. this is the holy SAP note for MaxDB system copy.

III. Tutorial from 7.7 online doc.. uses dbmcli (old school commandline uses demo DB).

"Creating a Database Copy (Importing a Data Backup into Another Database Instance"

(http://maxdb.sap.com/doc/7_7/44/eb166ab6f0108ee10000000a11466f/content.htm)

Did u define a correct backup template in the target DB??? When u restore in the target system, u should restore from template that is pointing to the backup from your source. Pls check the docs/notes mentioned above. They will tell u how to do it, step-by-step.