DB2恢复（ RESTORE&ROLLFORWARD）

RESTORE DATABASE source-database-alias { restore-options | CONTINUE | ABORT }

 

restore-options:

  [ USER username [USING password] ]

  [ Restore-Inventory-Clause ]

 [ INCREMENTAL [ AUTOMATIC | ABORT ] ]

 [ Media-Target-Clause ]

 [ TAKEN AT date-time ]

 [ [ TO target-directory ] | [ ON drive [ {,drive}… ] [ DBPATH ON drive ] ] ]

 [ INTO target-database-alias ]

 [ LOGTARGET {directory | { { INCLUDE | EXCLUDE } [ FORCE] }} ]

 [ NEWLOGPATH directory ]

 [ WITH num-buffer BUFFERS ] [ BUFFER buffer-size ]

 [ REPLACE HISTORY FILE ] [ REPLACE EXISTING ]

 [ REDIRECT [ GENERATE SCRIPT. file-name ] ]

 [ PARALLELISM n ]

 [ COMPRLIB lib-name ]

 [ COMPROPTS options-string ]

 [ WITHOUT ROLLING FORWARD ]

 [ WITHOUT PROMPTING ]

 

Restore-Inventory-Clause:

  rebuild-options |

TABLESPACE [ ONLINE ] |

TABLESPACE ( tablespace-name [ {,tablespace-name}… ] ) [ ONLINE ] |

HISTORY FILE [ ONLINE ] |

LOGS [ ONLINE ] |

COMPRESSIN LIBRARY [ ONLINE ]

 

Media-Target-Clause:

  USE { TSM | XBSA } [ OPEN num-sess SESSIONS ] | SNAPSHOT [ LIBRARY shared-lib ]

[ OPTIONS { options-string | options-filename } ] |

  LOAD lib-name [ OPEN num-sess SESSIONS ]

[ OPTIONS { options-string | options-filename } ] |

  FROM dir/dev [ {,dir/dev}… ]

 

rebuild-options:

  REBUILD WITH { ALL TABLESPACE IN { DATABASE | IMAGE }

[ EXCEPT TABLESPACE ( tablespace-name [ {,tablespace-name}… ] ) ] |

TABLESPACE ( tablespace-name [ {,tablespace-name}… ] ) }

 

 

 

前滚：

 

ROLLFORWARD DATABASE database-alias [ USER username [ USING password ] ]

[ TO { isotime [ ON ALL DBPARTITIONNUMS ]

[ USING LOCAL TIME | USING UTC TIME ]} |

{ END OF BACKUP [ ON ALL DBPARTITIONNUMS ] } |

{ END OF LOGS [ On-DbPartitionNum-Clause ] }

[ AND { COMPLETE | STOP } ]

] |

[ COMPLETE | STOP | CANCEL |

{ QUERY STATUS [ USING LOCAL TIME | USING UTC TIME ] }

[ On-DbPartitionNum-Clause ]

]

 

[TABLESPACE ONLINE | TABLESPACE(tablespace-name[{,tablespace-name}…])[ONLINE] ]

[ OVERFLOW LOG PATH ( log-directory

[{,log-directory ON DBPARTITIONNUM db-partition-number}…] ) ]

[ NORETRIEVE ]

[ RECOVER DROPPED TABLE dropped-table-id TO export-directory ]

 

 

On-DbPartitionNum-Clause:

  ON { { DBPARTITIONNUM | DBPARTITIONNUMS }

( db-partition-number [ TO db-partition-number ],…) |

ALL DBPARTITIONNUMS [EXCEPT{DBPARTITIONNUM |DBPARTITIONNUMS}

( db-partition-number [ TO db-partition-number ],… )]

 }