RE: Fuzzy checkpoints.

<SNIP> >To William's statement that he does not trust Fuzzy Checkpoint and so has >to restore an archive and roll forward the logical logs, I submit that that >will result in the exact same level of data loss as fast recovery OR MORE, >but never less. Since you do not trust the output of the engine near the >crash I suspect that you said 'no' when the restore asked if you wanted to >backup the last logical logs from disk. In this case your restore has only >the last backed up logical logs and at least a few records are missing so >that more transactions will likely be rolled back than if you just trusted >the engine designers. > I was just trying to state needing to restore could be more likely in 9.2 in the case of crash. The systems I deal with are OLTP, and downtime is considered quite bad. We use 8mm drives for our backups so restores take awhile. I have not experienced a loss of data, I am just trying to make sure I understand what I am getting into. I agree that as long as my backups are good no more loss of data will occur, than in fast recovery. I am just trying to figure out if I will be more likely to get corrupt pages, not stating I am going to restore instead of going through fast recovery. In the previous design I could think of no situation beyond a bad disk which would cause fast recovery to not do everything. I am not as confident in the current design, but will allow that I am not as familiar with the current design. I figure fast recovery will find the bad pages and report them if they are there when it rolls forward all the transactions. So if fast recovery claims success I believe it, but is it more likely to be unsuccessful? Will <SNIP> ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------