Tim,
I cannot speak for the 35Gb datafile which is a one-off but for the systems
where we have
datafiles files > 4Gb we invariably use EDM to "break a mirror" and then
RMAN proxy against that.
The mirror is then kept off-line until we are ready to do the next backup.
At that point the mirror is 're-silvered' ('timesliced' is another
expression used) and then the process starts again.
The archived redo logs are kept on a seperate volume group and secured via
RMAN.
If a large datafile has to be recovered then that vg is re-silvered (which
is very fast) and then changes from the redo logs applied.
I agree that recovery of a large datafile will take longer if the required
file is older than the copy of the broken disk. I assume that this was
discussed and agreed with the business beforehand. If we had to recover to
a point in time greater than 1 day ago then I suggest we would be in
significant trouble anyway
John
-----Original Message-----
Sent: 26 September 2002 14:28
To: Multiple recipients of list ORACLE-L
Datafile sizing affects the speed of backup and restore, since each datafile
can only be backed up or restored by one process at a time. As a result, I
try to keep datafiles at uniform sizes of 2-4 Gb max. How do such large and
variable-sized datafiles impact your backups and restores? Just curious...
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 6:28 AM
> Yes, 10Gb datafiles.
> I think we have a 35Gb datafile somewhere but I have not looked at that
> database myself
>
> John
>
> -----Original Message-----
> Sent: 26 September 2002 12:03
> To: Multiple recipients of list ORACLE-L
>
>
> 10001Mb?
>
> the uniform extent sizes map to what I'll be using as well. good to
> know I'm not way off track
>
> --- [EMAIL PROTECTED] wrote:
> > We tend to use multiples of 1Gb and add 1 Mb to the file so that we
> > get
> > 2001, 10001 Mb etc
> > Solaris 2.8
> > LMT uniform extents range from 64K to 20Mb
> >
> > John
> >
> > -----Original Message-----
> > Sent: 25 September 2002 19:44
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > We created two datafiles of 16GB+64K all LMT autoallocate ... never
> > gave a
> > problem. A basic testing concluded that fixed size allocation of 128M
> > caused
> > unnecessary delays whereas autoallocate was much faster. I don't know
> > the
> > full details yet, but I'll know soon.
> >
> > Of course this is undergoing lot of testing (the whole application,
> > no
> > problems with datafiles yet), but we will probably settle for about
> > 4GB+64K.
> > This is AIX5L 64 bit running Oracle 9iR2.
> >
> > Raj
> > ______________________________________________________
> > Rajendra Jamadagni MIS, ESPN Inc.
> > Rajendra dot Jamadagni at ESPN dot com
> > Any opinion expressed here is personal and doesn't reflect that of
> > ESPN Inc.
> >
> > QOTD: Any clod can have facts, but having an opinion is an art!
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
