Section 13.9. Database Recovery Using the RECOVER DATABASE Command


13.9. Database Recovery Using the RECOVER DATABASE Command

DB2 Version 8.2 introduces a very simple new RECOVER DATABASE command that combines the RESTORE and ROLLFORWARD command operations into one step. The RECOVER DATABASE command automatically determines which backup image to use by referring to the information in the Recovery History file. For example:

  • To recover the SAMPLE database from the best available backup image and rollforward to end of logs, use:

     RECOVER DB sample 

  • To recover the SAMPLE database to the Point In Time 2004-05-21-13.50.00 (note that the PIT is specified in local time, not UTC time), issue:

     RECOVER DB sample TO 2004-05-21-13.50.00 

  • To recover the SAMPLE database to an old PIT that is no longer contained in the current history file, you need to provide a saved history file from this time period:

     RECOVER DB sample    TO 1999-12-31-04:00:00    USING HISTORY FILE (/home/user/old1999files/db2rhist.asc) 



Understanding DB2(R. Learning Visually with Examples)
Understanding DB2: Learning Visually with Examples (2nd Edition)
ISBN: 0131580183
EAN: 2147483647
Year: 2004
Pages: 313

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net