| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: datafile sizing question
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...
> 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
>
> --- John.Hallas_at_vodafone.co.uk 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: John.Hallas_at_vodafone.co.uk
> >
> > 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: John.Hallas_at_vodafone.co.uk
>
> 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: ListGuru_at_fatcity.com (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: Tim_at_SageLogix.com 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: ListGuru_at_fatcity.com (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: John.Hallas_at_vodafone.co.uk 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: ListGuru_at_fatcity.com (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).Received on Thu Sep 26 2002 - 10:23:36 CDT
 |
 |