and you should use rman with full backup at night and incremental backup each hour, to minimize the impact. Yechiel Adar Mehish Computer Services ----- Original Message ----- From: "Wolfgang Breitling" <breitliw@xxxxxxxxxxxxx> To: <stephenbooth.uk@xxxxxxxxx> Cc: "Johnson, George" <GJohnson@xxxxxxx>; <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, December 14, 2004 3:39 PM Subject: Re: Querying V$ views within scripts > At 06:25 AM 12/14/2004, stephen booth wrote: > > >In this case they want *hourly* backups of the database to minimise > >dataloss. I told them that with the redo logs I can use the previous > >night's backup and roll forward to any point in time before the > >failure, but see above comments about managers. > > If they want hourly backups, actually unconditionally, they should use rman. > > > Regards > > Wolfgang Breitling > Centrex Consulting Corporation > http://www.centrexcc.com > > -- > //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l