Hi gurus,

On a Linux host running MaxDB 7.5.0 same machine, I've attempted to test out a typical 
backup & recovery scenario.

Master instance (sdb1)
Standby instance (sdb2) - to be built from the backup of sdb1

The following steps are executed:

dbmcli -d sdb1 -u dbm,dbm 
> medium_put fullbackup /home/sdb/sdb_backup/sdb1_copy FILE DATA 0 0 NO
> medium_put archivelog /home/sdb/archive/log.ARC FILE LOG
> util_connect
> backup_start fullbackup recovery
> backup_start archivelog RECOVERY LOG

... then I bump in more data and create more logs... all looks ok so far

Creating the standby instance:
dbmcli -s -R /opt/sdb/7500 -c db_create sdb2 dbm,dbm
dbmcli -d sdb2 -u dbm,dbm
> param_startsession
> param_init
> param_put rundirectory /home/sdb/sdb2    (while master's is /home/sdb/sdb1)
> param_checkall
> param_commitsession
> param_addvolume 1 LOG LOG_001 F 2000
> param_addvolume 1 DATA DAT_001 F 10000

Defining the backup medium in standby instance
dbmcli -d sdb2 -u dbm,dbm
medium_put fullbackup /home/sdb/sdb_backup/sdb1_copy FILE DATA 0 0 NO
medium_put archivelog /home/sdb/archive/log.ARC FILE LOG

Recovering Data:
dbmcli -d sdb2 -u dbm,dbm db_cold
dbmcli -d sdb2 -u dbm,dbm -uUTL -c recover_start fullbackup

... so far so good, /home/sdb/sdb2/DAT_001 successfully create as expected; DB keeps 
at ADMIN state

Recovering Logs:
dbmcli -d sdb2 -u dbm,dbm -uUTL -c recover_start archivelog 001
ERR
-24988,ERR_SQL: sql error
-71,connection broken server state 6

Oops, stuck!  Expect to proceed recover_replace with other logs but can't proceed 
further.  What did I do wrong?  Any pointer is highly appreciated.

Thanks in advance,
Andy


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to