On Mon, 14 Jul 2003 19:37:25 +0200 Andre Reitz <[EMAIL PROTECTED]> wrote:
In other words: I want to make a backup for migrating from 7.3.0.29 to 7.4.3.25 (Linux). Is it correct to do the following: 1. DBMCLI on the 7.3 Server (Linux): ------------------------------------ backup_media_put fullmigrate_tmp /tmp/exp.dmp FILE DATA 0 8 YES db_offline db_cold util_execute migrate util_connect DBM,DbM backup_start fullmigrate_tmp MIGRATION DATA util_release medium_delete fullmigrate_tmp db_warm 2. Copy the file /tmp/exp.dmp to another physical 7.4 Server ( Linux): ---------------------------------------------------------------------- 3. DBMCLI on the 7.4 Server: ---------------------------- db_create XXX DBM,DBM param_rmfile param_startsession param_init OLTP param_put CAT_CACHE_SUPPLY 300 param_put CACHE_SIZE 2500 param_put MAXDATADEVSPACES 5 param_checkall param_commitsession param_addvolume 1 DATA /var/opt/sapdb/XXX/DISKD0001 F 80000 param_addvolume 1 LOG /var/opt/sapdb/XXX/DISKL001 F 20000 db_start util_connect DBM,DBM util_execute init config backup_media_put fullrestore_tmp /tmp/exp.dmp FILE DATA 0 8 YES util_connect DBM,DBM db_start recover_start fullrestore_tmp medium_delete fullrestore_tmp db_warm db_restart load_systab -u DBA,DBA -ud Dom db_warm util_connect DBM,DBM backup_media_put data /var/opt/sapdb/XXX/datasave FILE DATA 0 8 YES backup_start data util_connect DBM,DBM backup_media_put auto /var/opt/sapdb/XXX/autosave FILE AUTO autosave_on This worked in a test for me. But please tell answer me the following two simple questions: 1. Is this a correct way to migrare from 7.3 to 7.4 on a new server? 2. When doing the backup from 7.3 with "db_offline",...,"util_execute migrate" and "db_warm" at the end: Is the database in a correct state again, so that I can keep using the 7.3 instance as before I did the backup (e.g. the resore to the new 7.4 server fails...)? Greetings Andre' Best regards an thank you very much in advance -- _____________________________________________ inworks GmbH Andre Reitz H�rvelsinger Weg 39 Tel. 0731/93 80 7-21 89081 Ulm http://www.inworks.de _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
