Mr. Hanky,

Yeah! I understand now. But if you think over from B&R perspective Is'nt its lot easier to have daily hot backup midnight which takes away costs on disk for archive logs. DBAs can recover within 15 to 30 minutes rather few hours to import and recreate indices and go from there.

Thats whole another story of enabling archive mode and issues with performance which can be tuned for optimum performance. I don't see benifits having only exp/imp B&R methodology. I see only the practical benefit off of exp/imp methodology is object level recovery (Human mistakes of table drops etc.) Anyway, it has become more likedebate now