OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » OFA and Raid (Oracle ,11g R2, Windows 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OFA and Raid [message #505822]

Thu, 05 May 2011 03:22

geobraik
Messages: 34
Registered: April 2011

Member

Hi,

Can I use OFA and Raid system together for Oracle 11g in Windows 2008 Server?
I am installing the OS in C drive. Please suggest me where to install the oracle, location for Oracle_Base, number of logical and physical drive required, size of each etc.
I am planning to use
Raid 1 - Controlfile, redolog file and archive log file
Raid 1+0 - Datafiles

Also I want to multiplex virtual memory page also.

Thanks in advance

Report message to a moderator

Re: OFA and Raid [message #505824 is a reply to message #505822]

Thu, 05 May 2011 03:28

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why don't you use ASM and OMF?

Regards
Michel

Report message to a moderator

Re: OFA and Raid [message #506063 is a reply to message #505824]

Fri, 06 May 2011 06:44

geobraik
Messages: 34
Registered: April 2011

Member

Hi Michel
Client dont want to use ASM. Database in only single noded also.
Please give me the details like
1. How many drives to be created?
2. Size of each drive
3. How many disk groups, failure groups, disks in each group etc
4. In which group to place binary files, datafile, logfiles, archive logs?

Please reply asap. I need to submit these details to the system administrator

Thanks in advance

Geobraik

Report message to a moderator

Re: OFA and Raid [message #506068 is a reply to message #506063]

Fri, 06 May 2011 07:03

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please answer asap
1. What is number of tablespaces?
2. What is the size of each tablespace?
3. What are the options used in Oracle?
4. What is the number of simultaneous sessions?
5. What is the number of simultaneous transactions?
6. What the average size of the transactions?
7. Is it OLTP, DWH or mix database?

Regards
Michel

Report message to a moderator

Re: OFA and Raid [message #506086 is a reply to message #506068]

Fri, 06 May 2011 08:42

geobraik
Messages: 34
Registered: April 2011

Member

Hi Michel,
To be frank I dont have the exact details. But request yo to answer based on the following values
1. What is number of tablespaces?
system, sysaux, undo, users(10G)
3. What are the options used in Oracle?
Oracle restart, uninstall, single node,
4. What is the number of simultaneous sessions?
30
5. What is the number of simultaneous transactions?
5
6. What the average size of the transactions?

7. Is it OLTP, DWH or mix database?
mix

Report message to a moderator

Re: OFA and Raid [message #506090 is a reply to message #506086]

Fri, 06 May 2011 08:52

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Options: Java, RAC, Spatial, interMedia... these determines the size of the SYSTEM and SYSAUX tablespaces. Count 1GB for each of them and UNDO tablespace depends on the size of the concurrent transactions.
You have a very small system. Put all on one (mirrored) disk.

Regards
Michel

Report message to a moderator

Re: OFA and Raid [message #506093 is a reply to message #506090]

Fri, 06 May 2011 08:58

geobraik
Messages: 34
Registered: April 2011

Member

Thanks Michel. I will come with the exact values once I got it

Report message to a moderator

Previous Topic:	Use of Views in migration
Next Topic:	Check for Oracle License

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 06:50:03 CST 2024