The wiki referred to covers only the topic of backing up using dbloader, not creating new databases from dbmcli.
If you want to do that then you will have to provide a new (bash or bat) script for doing so to dbmcli. .
Andreas Grund wrote:
Hi Kwok Peng Tuck,
as far as i understood the homepage, my script must contain the following statements:
SET MAXERRORCOUNT 1
// USE USER <src sysdba> <password> SERVERDB <src db name> ON <src host> // DBEXTRACT OUTFILE 'C:/Datenbank/Datenbank.ddl' OUTFILE 'C:/Datenbank/Datenbank' // USE USER <trg sysdba> <password> SERVERDB <trg db name> ON <trg host> // DBLOAD ALL INFILE 'C:/Datenbank/Datenbank.ddl' INFILE 'C:/Datenbank/Datenbank' OUTFILE 'C:/Datenbank/neu'
But this script can only work, if the soucrehost and the targethost are connect to each other. But i need a script or a batchfile, which i can burn on a cd with the backup of my original db and someone else copys the backupfile and the batchfile on his pc, startet the batch-file and after the execution of the batch-file sapdb has created a new database with the same content and the same tablenames and the same foreignkey... as my original db has. So, do i understand the loader wrong, or has the database to be create before this script runs?
By the way: SAP DB 7.4.3.25 complains about the OUTFILE in the second command.
Greeting and thanks for your reply, Andreas
Kwok Peng Tuck <[EMAIL PROTECTED]> schrieb am 06.08.03 08:34:27:
Hello Andreas,
Have a look at this wiki over here : http://sapdb.2scale.net/moin.cgi/MigrateDbUsingLoader73
It should still apply to version 7.4. I've used it to migrate between linux and win2k, so it should
work ok for you. Good luck.
Andreas Grund wrote:
Hi Mailinglist,_______________________________________________
I send the Mail again, because noone react on my first mail and I have to solve the problem. Maybe someone can help me now:
I tried since last Friday to migrate a database from Win NT to Win 2K. I work with SAP DB 7.4.3.25. First i make a complete databackup. I copied this file to the new machine and there i want to recover the database with dbmcli. But i fail every time, because on the new machine is no backuphistory. With the dbmgui, it no problem, but i wanted to write a batchfile, which does this job. Someone out of the mailinglist sends me an batchfile, but it does not work either. the *.knl file says everytime:
3F2E48B70002| |HISTLOST | | |2003-08-04 13:51:19| | | | | | | | 0| | 3F2E48B70003|DAT_00012|RESTORE |2003-08-04 12:48:34|2003-08-04 12:48:34|2003-08-04 13:51:19|2003-08-04 13:51:25| 2928| |NO |Datensicherung | 1072| 1| 0| |
My batchfile contains: dbmcli -d KNL_SAMM -u ROOT,TELEKOM db_drop dbmcli db_create KNL_SAMM ROOT,TELEKOM dbmcli -d KNL_SAMM -u ROOT,TELEKOM -i D:\Datenbankrecovery\command.dat
And in the command.dat stands: medium_put Datensicherung D:\Datenbankrecovery\KNL_SAMM.backup FILE DATA 1300 8 YES NO medium_getall service_connect recover_config Datensicherung service_release param_startsession param_put RUNDIRECTORY D:\programme\sapdb\indep_data\wrk\KNL_SAMM param_put DIAG_HISTORY_PATH D:\programme\sapdb\indep_data\wrk\KNL_SAMM\DIAGHISTORY param_checkall param_commitsession db_admin util_connect util_execute init config util_release util_connect recover_start Datensicherung DATA util_release db_online
And the last command is the problem, it is not possible to set the new database online. Why?? Where is the failure?
Greeting and thanks,
Andreas
______________________________________________________________________________
ComputerBild (15-03) empfiehlt: Der beste Spam-Schutz ist bei WEB.DE FreeMail Deutschlands beste E-Mail - http://s.web.de/?mc=021141
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
______________________________________________________________________________ Wo gibt es den besten Spam-Schutz? Laut ComputerBild 15-03 bei WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021122
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
