Wednesday, January 26, 2022, 2:00:06 AM, you wrote:
> This work ok for replication.
> I drop a production database, which removes ckp jnl dmp tmp data. (Non x100 db).
> Then:
> Createdb
> Ckpdb +j
> Rsync from DR server:ckp dmp jnl
> Copy aaaaaaaa.* from dmp to data
> Infodb to make sure
> Rollforwarddb to point in time
> Ckpdb +j
> No editing configs or iidbdb required.
> Am i missing something?
I would update iidatatabase.db_id in iidbdb to make it the database ID
of the old database. It's not a big deal but it means IPM will show
the correct database name.
And for DR purposes I'd make sure I was keeping all my Ingres user IDs
from iidbdb, and also my area and location definitions so they could
be recreated after the smoke clears.
Roy
> On Wed, 26 Jan 2022, 2:25 am Roy Hann,
> <spec...@processed.almost.meat> wrote: