Learning Visually with Examples [Electronic resources] نسخه متنی

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/old1999/image/library/english/13748_db2rhist.asc)