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

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??
  • mor
    mor
    577 Posts

    Re: db29.7 restore

    ‏2012-07-27T17:03:14Z  
    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

    Re: db29.7 restore

    ‏2012-07-27T18:12:23Z  
    • mor
    • ‏2012-07-27T17:03:14Z
    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.
    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

    Re: db29.7 restore

    ‏2012-07-31T21:16:38Z  
    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
    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
  • njk6199
    njk6199
    1 Post

    Re: db29.7 restore

    ‏2013-10-25T09:03:14Z  
    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