Yugabyte database rollforward Point in time restore

[sid]

Hi Team,

I understand that, we can perform rollback to before snapshot time ..

For: Lets say I have taken snapshot at 09:00 AM and I can able to restore the at 09:00 AM or before 09:00AM ..for example . 08:30

My Ask is:

1. I have taken snapshot at 09:00 AM , Now time is 10:00AM
2. I have all the logs ( docDB Raft logs )
3. Now, I want to restore the database at 09:30AM PIT rollforward

Question: Is it possible to restore PIT rollforwad to 09:30AM. ? If yes please provide document reference or Some high level overview or in case this feature not available in the current release any scope for this feature? I heard its available in MongoDB.

Thanks

Sid.

[dorian_yugabyte]

Hi @sid

Please read Point-in-time recovery | YugabyteDB Docs for a full overview, it has many details inside.

@sid

Is it possible to restore PIT rollforwad to 09:30AM. ? If yes please provide document reference or Some high level overview or in case this feature not available in the current release any scope for this feature?

Yes because the db by default will keep all row versions for 24H. From the link above:

Flashback provides a way to rewind a database back to any microsecond in time over a short history retention period. Flashback is automatically and internally managed by YugabyteDB for performance purposes. The history retention period defaults to 24 hours and may be reduced to improve DB performance.