on 10-24-2011 9:12 AM
Hi,
on MAXDB 7.6 on Win 2008 server , how to Create a new DB from the backup of another DB ?
Thank you.
thank.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
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
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,
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.
> 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
Check
Note 1480765 - MaxDB: system copy of SAP systems to Windows 2008 (R2)
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.