Ingres Database 9.2 – Incremental Rollforwarddb

ingres_logo.jpg   The incremental rollforwarddb feature allows the journals from a database to be incrementally applied, as they are generated, to a backup copy of the database. This feature can be used to minimize downtime in the event that the backup database is needed for disaster recovery

Start the incremental rollforwarddb by issuing the following command
# rollforwarddb dbname +c -j -incremental

Issue one or more of the following commands to cause rollforwarddb to discover new journals and apply them
# rollforwarddb dbname -c +j -norollback

The database remains inconsistent and readonly

Discover and apply new journals by issuing the following command
# rollforwarddb dbname -c +j -rollback 

The incremental rollforwarddb ends, and the database is marked consistent and updateable

Leave a Reply

You must be logged in to post a comment.