topic point-in-time recovery with snapshots and transaction logs in Operating System - HP-UX

point-in-time recovery with snapshots and transaction logs

Mladen Despic — Thu, 19 Feb 2004 12:00:48 GMT

If one recovers a database from a snapshot, which was taken, say, at 9:00AM (via something like Online JFS, or Business Copy XP), is it then possible (or can it be made possible) to apply transaction logs corresponding to the time interval 9:00 AM - 9:30 AM, so that the final result is the point-in-time recovery for 9:30 AM?

I'm primarily interested in Sybase, ASE 12.5, but I'm also curious to hear about your experiences with Oracle. Some people say that, with Sybase, you can only apply transaction logs if you recover from the Sybase dump first, but others say that Oracle allows combining the snapshots with the transaction logs. Have you tried anything along these lines, and if so, does it work?

Mladen Despic

Re: point-in-time recovery with snapshots and transaction logs

James A. Donovan — Thu, 19 Feb 2004 12:07:10 GMT

You can certainly do it that with Oracle. It's one method of an incomplete recovery, called time-based recovery.

Here's a nice link w/explanations:

http://www.infomaxweb.com/Oracle8i/IncompleteRecovery.htm

Re: point-in-time recovery with snapshots and transaction logs

Brian Crabtree — Thu, 19 Feb 2004 12:33:00 GMT

Mladen,

Jim is correct, and the link would be good to read through. To point you to it a bit easier, you are looking for the 'time based' recovery.

The command is:
recover database until time 'YYYY-MM-DD:HH24:MI:SS';

The date notation I used is the default for Oracle, however it can be changed (nls_date_format and nls_time_format), so you need to be careful. For 2/19/2004 at 9:30am, it would be:

recover database until time '2004-02-19:09:30:00';

Thanks,

Brian