RE: Querying V$ views within scripts
- From: "Howard Latham" <howard.latham@xxxxxxxxxx>
- To: <rgramolini@xxxxxxxxxxxxxxx>, <adar76@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Jan 2005 17:00:02 -0000
Except with 10 where you can log which blocks change - well I am trying
out
Don't know yet how good this is.
Howard
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ruth Gramolini
Sent: 20 January 2005 16:51
To: adar76@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Querying V$ views within scripts
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.
Ruth
-----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: <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=20
> >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=20
> >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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
