Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle on cluster

Posted on 2010-11-18
2
Medium Priority
?
705 Views
Last Modified: 2013-11-11
I am installing oracle on Linux cluster.
The cluster software is vcs
the shared storage is  Hpmsa2000
what sort of partitions and filesystems I should have in the shared storage?
0
Comment
Question by:taaz
2 Comments
 
LVL 16

Accepted Solution

by:
Richard Olutola earned 2000 total points
ID: 34171023
If you're using ASM then Oracle recommends creating a minimum of 4 equal-sized paritions for each disk group.

You need at least 2 groups - DATA and RECO (recovery/flash recovery area). In addition, I create a third disk group called CRS where I place the CRS and Voting disk.

So in all I created 12 partitions.

For example 4 x 512M for CRS. 2GB total for the CRS disk group. Note that this doesn not need to be this large but I have plenty to play with.

Then 4 x 1024GB for DATA disk group. This gives me 4TB for the Data space.

Lastly, 4 x 256G for RECO disk group. This equates to 1TB for my recovery area which will hold archivelogs and other flash recovery components.

HTH

0
 

Author Closing Comment

by:taaz
ID: 34172825
Thnks and it was a great help
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question