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 Jack 2008/12/18 Niall Litchfield <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. > > On 12/17/08, nilesh kumar <nileshkum@xxxxxxxxx> wrote: > > Thank you very much for your suggestions,help and support. Its a great > group > > with lot of expertise. > > > > Nilesh > > > > On Wed, Dec 17, 2008 at 11:46 PM, Howard Latham > > <howard.latham@xxxxxxxxx>wrote: > > > >> unless its a small database Say <80g then shut it down copy it ! > >> Simple if you can get away with it > >> > On 12/17/08, Dennis Williams <oracledba.williams@xxxxxxxxx> wrote: > >> > > Nilesh > >> > > > >> > > 1. Some databases are so large that cloning is the only method of > >> creating a > >> > > test database. > >> > > 2. Before a production change is made, it is recommended that change > >> > > be > >> made > >> > > in a test database and then tested. This can avoid the awkward > >> situation of > >> > > production changes that need to be backed out. Cloning produces an > >> exact > >> > > copy of the production database. > >> > > > >> > > Dennis Williams > >> > > > >> > -- > >> > //www.freelists.org/webpage/oracle-l > >> > > >> > > >> > > >> > >> > >> -- > >> Howard A. Latham > >> -- > >> //www.freelists.org/webpage/oracle-l > >> > >> > >> > > > > > > -- > > Soni > > Temples & Softwares are more or less the same, first we build them and > then > > we pray ;) > > > > -- > Sent from Google Mail for mobile | mobile.google.com > > Niall Litchfield > Oracle DBA > http://www.orawin.info > -- > //www.freelists.org/webpage/oracle-l > > > -- J.A. van Zanen