Once a month for DW, here. Sometimes more often, depending on the amount of ad-hoc requests from the Peoplesoft brigade. For some reason, they need an entire copy of the db to test a dropdown menu... -- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxx Jack van Zanen wrote,on my timestamp of 18/12/2008 8:52 AM:
Hehe, I was just about to mention that.We prove our RMAN backups to tape work just about every day when we refresh test/staging/development/UAT databases Including every now and than a year old backup where tapes have to be brought back in and inserted into the tape unit. Quite comforting knowing you can restore your data Jack2008/12/18 Niall Litchfield <niall.litchfield@xxxxxxxxx <mailto:niall.litchfield@xxxxxxxxx>>I'm a little suprised that all the discussion has focussed on creating test databases. The dba can often get away with murder, they cant get away with failure to recover data. Database cloning both tests and demonstrates that your backups can be recovered and in a reasonable time frame. Or of course sometimes not.
-- //www.freelists.org/webpage/oracle-l