cancel
Showing results for 
Search instead for 
Did you mean: 

Create a new DB from the backup of another DB

Former Member
0 Kudos

Hi,

on MAXDB 7.6 on Win 2008 server , how to Create a new DB from the backup of another DB ?

Thank you.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

thank.

steffen_schildberg
Active Participant
0 Kudos

Yes,

and in case you are not a SAP customer - the docs (which are reachable again) are a quite good source of information. You might want to check:

[Creating a Database Copy (Importing a Data Backup into Another Database Instance)|http://maxdb.sap.com/doc/7_6/7e/c3fb0e72fcf84580f7ee9fcec672b7/frameset.htm].

Steffen

Former Member
0 Kudos

yes thank you. I 'm following this.

Following that Scenario

C:\Documents and Settings\Administrateur>dbmcli -u DBADMIN,pwd -d MAXDB2

ERR

-24977,ERR_COMMAND: Unknown DBM command "-u"

C:\Documents and Settings\Administrateur>dbmcli.exe -u DBADMIN,pwd -d MAXDB2

ERR

-24977,ERR_COMMAND: Unknown DBM command "-u"

What is wrong ?

steffen_schildberg
Active Participant
0 Kudos

Hi BIG36,

I know it might sound silly but I guess you have copied the dbmcli command from the docs and replaced the user name and then executed it. This does not always work because the hyphens preceding the command options seem to be a character that is misinterpreted by the MS shell. So either type the command completely or at least retype the hyphens in the command.

Regards,

Steffen

Former Member
0 Kudos

yes, thank you.

Former Member
0 Kudos

Steffen

in this scenario :

Creating a Database Copy (Importing a Data Backup into Another Database Instance).

Are the medium physical y (file on disk) the same for DemoDataCompl and DemoDataCompl_recover ??

I receive the following error :

dbmcli.exe on MAXDB3>db_activate RECOVER DemoDataCompl_recover

ERR

-24988,ERR_SQL: SQL error

-903,Host file I/O error

6,Data recovery failed

1,Backupmedium #1 (completeDataJan) invalid file or device name [2]

6,Backup error occured, Error code 3700 "hostfile_error"

17,Servertask Info: because Error in backup task occured

10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT8 Result=3700

6,Error in backup task occured, Error code 3700 "hostfile_error"

Thank you.

markus_doehr2
Active Contributor
0 Kudos

> Are the medium physical y (file on disk) the same for DemoDataCompl and DemoDataCompl_recover ??

Do not copy the files over but use a backup (a file, a tape or whatever) to restore the content of the database into a new database system.

Markus

Former Member
0 Kudos

Thank Markus,

I follow line per line the scenario in document given by Steffen . And in it it is not asked to copy then I do not do it.

markus_doehr2
Active Contributor
0 Kudos

Ok...

does the DemoDataCompl_recover point to a filename?

Markus

Former Member
0 Kudos

yes. Following scenario I gaive the same Device/file name : completeDataJan. But it is not created in E:\sdb\data\wrk\MAXDBn.

Thanks.

markus_doehr2
Active Contributor
0 Kudos

> yes. Following scenario I gaive the same Device/file name : completeDataJan. But it is not created in E:\sdb\data\wrk\MAXDBn.

So this error happens when you're doing the backup?

please post the corresponding errors of knldiag when this error occurs.

Markus

Former Member
0 Kudos

Markus,

it comes when I issue :

db_activate RECOVER DemoDataCompl_recover.

Regards.

markus_doehr2
Active Contributor
0 Kudos

I'm a bit confused.

You talk about two different mediums here, one is for backup and one (apparently) for restore. When is what error message appearing?

Markus

Former Member
0 Kudos

Markus,

please take a look here :

http://maxdb.sap.com/doc/7_6/7e/c3fb0e72fcf84580f7ee9fcec672b7/frameset.htm

There is a scenario there :

Procedure
...

       1.      Call the Database Manager CLI in session mode, log on as operator OLEG with the password MONDAY, connect to the database instance DEMODB:

>dbmcli u2013u OLEG,MONDAY u2013d DEMODB

dbmcli on DEMODB>

       2.      Define the backup template for a complete data backup to a file using the following properties:

Backup template name: DemoDataCompl
Data carrier (device/file): Backups 2005\Data\completeDataJan
Type: FILE
Backup type: complete data backup (DATA)
Size restriction: none (0)
Block size: 6
Overwrite: NO

dbmcli on DEMODB>medium_put DemoDataCompl "Backups 2005\Data\completeDataJan" FILE DATA 0 6 NO

OK

       3.      Execute a complete data backup of DEMODB using the backup template DemoDataCompl:

dbmcli on DEMODB>db_connect

OK

 

dbmcli on DEMODB>backup_start DemoDataCompl

OK

...

...

       4.      Close the Database Manager CLI:

dbmcli on DEMODB>exit

       5.      Call the Database Manager CLI, log on as operator ELENA with password SUNDAY, connect to the database instance TESTDB:

>dbmcli u2013u ELENA,SUNDAY u2013d TESTDB

dbmcli on TESTDB>

       6.      Define the backup template for a complete data backup to a file using the following properties:

Backup template name: DemoDataCompl_recover

Data carrier (device/file): \\GENUA\Documents and Settings\All Users\Application Data\sdb\data\wrk\DEMODB\Backups 2005\Data\completeDataJan

Type: File

Backup type: complete data backup (DATA)

Size (restriction): none (0)

Block size: 6

Overwrite: NO

dbmcli on TESTDB>medium_put DemoDataCompl_recover "\\GENUA\Documents and Settings\All Users\Application Data\sdb\data\wrk\DEMODB\Backups 2005\Data\completeDataJan" FILE DATA 0 6 NO

OK

       7.      Transfer the database instance to the ADMIN operational state:

dbmcli on TESTDB>db_admin

OK

       8.      Open a database session:

dbmcli on TESTDB>db_connect

OK

       9.      Import the complete data backup from DEMODB to TESTDB (initializing TESTDB using the backup template DemoDataCompl_recover created for TESTDB:

dbmcli on TESTDB>db_activate RECOVER DemoDataCompl_recover

and juste after this recovery I receive that error message. I wonder if there is an error in procedure or I do something wrong.

Thanks.

markus_doehr2
Active Contributor
0 Kudos

> dbmcli on TESTDB>db_activate RECOVER DemoDataCompl_recover

> and juste after this recovery I receive that error message. I wonder if there is an error in procedure or I do something wrong.

...and the user running the MaxDB software (which is usually not administrator) is enabled and permitted to access the share on the remote computer?

Markus

Former Member
0 Kudos

Hi Markus,

thank for reply.

Both DBs are on the same server then there is no remote server.

Then the scenario is not for me.

Can't we copy an instance to another instance , when both are on the same server ?

Regards.

markus_doehr2
Active Contributor
0 Kudos

Check

Note 1480765 - MaxDB: system copy of SAP systems to Windows 2008 (R2)

Markus