E. Features Introduced in Ingres 9.2 : DBMS Server Enhancements : Incremental Rollforwarddb
 
Share this page                  
Incremental Rollforwarddb
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.
For this feature, two new options are added to the rollforwarddb command:
-incremental
-norollback
To apply journals incrementally
1. Start the incremental rollforwarddb by issuing the following command:
rollforwarddb dbname +c -j -incremental
2. Discover and apply new journals by issuing the following command:
rollforwarddb dbname -c +j -norollback -incremental
The database remains inconsistent and readonly. There may be open transactions.
3. Discover and apply new journals and roll back open transactions by issuing the following command:
rollforwarddb dbname -c +j -rollback -incremental
The -rollback flag ends the incremental rollforwarddb, and the database is marked consistent and updatable.
For details on the flags, see the rollforwarddb command description in the Command Reference Guide.