Hi,
I'm designing a Oracle 8.0.6 database on NT server, with 2 groups of disks on
RAID5. This is an historical database, with one table having to grow to 500
million rows in 2 years, and row size around 200 bytes.
I'm looking for any advice regarding partitions, indexes and backup.
I would try to explain exactly what I have:
-table OPERATIONS (1 million rows loaded each night, for 2 years 500 mil
rows,
aprox 100Gb)
-table BOXES (10000 rows loaded each night, is external key for table
OPERATIONS, can be modified by user)
-table BIGBOXES (1000 rows inserted by user during the day, is external key
for table BOXES)
I'm thinking to partition the table OPERATIONS by DATE, as rows inserted each
night have all previous day. Problems here:
- how big to make the partitions (week: 1Gb, month: 4Gb)?
- is a good idea to partition also BOXES and, eventually, BIGBOXES tables?
- there is a numerical column OPERATIONS.DIPENDENCY, range 1 to 1000, used in
most selects from OPERAZIONE. An option could be to partition the table using
two colums (DATE, DIPENDENCY), with larger ranges for DATE: (DATE 3 mounts,
DIPENDENCY: 10 ranges 1-100,101-200,...).
This way I cand create local prefixed indexes in partitions, using colums
(DATE, DIPENDENCY)
Backup problems (I use ARCHIVELOG mode):
- which is the best way to backup partitions, so that it wouldn't be any
problems (or archivelogs/recovery needed). An option could be to make old
partitions read only, but I'm not sure in this help since I know SCN are
written in Control File and datafiles?
- a cold backup strategy of whole database each day is too much, but I could
backup with database closed during the night. Would you recomend a cold
backup or hot (incremantal)?
Thanks alot,
Alex.
- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
NewsOne.Net prohibits users from posting spam. If this or other posts
made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Wed Feb 14 2001 - 05:36:13 CST
