Hi
all

I need to know about point in recovery.
I want to restore the database at some point of time from online backup and logs.

I have backup image and logs but i want to restore database with some logs only
example:

I have online backup image of Monday morning
database tables were wrongly updated monday evening
i want to restore database up to monday afternoon


Thanks and regards
prasad

After RESTORING the DB (with the Full Backup taken on SUNDAY), roll forward to a point in time:

e.g. You can use different option with ROLLFORWARD:

db2 rollforward db sample to 1998-04-03-14.21.56 and stop overflow log path (/logs)

Please refer to the IBM manual for the same for more details where ONLINE Backup restoration is mentioned very clearly with lots of great examples.

Hi Jayanta

Thankyou very much for replay.

VaRaPrAsAd

hi folks,

well, every one telling that how to rollforward to a point in time.
i am confused tat, do we have multiple point in times or only one. if we have multiple, how to trace them? history file or diaglog or any other source?? what are the scenarios tat a particular point in time will be created??
plz plz plzzzzzzzzz explain if any one can...

thank you
Jagdish

You decide yourself which point in time (or otherwise said: time instant) you want to restore to; in the example above that was the time instant "1998-04-03-14.21.56".
That's all you need to tell DB2: it will play all the logs of committed changes just until that point-in-time.

Hi Peter,

Thank you for the information provided.
My doubt is, I don't know these time instants but I know the sequence of tasks that I have performed. I need to restore my database till a particular task(That should be a consistent point, right?). How would i trace those consistency points.

Another doubt is, we are at a consistency point, and we are performing some database operations( may be DML, DDL, reorg, backup or any other). In what context again a consistency point is created? Hope I explained my doubt clearly.

I guess you are new to Database world.


Point of time recovery means. You should be able to recover the database from backup and apply the the logs until what time you the restore needs to be done.

In that case, couldn't you just perform those tasks inversely?
Or, if that's impossible, first restore the tables under consideration to a point in time (maybe a backup time) just before those tasks, then perform the sequence of tasks again, but just those that you want to be performed.

(I don't know enough of your particular situation to be more specific than this, sorry.)

Thank you dear edoo.okati,

I know that if we rollforward to a particular time stamp, the database will be restored to a nearby consistency point. if we rollforward to a random timestamp, it will restore to a prior consistency point(may be Im wrong).

Dear Peter,

Practically I faced this situation. More over I was not provided with any script except a backup image and a bunch of log files. But thank god Im not in production.