Gareth

a couple of years ago I did exactly this with input from Martin, Karl
and Roy.
What I did was:

1) checkpoint of production machine to disk

2) copy across ckp, dmp, jnl file to hot standby machine

3) rollforward on standby machine

4) to the above with iidbdb but copy to an archive directory.

5) during the day on the production machine I do an alterdb -osmething
- forgot what thi sis to force a new journal file

6) copy across the journal file just closed to a staging area on the
hotstandby machine

Here I gave the client two options:

1) to immediately apply the journal on the hot standby machine
2) not to apply the journal unless it was an emergency or the
production machine died

They opted to go for option one as they were going to use the HSM as a
report server and could not have the system down every hour to apply
the journals. I did get this working without having the db go
inconnsistent.

The scripts are avalible if I can lay my hands on them if you want but
they are for a tru64 environment.

It canbe done but there is some trickery with the files. I did not
have to edit the cnf file to get this going.

It has now been running since 2002 without major problems. The only
problems we have had was running out of space on the checkpoint
directory.

Give me a yell if you want the scripts - I will try and get them

regards

If possible I wouldn't mind having a look at your scripts just to give me
some pointers. As I mentioned I've managed to create a script that'll get
the appropriate files from production, shutdown ingres, copy the files to
the ckp/dmp/jnl and copy aaaaaaaa.cnf, start ingres and rollforward
successfully.

I'm using rsync to get the files from production at a set interval, what I'm
trying to avoid is having to use the ckp files in the rollforward.

Many Thanks

Gareth

-----Original Message-----
From: panjo03@hotmail.com [mailto:panjo03@hotmail.com]
Sent: 21 October 2004 20:13
To: info-ingres@ams.org
Subject: Re: [Info-Ingres] DR type stuff...

Gareth

a couple of years ago I did exactly this with input from Martin, Karl
and Roy.
What I did was:

1) checkpoint of production machine to disk

2) copy across ckp, dmp, jnl file to hot standby machine

3) rollforward on standby machine

4) to the above with iidbdb but copy to an archive directory.

5) during the day on the production machine I do an alterdb -osmething
- forgot what thi sis to force a new journal file

6) copy across the journal file just closed to a staging area on the
hotstandby machine

Here I gave the client two options:

1) to immediately apply the journal on the hot standby machine
2) not to apply the journal unless it was an emergency or the
production machine died

They opted to go for option one as they were going to use the HSM as a
report server and could not have the system down every hour to apply
the journals. I did get this working without having the db go
inconnsistent.

The scripts are avalible if I can lay my hands on them if you want but
they are for a tru64 environment.

It canbe done but there is some trickery with the files. I did not
have to edit the cnf file to get this going.

It has now been running since 2002 without major problems. The only
problems we have had was running out of space on the checkpoint
directory.

Give me a yell if you want the scripts - I will try and get them

regards
_______________________________________________
Info-ingres mailing list

English:- This message is confidential. If you are not the intended
recipient of the message then please notify the sender immediately. Any of
the statements or comments made above should be regarded as personal and not
necessarily those of Bro Morgannwg NHS Trust, any constituent part or
connected body. Cymraeg:- Mae'r neges hon yn gyfrinachol. Os nad chi yw'r
derbynnydd y bwriedid y neges ar ei gyfer, byddwch mor garedig â rhoi gwybod
i'r anfonydd yn ddi-oed. Dylid ystyried unrhyw ddatganiadau neu sylwadau a
wneir uchod yn rhai personol, ac nid o angenrhaid yn rhai o eiddo
Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohoni na
chorff cysylltiedig.