I was at the understanding, and have tested this, that once the data is committed to the database, that is can be removed from the transaction log. I was able to keep the log file small, and restore up to the minute.

I read that in one of the SQL Books, I think that the book had a black cover, and with many pages. I have so many books, I cannot be certain.

Please let me know if I am incorrect about this info. But I was able to show it to a group of Oracle DBAs that is once worked with.

Andrew SQLDBA