Restoring database from a Database Storage Checkpoint


Restoring database from a Database Storage Checkpoint
Prev	Administering Storage Checkpoints	Next

You can restore your database from a Database Storage Checkpoint as follows.

Note:

The following operation requires your primary database to be deactivated. The database needs to have a logarchmeth setup, because after recovery the database needs to be rollforwarded.

To restore the database from a Database Storage Checkpoint

Use the following command.
```
$ /opt/VRTSdbed/bin/vxsfadm -s checkpoint -o restore -a db2 \
--db2instance db2inst1 --db2database proddb \
--checkpoint_name=XYZ
Rolling back the application files... Done
```
This command restores all the database to the point-in-time when the Checkpoint was created.

Note:

Rollback of Database Storage Checkpoints that are mounted in the read-write mode is not supported.

After the restore operation, you can bring up the database by using standard recovery techniques.

For example:
```
$ db2initdb proddb as mirror
$ db2 rollforward db proddb to end of logs and stop
	
```

Note:

The TEMP tablespaces cannot be rolled back.

Prev	Up	Next
Creating a database clone using a Database Storage Checkpoint	Home	Gathering data for offline-mode Database Storage Checkpoints