Hi, I am trying to do a backup and restore on one of my database instances. What I am essentially trying to do is move the database from one server to another by doing backup/restore. But first, I am just testing all this stuff on one server to see if/how it works. I am trying to do a complete data backup using the media type file. Here are the commands I am executing and the resulting message: ./dbmcli -d TST74 -u dbm,dbm medium_put newbackup /home/sapdb/backup082903 FILE DATA 0 8 YES
./dbmcli -d TST74 -u dbm,dbm -uUTL -c backup_start newbackup Returncode 0 Date 20030829 Time 00115941 Server sapdb.abt.net Database TST74 Kernel Version Kernel 7.4.3 Build 027-121-048-452 Pages Transferred 248 Pages Left 0 Volumes 1 Medianame newbackup Location /home/sapdb/backup082903 Errortext Label DAT_00019 Is Consistent true First LOG Page 1077 Last LOG Page DB Stamp 1 Date 20030829 DB Stamp 1 Time 00115941 DB Stamp 2 Date DB Stamp 2 Time Page Count 225 Devices Used 1 Database ID sapdb.abt.net:TST74_20030820_134838 Max Used Data Page 0 By the way, I AM doing all this with a utility connection. I believe that the backup is successful. However, I am having problems with the restore. What exact command has to be executed in order to restore this database instance and how can one check if the restore was done successfully? I tried the following command, however as you will afterward, the "Location" points to the datasave file which is not the file I wanted to restore: ./dbmcli on TST74>recover_start DATA OK Returncode 0 Date 20030829 Time 00134152 Server sapdb.abt.net Database TST74 Kernel Version Kernel 7.4.3 Build 027-121-048-452 Pages Transferred 248 Pages Left 0 Volumes 1 Medianame data Location /home/sapdb/TST74/datasave Errortext Label DAT_00009 Is Consistent true First LOG Page 1057 Last LOG Page DB Stamp 1 Date 20030825 DB Stamp 1 Time 00173710 DB Stamp 2 Date DB Stamp 2 Time Page Count 225 Devices Used 1 Database ID sapdb.abt.net:TST74_20030820_134838 Max Used Data Page 0 Sorry for the long email but I am fairly new to both sap and linux and would appreciate any help/suggestions concerning this matter. Thank you in advance. Regards, J. Simoni _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
