From: Martin Cordova (martin.cordovagmail.com)
Date: Thu Dec 22 2005 - 16:04:51 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
util_connect
db_admin
db_activate RECOVER data DATA
util_release
db_online
load_systab -u dba, dba
EOF`
_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.
Martin

> >
> > _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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]