Page 1 of 3 123 LastLast
Results 1 to 15 of 34
  1. #1
    Join Date
    Aug 2010
    Posts
    43

    Unanswered: How to restore backup 8.2 to 9.5?

    I have a problem.
    I'm a beginner in db2 and urgently need to restore a backup made in the 8.2 version when I have the version 9.5.

    I need your help because I have little experience and not what is the proper procedure, I have thought to uninstall 9.5 to install 8.2 and then make the restoration

    Thanks for your help

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Check this article to start with:
    Performing a Database Backup, Restore, and Rollforward


    You have to use an offline database backup

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    The backup on V8.2 has to be an offline backup to be able to be restore onto V9.5. If the backup is an online backup it will not work.

    Andy

  4. #4
    Join Date
    Aug 2010
    Posts
    43
    Thanks, I have a online backup ....
    I have been advised to uninstall the version 9.5 and install version 8.2 but not exactly how to do and do not want to risk it.

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You need to ask for an offline db backup if you want to restore to v9.5.

    Or install v8.2 and restore your online image. With Unix/Linux, you can install multiple db2 versions on the same server. Not sure about Windows (I think this is possible starting with v9.1)

  6. #6
    Join Date
    Aug 2010
    Posts
    43
    I have AIX ...
    Not that such is to install two versions, as just start with db2.

    I advise installing the two versions? or uninstall 9.5 and then install 8.2?
    Could help me with the correct procedure?

    Help !!!!!!!!

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    It's easier to ask for an offline image and go directly to v9.5.

    If online is the only option, then you can install v8.2 and then restore. You don't need to uninstall v9.5

  8. #8
    Join Date
    Aug 2010
    Posts
    43
    Thank you very much for your help,
    Yes online is the only option,
    I Will Seek the installation guide.
    I have further questions, I think I have to create the database again right? the restoration is created exactly like I have in production? what happend with bufferpool?

  9. #9
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You need to install v8.2 code, create an instance (if it was not created during the installation), start the instance and then do the restore.

  10. #10
    Join Date
    Aug 2010
    Posts
    43
    Thanks!!!!!!!!!!!!!!!!!!!!

    If I have a backup with name
    MYDB.0.db2inst1.NODE0000.CATN0000.20080515213133.0 01

    and I start instance db2inst8 for example, is correct this commando to restore?
    db2 "restore database mydb from /data1/bkup taken at 20080515213133 to /data"

  11. #11
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    The command looks ok. You might have to do a redirected restore if the filesystems used by tablespace containers are not the same on the source and target servers.

    Are you really going to use an image from 2008. You have to make sure you have the transaction logs in order to perform the rollforward.

  12. #12
    Join Date
    Aug 2010
    Posts
    43
    The restoration is in process, I am not understood what to "restore the filesystems if Used by Not the tablespace containers are on the same source and target servers"

    I have no logs at this time but I can restore them from tape, I think the rollfordwar can wait while we retrieve the logs?

    Rollfordware is required?

  13. #13
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Don't worry about redirected restore unless a regular restore fails.

    Rollforward can wait until you retrieve the logs, but you won't be able to connect to the db until rollforward completes successfully.

  14. #14
    Join Date
    Aug 2010
    Posts
    43
    db2girl, I had other problem, because I run restore and I went to get my lunch. When I saw the restore is failed!!!, I dont have folders, I don't have database. When I run db2 "LIST UTILITIES SHOW DETAIL" say me that nothing run.

    and I have this errors:


    2010-08-19-13.39.36.097778-360 E5470411A416 LEVEL: Error (OS)
    PID : 540754 TID : 1 PROC : db2agent (instance)
    INSTANCE: db2inst8 NODE : 000
    APPHDL : 0-29 APPID: *LOCAL.db2inst8.100819172333
    FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
    CALLED : OS, -, unspecified_system_function
    OSERR : EEXIST (17) "Do not specify an existing file."

    2010-08-19-13.39.36.213112-360 E5470828A431 LEVEL: Error (OS)
    PID : 540754 TID : 1 PROC : db2agent (instance)
    INSTANCE: db2inst8 NODE : 000
    APPHDL : 0-29 APPID: *LOCAL.db2inst8.100819172333
    FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
    CALLED : OS, -, unspecified_system_function
    OSERR : EBADF (9) "A file descriptor does not refer to an open file."



    Could you help me please!!!!

  15. #15
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by hozkr hozoryo View Post
    I saw the restore is failed
    What was the exact error message?


    I think you really need to get help from a more senior DBA.
    Last edited by db2girl; 08-20-10 at 08:27.

Posting Permissions

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