January 2005
Beginner to intermediate
928 pages
22h 14m
English
If you have to restore your database or a table space in one of your databases, you will lose any changes made since the backup was taken unless you have log retain enabled and use the ROLLFORWARD command to replay the logs for your database.
If a backup operation is performed online, then there are still users connecting to the database and they may be in the middle of a transaction. Therefore, an online backup contains the backup image of a database that is in an inconsistent state. After restoring the backup image into a database, the database is immediately placed in a roll forward pending state. You must run the ROLLFORWARD DATABASE command to bring the database back ...
Read now
Unlock full access