Hello: I am not quite sure, but, when I have done restores operations between databases by using DBMCLI, I have done in this sequence: .- put the database in admin mode, .- make the "util connection", .- do the restore things, .- release the util connection, .- re-activate the database.
As I said, I am not pretty sure it is the solution, however, you could test it :-) Best regards. -- Jonathan On 12/22/05, Martin Cordova <[EMAIL PROTECTED]> wrote: > Hello, I am trying to restore a healthy backup from a SAPDB 7.4.3.30 > instance into a MAXDB 7.6.0.16 instance. I created my MaxDB instance, it > does not contain any users, it's a fresh instance. > > First attempt: used this script: > > dbmcli -d PROD -uUTL -u dbm,dbm -c db_activate RECOVER data DATA > > output: ERR > -24988,ERR_SQL: Sql error > -101,SQL statement not available in this DB mode > > Second attempt: > > _o=`cat <<EOF | dbmcli -d $SID -u dbm,dbm > util_connect > db_admin > db_activate RECOVER data DATA > util_release > EOF` > _test=`echo $_o | grep ERR` > > output: -24988,ERR_SQL: Sql error > -903,Host file I/O error,Could not open volume > 17,Servertask Info: because Error in backup task occured > 10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT334 Result=3700 > 6,Error in backup task occured, Errorcode 3700 "hostfile_error" > > I created my 7.6 instance with backup devices: > > echo "set backup parameters..." > _o=`cat <<EOF | dbmcli -d $SID -u dbm,dbm 2>&1 > medium_put data $DIR_BACKUP/datasave FILE DATA 0 8 YES > medium_put auto $DIR_BACKUP/autosave FILE AUTO > util_connect dbm,dbm > backup_save data > autosave_on > quit > EOF` > > I replaced datasave with the backup created in 7.4, just as I do when > passing 7.6 backups between instances, which works very well, but I always > use DBMGUI in those cases. > > In this particular instalation, I don't have a Windows machine, so I need > to use DBMCLI. Any help will be very appreciated. > > Best regards, > Martin > > > > -- > Dinamica - RADical J2EE framework > open source, easy and powerful > http://www.martincordova.com > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
