Re: onbar without locical logs

Gernot Weiner (gernot.weiner@siemens.at) wrote: : I have set LTAPEDEV to /dev/null because I don't want to use the locical : logs for a restore. : But everytime I want to restore the database from a whole physical system : backup with the command onbar -r -w, the locical logs which are not set to : F(ree) will be backed-up before the restore begins. : Since INFORMIX does not really free logical logs if LTAPEDEV=/dev/null, : after an appropriate online time of INFORMIX all logical logs are set to : U---B (used and backed-up). : The result is, that after the physical restore a logical restore will be : done. : My question is. : How can I restore a physical system backup with onbar without saving the : logical logs ? Same scenario here. We have no problem in using restore (-r -w) here. Btw, we perform (-b -w) when there's little updating. In theory, the only logs needed are those salvaged *just* before the restore starts. But when restoring to point-in-time, we hit one of the 'feature' that the salvaged log not always able to apply back to the image. In fact, onbar can somtimes just need phyiscal restore, then exit with an error (because there is no logical log back up in the first place) and continues to go to quiescent mode. (well, Informix Support decline to say 'bug', and in newer 7.3 manuals they even stipulate that logical log *MUST* be backedup for p-i-t restore). One workaround is to also restore ixbar.SERVERNUM first (that's p-i-t) and then use -r -w (without -t). -- Chris Lo mailto: chris.lo@prudential.com.hk System Administrator/Informix DBA mailto: cklo@cklo.hk.super.net The Prudential Assurance (HK) Co. Ltd mailto: cklo@hk.super.net ============================================================================== -- Linux + FreeBSD + HPUX + Solaris + AIX ============================================================================== #include <std/disclaimer.h>