2. Using Ingres Commands : rollforwarddb Command—Recover a Database : rollforwarddb Examples
 
Share this page                  
rollforwarddb Examples
1. The following command recovers the empdata database from the target checkpoint and journal, and provides diagnostic information about all operations executed during the recovery process.
Note:  Both the journal and the checkpoint must be online before executing the command.
rollforwarddb empdata -v
2. This command recovers tables emp and emphist from the empdata database:
rollforwarddb empdata -table=emp,emphist
3. This command recovers tables emp and emphist from the empdata database without recovering the indexes:
rollforwarddb empdata -table=emp,emphist -nosecondary_index
Note:  The indexes on tables emp and emphist will have to be rebuilt or dropped before the tables can be accessed.
4. This command recovers table emp in the empdata database and relocates it from location emploc to the new location newemploc:
rollforwarddb empdata -table=emp,emphist -relocate -location=emploc -new_location=newemploc
UNIX:
rollforwarddb empdata +c +j -m/dev/rmt0
VMS:
rollforwarddb empdata +c +j -mMTA0: