What do you think about this database architecture ?

From: Nuno Martins <nunomartins_at_mail.telepac.pt>
Date: 1997/06/22
Message-ID: <33AD17F3.2234@mail.telepac.pt>#1/1

Hi,
i has informed that my 4x2GB disks will be replaced by 3x4GB disks . In that disks i have 2 databases :
- one for production in 3 disks ( very important )

• the other for test and little desenv.

I plan to do this :

	disk1		disk2		disk3
	log1_gp1	log2_gp1	system_tb(RD)
	log1_gp2	log2_gp2	temp_tb(RD)
	data_tb(RD)	index_tb(RD)	rbs_tb(RD)
					all_db_test 
					archived_logs

(RD) row device

I have another disk where oracle is installed where i can put the archived logs .

My concern is performance and rapid recovery .

Another possibility is to distribut the tablespace data and index in disk1 and disk2 ( one datafile in each ) to balance IO but this increase the time of recover .

Am i right ? Thas anyone have another sugestion or opinion?

Thank you

Nuno Received on Sun Jun 22 1997 - 00:00:00 CDT