I just tried this but get the following error: >util_execute INIT CONFIG OK
--- >recover_start IVTBKP DATA ERR -24988,ERR_SQL: sql error -3014,Message not available Any idea what this is ? -----Original Message----- From: Hahn, Uwe [mailto:[EMAIL PROTECTED] Sent: Friday, 5 September 2003 4:35 PM To: Groenewald, Duncan; [EMAIL PROTECTED] Subject: RE: Migrating a 7.4.03.27 database to another server read comments within the text: > -----Original Message----- > From: Groenewald, Duncan [mailto:[EMAIL PROTECTED] > Sent: Freitag, 5. September 2003 04:53 > To: [EMAIL PROTECTED] > Subject: Migrating a 7.4.03.27 database to another server > > > I want to be able to backup a database and restore it on > another server but seem unable to get this to work. Having > browsed various mailing lists it would appear the way to do > this is by using the DBMCLI program to run the following scripts: > > # Create the database > dbmcli -n servername db_create IVT DMO,password > > # Run the script to initialise the database > dbmcli -d IVT -u DMO,password -i inst01.cli > > > # INST01.CLI Script to create a new database > # > param_startsession > param_init > param_put MAXUSERTASKS 50 > param_checkall > param_commitsession > param_addvolume 1 LOG LOG_001 F 2000 > param_addvolume 1 DATA DAT_001 F 10000 > db_admin > util_connect > util_execute INIT CONFIG > util_activate DBA,dagivs > util_release > load_systab -u DBA,dagivs -ud dagivs > # End of Script This has created a data and log area for a new db instance. > > # Run the script to load the database > dbmcli -d IVT -u DMO,password -i inst02.cli > > > # INST02.CLI Script to reload the database from a backup > db_cold > util_connect DMO,dagivs > medium_put IVTBKP 'C:\Backups\IVTBKP' FILE DATA > recover_start IVTBKP DATA > util_release > This has overwritten the data area with the image of an old db instance. > # Set the database online > dbmcli -d IVT -u DMO,password db_online > Because every restart has to check the log if there is something to be redone after the last savepoint, the log area is checked if it belongs to the data area. As you guess now the check must fail because. You tried to combine the data area from db instance A and the log area from db instance B. > > The database fails to start - apparently because the log > version is different to the database, I saw some posting > indicating it might be possible to delete the logs to fix > this problem. > > Any help would be appreciated. You should try this: # INST.CLI Script to create a new database from an old instance (a db copy) # param_startsession param_init param_put MAXUSERTASKS 50 param_checkall param_commitsession param_addvolume 1 LOG LOG_001 F 2000 param_addvolume 1 DATA DAT_001 F 10000 medium_put IVTBKP 'C:\Backups\IVTBKP' FILE DATA db_admin util_connect util_execute INIT CONFIG recover_start IVTBKP DATA db_online load_systab -u DBA,dagivs -ud dagivs # End of Script INST.CLI kind regards Uwe > > Duncan Groenewald > > > > _______________________________________________ > 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
