> Sorry -- I should have clarified my terms. What I am
> referring to is the ability to recover the database to
> any select point in time.
>
> Oracle(tm) calls this a redo log, and, when archiving
> is turned on, there is a continuous string of historic
> transactions that can be applied, if necessary, to a
> previously taken backup, thereby recovering to a
> point-in-time.
They keep their transaction rollback log in a separate area, and back
that up periodically to do the restores. We keep our rollback stuff in
the database, and it says until a vacuum is performed. That makes it
harder for us to pull out the redo log information for seprate periodic
backup.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026