Restore only changed pages using bitmaps

Registered by Laurynas Biveinis on 2013-05-02

PeterZ:

   Lets say I have taken full backup yesterday with LSN=1000 and have
   changes created today there is LSN=2000 and I want to roll back to
   the state of yesterday for whatever reason. Instead of copying
   full data from that backup I can just copy changed pages to perform
   rollback. If we have full backup plus couple of incremental
   backups it becomes more complicated of course.
   Anyway I do not think we need to rush something like this. I
   mainly though this is an interesting conceptual idea though it is
   not priority to do it in practice.

Laurynas: this would only work if the server data dir is knowingly non-corrupted. Also, not sure what to do about the new data pages at the end of tablespaces. Probably the tablespaces would remain extended to their size at LSN 2000, and then not sure if the extra data page presence would cause any problems or not.

Blueprint information

Status:
Not started
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Needs approval
Assignee:
None
Definition:
Discussion
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.