Topic
4 replies Latest Post - ‏2013-10-25T09:03:14Z by njk6199
bronsonandrades
bronsonandrades
64 Posts
ACCEPTED ANSWER

Pinned topic db29.7 restore

‏2012-07-27T16:02:19Z |
Db2 9.7

Hello team,

While do restoration of sample database, i am getting the below exceptions:
$>db2 "rollforward db sample to end of logs and complete OVERFLOW LOG PATH (/optware/db2/testing/to_log)"
SQL1265N The archive log file "S0000024.LOG" is not associated with the
current log sequence for database "SAMPLE" on node "0".
How do i come out of it??
Updated on 2012-07-31T21:16:38Z at 2012-07-31T21:16:38Z by SystemAdmin
  • mor
    mor
    316 Posts
    ACCEPTED ANSWER

    Re: db29.7 restore

    ‏2012-07-27T17:03:14Z  in response to bronsonandrades
    Show what actions you took (and their results) from the suggestions in:
    db2 "? SQL1265N"

    Use db2ckbkp to see the txn log range covered by the backup-image.
    Compare that information to the log files that are in the overflow path.
    • SystemAdmin
      SystemAdmin
      17917 Posts
      ACCEPTED ANSWER

      Re: db29.7 restore

      ‏2012-07-27T18:12:23Z  in response to mor
      Try looking here:

      http://db2commerce.com/2012/07/26/sql1265n-on-rollforward-when-restoring-database-from-one-server-to-another/?utm_source=rss&utm_medium=rss&utm_campaign=sql1265n-on-rollforward-when-restoring-database-from-one-server-to-another

      Andy
      • SystemAdmin
        SystemAdmin
        17917 Posts
        ACCEPTED ANSWER

        Re: db29.7 restore

        ‏2012-07-31T21:16:38Z  in response to SystemAdmin
        Hello ArWinner,

        Really nice read on your link.

        Can you take some time to read through a similar problem I have been encountering while restoring a database 2-3 times in a particular order to result in the same message

        https://www.ibm.com/developerworks/forums/thread.jspa?threadID=439493&tstart=45

        Can you share your thoughts on whether what you did will work in my case?

        Regards,
        Sameer