From Newsgroup: comp.databases.ingres
Hi Rich,
At my large sites, I use "log shipping" to replicate production
databases to a DR standby machine then use copydb/unloaddb-a from that location when I need.-a One of the benefits of this arrangement is to be
able to rollforward the DR database to a point in time for analysis and
to assist reproducing transient problems.
clonedb and relocatedb cannot be used when users are connected. clonedb/relocatedb can be used on a replicated database after the final incremental journal is applied with:
rollforwarddb -c +j -incremental -rollback dbname
or
rollforwarddb -c +j -incremental_finish -rollback dbname
For more info see:
https://communities.actian.com/s/article/Incremental-Rollforwarddb
I can confirm log shipping replication works very well for non x100
databases on both Windows and Unix/Linux.-a Sorry I don't have any
experience replicating x100.
Paul White
&
On 19/01/2022 2:46 am, Rich Ford wrote:
I've been looking at using clonedb to do a refresh of some dev databases from production. I've only used unloaddb before but checking out clonedb.
One issue that concerns me is the fact that users can't be online which is a major drawback.
Has anyone had success using clonedb?
Rich
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
--- Synchronet 3.21b-Linux NewsLink 1.2