Hi !
I've been having problems getting DB restoration working correctly.
After much trial and error, I got as far as getting all data in with the
following:
dbmcli -s db_create $DBNAME $DBMUSER,$DBMPWD
dbmcli -d $DBNAME -u $DBMUSER,$DBMPWD <<EOF
param_rmfile
param_startsession
param_init OLTP
param_put CAT_CACHE_SUPPLY $CATCACHESUPPLY
param_put CACHE_SIZE $CACHESIZE
param_put MAXUSERTASKS $MAXUSERTASKS
param_checkall
param_commitsession
param_addvolume 1 DATA $DATA_DIR/DISKD0001 F $DATAPAGES
param_addvolume 2 DATA $DATA_DIR/DISKD0002 F $DATAPAGES
param_addvolume 1 LOG $DATA_DIR/DISKL001 F $LOGPAGES
medium_put import-data $RESTORE_SRC FILE DATA 0 0 YES
db_cold
util_connect
recover_start import-data DATA
db_activate recover import-data
util_release
db_start
medium_put data $BACKUP_DIR/datasave FILE DATA 0 8 YES
medium_put auto $BACKUP_DIR/autosave FILE AUTO
util_connect $DBMUSER,$DBMPWD
backup_save data
db_warm
autosave_on
util_connect $DBMUSER,$DBMPWD
autolog_off
backup_start data MIGRATION DATA
util_release
autolog_on
quit
EOF
After restoring, I have problems with the sysdba account. I can login
using the original (from backup source) sysdba username and password via
a JDBC app but not via dbmcli:
dbmcli -d $DBNAME -u $DBAUSER,$DBAPWD
Error! Connection failed to node (local) for database DEV_01:
ERR_USRFAIL: user authorization failed
I've tried adding a
user_put $DBAUSER PASSWORD=$DBAPWD
at various points in the above script bit this always results in:
-24951,ERR_USRREAD: could not read user data
Where am I going wrong ?
How can I force a sysdba password change during the restoration
procedure ?
Any help would be much appreciated.
Andy
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
