Re: Datafile size for backup consideration...

A one year planning window makes sense. Three years is a long stretch, especially since the database, applications and just about everything else is likely to change in that time.

If you are concerned about the price of tapes, you are looking at the wrong expense. What is the cost of losing your database and not being able to recover? Tape is very inexpensive insurance compared to the value of the data.

Pete Barnett
Database Administrator
The Regence Group
pnbarne_at_regence.com

Slamet Fusianto wrote:
>
> Dear DBAs,
>
> When we first create tablespace (user, index, temporary, etc) and datafiles,
> should we consider a large amount of datafiles ? What I mean is now I make one
> datafile for tablespace User is 500 MB. I consider this to be for 3 years ahead.
> Now if I take backup for this tablespace only (for example), it will surely make
> tape backup full after couple of weeks (capacity of tape backup is 4 GB it means
> that if I take full backup every week, the tape will be fulled in 2 months).
> Sure how many tape backups will be used is not our prime considerations, but
> cost will not be so high.
> But I want to ask is should I make a smaller data file, just say 50 MB and then
> after running few months, I can add extents or make new datafiles for this
> tablespace. Or perhaps just make directly 500 MB ?
>
> Thank you for the answer.
>
> Regards,
>
> Slamet Fusianto
>
> --
> Author: Slamet Fusianto
> INET: yangken_at_cbn.net.id
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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 Wed Jul 19 2000 - 21:22:01 CDT