Fw: Question about database recovery

["Vasyl Shulzhenko" <vasilis@softline.kiev.ua>]

----- Original Message -----
From: ALKIN_TEZUYSAL <is@snswwide.com>
Newsgroups: comp.databases.informix
Sent: 8 ???? 2000 ?. 16:09
Subject: Re: Question about database recovery


> Answer to your question is yes you can do it.
> I've done that before with ontape utility. But also there are some
> restrictions.First and biggest problem (don't know it's a problem for you
> or not ) is you'll have to keep your backup (secondary database/system) in
> fast recovery mode.
> This means you can not bring the instance up and roll forward logical logs
> whenever you want and should stay in accessible.
> Easy task is as you said.Backup up the primary database.Also start logical
> log backup.Then restore it to secondary server at the end of restore when
> informix asks you for logical log restore/recovery say yes and use the
> correct logical log backup(keep numbers labeled properly) for recovery.The
> idea is if the primary fails, you can bring up secondary in very short
> time.I'd also recommend you to make extreme testing for your case.
>
> P.S:The platform for informix  was :
> IDS 7.X on UNIX
>
>
> Alkin TEZUYSAL
> INFORMIX DBA
>
>
>
> robertwane@hotmail.com wrote:
>
> >    When recoverying an Informix database, I need level 0 archive tape
> > and logical backup tape . I have two  informix databases with same
> > configuration(one is working database ,one is backup database) and I
> > want them to keep same , If in an time point , I have recovered two
> > databases to a same stage, then, one database(working database)
> > continues to change , in this process, the working database will record
> > the changes in it's logical log  one after another and stores the log
> > in it's logical dbspace, my purpose is : when the working database
> > completes a logical log , can I get(retrive) the logical log from the
> > working database in some way and transfer it to the backup database to
> > recorver the data?
> >   You may ask me why not I use Informix database replication. my
> > problem is the communication condition. without good communication
> > condition , database replication may influence the working efficiency.
> > Can you help me?
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>