Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2010
    Posts
    207

    Unanswered: Missing Log for Rollforward

    hello there!

    I have a problem. I made a redirected restore and now i want to make the rollforward to make the database accessable.


    db2 "rollforward db rmdwh query status"

    Rollforward Status

    Input database alias = databasedwh
    Number of nodes have returned status = 1

    Node number = 0
    Rollforward status = DB working
    Next log file to be read = S0000014.LOG
    Log files processed = -
    Last committed transaction = 2011-01-01-03.00.00.000000 UTC





    db2 "rollforward db database stop"
    SQL1276N Database "Database" cannot be brought out of rollforward pending state
    until roll-forward has passed a point in time greater than or equal to
    "2011-01-01-03.00.00.000000 UTC", because node "0" contains information later
    than the specified time.


  2. #2
    Join Date
    Jan 2010
    Posts
    207
    Now I read something about the rollforward stop command.
    I have no chance to get the log file back. is there an other way to make the database running? I am thankful for each help.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What db2 version are you using? Check if the logs were included with this backup image.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if it was an offline backup - you can rollforward stop
    if online ?? or included in backup - specify the logpath to extract the logs while restoring or rerun the restore with option logs - will only extract logs
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Jan 2010
    Posts
    207
    The log was lost and so I was not able to made a restore ...
    Thank you for your help.

  6. #6
    Join Date
    Nov 2010
    Posts
    14
    if it was an offline backup - you can rollforward stop
    if online ?? or included in backup - specify the logpath to extract the logs while restoring or rerun the restore with option logs - will only extract logs
    To add more info on what przytula_guy said, information on backup image can be extracted by using,

    Code:
    db2ckbkp -H <backup_file_name>
    Backup Mode ( 0=offline, 1=online)
    Include Logs (0=exclude logs, 1=include logs


    Thanks,
    SK Chandra

Posting Permissions

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