| Mailing List | | Home | | MySQL General - General MySQL discussion | | MaxDB - Everything about MaxDB, formerly known as SAP DB | | MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP | | MySQL++ - Programming with the C++ API to MySQL | | ODBC - ODBC with the MySQL Connector/ODBC driver | | Java Help - Mostly related to the MySQL Connector/J driver | | Perl - Perl support for MySQL with DBI and DBD::mysql | | GUI - MySQL GUI Tools | | Announcement |
|
|
 | | | param_rmfile ERROR | param_rmfile ERROR 2004-04-01 - By Gerd König
Back
--Boundary-00=_M5/aAPC0W6hwHvB
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hi,
while restoring a 7.5.05 backup on a different machine (both SuSE9.0) we're
running in troubles at the command "param_rmfile".
The error message is (from dbmsrv.prt):
=================================================
ERR -24997 DBM ERR_FILE: file handling error
0x00003001 ERR -24997 DBM 1,File not found
=================================================
which file was not found ??
Restoring the backup should work like:
=================================================
see attached file
=================================================
Background: we migrated a 7.3 instance to MaxDB and then made a
backup there via:
=================================================
_o=`cat <<EOF | dbmcli -d $SID -u dbm,dbmpass 2>&1
backup_media_put mybackup $BACKUPFILE FILE DATA 0 8 YES
util_connect dbm,dbmpass
backup_start mybackup MIGRATION DATA
quit
EOF`
=================================================
--Boundary-00=_M5/aAPC0W6hwHvB
Content-Type: application/x-shellscript;
name="recover_tisys_full_maxdb.sh"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="recover_tisys_full_maxdb.sh"
#!/bin/sh
set +x
if [ "$1" = "" ]; then
echo
echo "Usage: ./recover_DBNAME_full.sh <BACKUP_DIR>"
echo
exit 1
fi
# -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
# -- variables -- ---- ---- ---- ---- ---- ---- ---- ---- -----
BACKUP_DIR=$1
SID=DBNAME
INSTROOT=/opt/sdb/7500
PATH=/opt/sapdb/indep_prog/bin:$PATH
export PATH
DATE=`date +%Y-%m-%d`
DEVSPACEHOME=/opt/sapdb
if [ "$HOME" = "" ]; then
USER=`id | sed s/^.*\(// | sed s/\).*//`;export USER
HOME=`echo ~$USER`;export HOME
if [ "$HOME" = "" ]; then
echo "cannot find ${USER}s home directory - set HOME in environment and
retry" 1>&2
exit 1
fi
fi
# -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
# -- local function(s) -- ---- ---- ---- ---- ---- ---- ------
dropDB() {
echo "stop probably existing demo database $SID"
dbmcli -d $SID -u dbm,dbmpass db_offline > /dev/null 2>&1
echo "now dropping db $SID"
dbmcli -d $SID -u dbm,dbmpass db_drop > /dev/null 2>&1
}
createDB() {
echo "create database $SID..."
_o=`dbmcli -s -R $INSTROOT db_create $SID dbm,dbmpass 2>&1`
_test=`echo $_o | grep OK`
if [ "$_test" = "" ]; then
echo "create $SID failed: $_o" 1>&2
exit 1
fi
return 0
}
setParams() {
echo "set parameters for $SID..."
_o=`cat <<EOF | dbmcli -d $SID -u dbm,dbmpass 2>&1
param_rmfile
param_startsession
param_init OLTP
param_put CAT_CACHE_SUPPLY 1300
param_put CACHE_SIZE 30000
param_put SEQUENCE_CACHE 6
param_put MAXCPU 2
param_put MAXUSERTASKS 120
param_put SESSION_TIMEOUT 60
param_put REQUEST_TIMEOUT 30
param_checkall
param_commitsession
param_addvolume 1 DATA $DEVSPACEHOME/$SID/DISKD0001 F 100000
param_addvolume 2 DATA $DEVSPACEHOME/$SID/DISKD0002 F 100000
param_addvolume 3 DATA $DEVSPACEHOME/$SID/DISKD0003 F 100000
param_addvolume 4 DATA $DEVSPACEHOME/$SID/DISKD0004 F 100000
param_addvolume 5 DATA $DEVSPACEHOME/$SID/DISKD0005 F 100000
param_addvolume 6 DATA $DEVSPACEHOME/$SID/DISKD0006 F 100000
param_addvolume 7 DATA $DEVSPACEHOME/$SID/DISKD0007 F 100000
param_addvolume 8 DATA $DEVSPACEHOME/$SID/DISKD0008 F 100000
param_addvolume 1 LOG $DEVSPACEHOME/$SID/DISKL001 F 12800
db_admin
util_connect
db_activate DBA,dbmpass
util_release
quit
EOF`
_test=`echo $_o | grep ERR`
if [ "$_test" != "" ]; then
echo "set parameters failed: $_o" 1>&2
exit 1
fi
}
startDB() {
echo "start $SID..."
_o=`dbmcli -d $SID -u dbm,dbmpass db_start 2>&1`
_test=`echo $_o | grep OK`
if [ "$_test" = "" ]; then
echo "start $SID failed: $_o" 1>&2
exit 1
fi
}
# util_execute init config, currently NOT NEEDED !!!!!
initDB() {
echo "initialize $SID..."
_o=`cat <<EOF | dbmcli -d $SID -u dbm,dbmpass 2>&1
util_connect dbm,dbmpass
db_activate DBA,dbmpass
util_release
quit
EOF`
_test=`echo $_o | grep ERR`
if [ "$_test" != "" ]; then
echo "initializing $SID failed: $_o" 1>&2
exit 1
fi
}
dbWarm() {
echo "warm up db $SID"
_o=`cat <<EOF | dbmcli -d $SID -u dbm,dbmpass 2>&1
db_online
quit
EOF`
_test=`echo $_o | grep ERR`
if [ "$_test" != "" ]; then
echo "starting $SID failed: $_o" 1>&2
exit 1
fi
}
..........
<schnipp>
--Boundary-00=_M5/aAPC0W6hwHvB
Content-Type: text/plain; charset=us-ascii
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
--Boundary-00=_M5/aAPC0W6hwHvB--
|
|
|