Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
SOLVED - Restore + init using DBMCLI...
From: Martin Cordova (martin.cordovagmail.com)
Date: Thu Dec 22 2005 - 16:04:51 CST
I just found the problem:
After copying the "datasave" backup file from SAPDB 7.4 server, the
owner was root, and that caused a problem to the restore process. I
did chown to this file:
chown sdb:sdba datasave
And then used this script:
_o=`cat <<EOF | dbmcli -d $SID -u dbm,dbm
db_activate RECOVER data DATA
load_systab -u dba, dba
_test=`echo $_o | grep ERR`
After that, execute an online backup and then autolog_on - that's all.
This script does the work and leaves the database instance in operational state.
Thanks a lot, sorry if I wasted somebody's time.
> > _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
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb