Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: restore database

    I will be restoring a database on a new server. When I issue the restore command on the new server will I have to include the history file option in order to sync up log numbers?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What OS and DB2 version? Was it an online or offline backup?

    Andy

  3. #3
    Join Date
    Apr 2004
    Posts
    190

    db version

    OS = AIX 4.3.3
    DB = 7.1

    It is an online backup

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    The answer is No. Your restore command will look something like:

    RESTORE DB <backedup db name> from <dir where image is> taken at <timestamp of backup image (should be part of name)> into <new DB name> replace existing (if the new DB exists) redirect (if you want to change the tablespace configuration) without prompting

    Note: if you are doing a REDIRECTed restore, please read the command reference manual on how to do this.

    Then copy the logs to the log directory of the new database, then issue
    a ROLLFORWARD command.

    HTH
    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •