RE: Querying V$ views within scripts

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ruth Gramolini Sent: 20 January 2005 16:51
To: adar76_at_inter.net.il; oracle-l_at_freelists.org 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Yechiel Adar Sent: Thursday, January 20, 2005 10:17 AM To: oracle-l_at_freelists.org
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_at_centrexcc.com> To: <stephenbooth.uk_at_gmail.com>
Cc: "Johnson, George" <GJohnson_at_gam.com>; <oracle-l_at_freelists.org> 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
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l