Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


Share this Page URL
Help

Recovering a dropped database > Recovering a database using DB2 Recovery Expert - Pg. 209

You can rollforward database with the following command: db2 rollfoward database <database name> to end of logs Note: Logs in the active log path are also dropped when a database is dropped. Therefore, you must have logs archived in an archive location if you wish to do a rollforward. You need to copy the logs to active log path of the restored database to be able to do a rollforward. If you do not wish to copy the logs into database log path, you can place them anywhere on the system and use overflow logpath clause in the rollforward command to point to them. After you perform the rollforward, you can bring the database out of rollforward pending state by issuing the following command: db2 rollfoward database <database name> stop At this point, the database should be in a normal and connectable state. 7.4.3 Recovering a database using DB2 Recovery Expert DB2 RE can work with both DB2 backups and backups taken with Fast Backup. For information about restoring a database using Fast Backup, see 9.5, "Scenario B: Recovering a database on the multiple network storage volumes" on page 286.