RE: Querying V$ views within scripts

  • From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
  • To: <adar76@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 20 Jan 2005 11:50:58 -0500

An incremental backup still has to read every block to see if it's been
changed so the time is pretty much the same.  The only impact that would be
lessened would be on the writes to the backup sets.  You can so an
archivelog backup every hour and that would definitely be less overhead and
might fit the bill.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Yechiel Adar
Sent: Thursday, January 20, 2005 10:17 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Querying V$ views within scripts

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: <>
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
> Regards
> Wolfgang Breitling
> Centrex Consulting Corporation
> --
> //



Other related posts: