ROLLFORWARD failed

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • satish mullapudi
    #1

    ROLLFORWARD failed

    Hi,
    Am facing a tough situation & the scenario goes like this:
    I have scheduled online backup on a db. The online backup is scheduled
    to run daily at 12 in the night. Now am to restore the same db in
    another server . I have with me the backup image & 50 logs which I
    need to rollforward. When am trying to restore it is working fine &
    the db goes into ROLLFORWARD PENDING state as expected. When am trying
    to ROLLFORWARD the db, it is saying that the 45th log is corrupted, so
    rollforward operation failed. Now, is there any process, so that I can
    restore the maximum amount of data as much as possible from the logs.

    Pls help me out...

    satish
    Tags: None
    • =?ISO-8859-1?Q?Gregor_Kovac=28?=
      #2
      Re: ROLLFORWARD failed

      Hi!

      You can do a rollforward to some point in time, for example.
      You can see more at
      http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.cmd.doc/doc/r0001978.html


      If you have 100 logs and your 45th is corrupted, then none from that one
      will be used, because if it was DB2 can not guarantee you that the
      database is in consistent state.

      Best regards,
      Kovi

      satish mullapudi pravi:
      Hi,
      Am facing a tough situation & the scenario goes like this:
      I have scheduled online backup on a db. The online backup is scheduled
      to run daily at 12 in the night. Now am to restore the same db in
      another server . I have with me the backup image & 50 logs which I
      need to rollforward. When am trying to restore it is working fine &
      the db goes into ROLLFORWARD PENDING state as expected. When am trying
      to ROLLFORWARD the db, it is saying that the 45th log is corrupted, so
      rollforward operation failed. Now, is there any process, so that I can
      restore the maximum amount of data as much as possible from the logs.
      >
      Pls help me out...
      >
      satish
      --
      _______________ _____________
      |http://kovica.blogspot .com|
      -----------------------------~-~-~-~-~-~-~-~-~-~-
      | In A World Without Fences Who Needs Gates? |
      | Experience Linux. |
      -~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

        Comment

        • satish mullapudi
          #3
          Re: ROLLFORWARD failed

          On Apr 29, 5:15 pm, Gregor Kovac( <gregor.ko...@m ikropis.siwrote :
          Hi!
          >
          You can do a rollforward to some point in time, for example.
          You can see more athttp://publib.boulder. ibm.com/infocenter/db2luw/v9r5/index.jsp?topic =...
          >
          If you have 100 logs and your 45th is corrupted, then none from that one
          will be used, because if it was DB2 can not guarantee you that the
          database is in consistent state.
          >
          Best regards,
          Kovi
          >
          satish mullapudi pravi:
          >
          Hi,
          Am facing a tough situation & the scenario goes like this:
          I have scheduled online backup on a db. The online backup is scheduled
          to run daily at 12 in the night. Now am to restore the same db in
          another server . I have with me the backup image & 50 logs which I
          need to rollforward. When am trying to restore it is working fine &
          the db goes into ROLLFORWARD PENDING state as expected. When am trying
          to ROLLFORWARD the db, it is saying that the 45th log is corrupted, so
          rollforward operation failed. Now, is there any process, so that I can
          restore the maximum amount of data as much as possible from the logs.
          >
          Pls help me out...
          >
          satish
          >
          --
          _______________ _____________
          |http://kovica.blogspot .com|
          -----------------------------~-~-~-~-~-~-~-~-~-~-
          | In A World Without Fences Who Needs Gates? |
          | Experience Linux. |
          -~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
          Yupes...that ight work but I still have a small query here. How to
          know the timestamp from where to ROLLFORWARD so as to get the data in
          1to 45th logs.

            Comment

            Previous template Next
            Working...