Re: Size of an archive log file for dataguard

clint_silver wrote:
> In case we need to invoke DR we may be able to live with the last known
> backup (ie the last night)..sorry if my understandings of the concepts
> are way off but how about using incremental backups of my prod and
> using scripts to copy to DR site and restore there .. all SIDs, files
> etc would be replicated

Where are you backing up to? If you really want to copy the whole shebang over once a day, you are really kind of re-inventing the concept of the standby database, as it does that for you.

> If, for example, I have 1GB of archive per day, a lot of that is full
> table updates (poor app design, cant do anything about it) where before
> and after images are being stored,

My guess (if 1GB is actually the real number) is you are concerned about something that probably isn't valid. Unless you are using a 14.4K modem to transfer that 1GB, you will probably never even notice it.

> if incremental backups are only
> backing up changes then (Im thinking based on limited knowledge) that
> theres not 1GB of backup, theres a lot less as "before images" wouldnt
> be backed up.
>
> would that minimise the amount of data I need to send over the line?
>

In terms of the incrementals, those changes you reference will still update the SCN in the block for all the rows changed, so RMAN will still look at that as a change and backup the block (i.e., most of them it sounds like).

Is the 1GB number real? Is this really for DR? Which version on what platform?

HTH, Steve Received on Mon Nov 13 2006 - 11:51:57 CST