Hi all,
I need some advice for setting up SAPDB standby
database. I am running SAPDB 7.4.3 on SuSE 8.2 Linux.I
saw example of standby setup in SAPDB documentation
and trying to do it without big success so far.
The idea is to have a cronjob which would do regular
log backups (backup_start log_bak) on active instance,
FTP it to other Linux box and feed with them standby
instance (recover_start log_bak <nnn>). There is no
problem to backup logs, but when recovering first log
backup on standby instance it returns -8020, which
means it expects next log backup (recover_replace
...). If I release utility session now the instance
will go down. But cronjob solution assumes that
multiple calls to dbmcli will be made. And what are we
supposed to do if the box needs to be rebooted? So
here are the questions:
1) Are there alternatives to load log backups on
standby instance other then do
recover_start-recover_replace in one utility session?
2) Can I extend one utility-backup-recover session
over multiple dbmcli calls?
3) Are there any other common solutions to setup
standby instance? I read article of Dr. Yves Trudeau
on the topic, but that solution is not possible in our
environment and since this article was written 3 years
passed, so I would expect that some developments has
been done in this field.
Thank you in advance.
Alexei.
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
