Creating a very large database ( Oracle 8 under Solaris - a3500 fc-al arrays )

Creating a very large database ( Oracle 8 under Solaris - a3500 fc-al arrays )

Hi

I have been given the task of creating a fairly large database about 200 gig as data from variouse non-oracle database will be loaded into it - the database is going to be a 24x7 OLTP type, there will be about 35 to 40 tablespaces, and the database is expected to grow rapidly.

Would like to receive your expert recommendations on the following issues :

1. What should be the size of system tablespace for a database of this size and storage parameters configuration for the system tablespace to avoid dynamic extension.
2. How the datafiles should be placed across the disks to minimize contention
3. As the database will be growing fast and at certain point of time we would like to move the old data to a data-warehouse to keep it to a managable size - any suggestions on that will be welcomed too.
4. What should be the backup strategy (full and incremental)
5. any other issues of importance i.e. initial parameters etc.

Tks so much for your time

Rekha Received on Thu Mar 23 2000 - 04:19:01 CST