Home » RDBMS Server » Server Administration » Best tips for ASM architecture
Best tips for ASM architecture [message #643758] Sat, 17 October 2015 01:22 Go to next message
fabi88
Messages: 80
Registered: November 2011
Member
Hi,

1- How many Disk Group is recommended?(one for DATA, one For REDO and ...)

2- What is the right value of allocation unit for each Disk Group? ( what factors should be considered to select size of AU?)

3-How many LUNs for each Disk Group should be considered? What is the effect of the difference in the number of LUNs?

Regards.


Re: Best tips for ASM architecture [message #643770 is a reply to message #643758] Sat, 17 October 2015 12:33 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Oracle version?

Re: Best tips for ASM architecture [message #643776 is a reply to message #643770] Sun, 18 October 2015 00:01 Go to previous messageGo to next message
fabi88
Messages: 80
Registered: November 2011
Member
Oracle 12.1.0.1
Re: Best tips for ASM architecture [message #643777 is a reply to message #643776] Sun, 18 October 2015 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

All your questions are answered in Automatic Storage Management Administrator's Guide.
For instance, the first one in section "Determining the Number of Disk Groups".

Re: Best tips for ASM architecture [message #643780 is a reply to message #643777] Sun, 18 October 2015 03:30 Go to previous messageGo to next message
fabi88
Messages: 80
Registered: November 2011
Member
Thanks Michel Cadot,


When there is just one physical disk, for example a disk with 360G storage space, and we create one Disk Group using it, is needed to partition it (for example 8 partition) for creating LUNs(8 Luns) or not(one partition with 360G space(one Lun with 360G space) is enough)?

[Updated on: Sun, 18 October 2015 03:58]

Report message to a moderator

Re: Best tips for ASM architecture [message #643782 is a reply to message #643780] Sun, 18 October 2015 04:46 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You didn't read the book I pointed you to, did you?

Re: Best tips for ASM architecture [message #643784 is a reply to message #643758] Sun, 18 October 2015 07:19 Go to previous messageGo to next message
fabi88
Messages: 80
Registered: November 2011
Member
Yes, I read it but I didn't find answer of my question.
Re: Best tips for ASM architecture [message #643785 is a reply to message #643784] Sun, 18 October 2015 07:54 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You read a 660 pages book in 2 hours?
You read too fast, do it again quite slower.

Re: Best tips for ASM architecture [message #643798 is a reply to message #643758] Mon, 19 October 2015 01:02 Go to previous messageGo to next message
fabi88
Messages: 80
Registered: November 2011
Member

Yes, Because I did not read it alone.
Is it possible that this type of questions to be discussed at this forum? If not, I think there is no evidence to answer them in this way. You can say that this type of questions isn't allow to discuss.
Re: Best tips for ASM architecture [message #643799 is a reply to message #643798] Mon, 19 October 2015 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I say that forum is not a replacement to reading.
Forum comes AFTER reading when something is not clear.
You waste others time and steal others help time when you do the opposite.
Why should we just repeat the documentation?
I pointed you to the section which answers your first question, that is I did the work you should do before posting here.
This means I spent time for something you should and then did not take this time to help someone who really need it.

[Updated on: Mon, 19 October 2015 01:16]

Report message to a moderator

Re: Best tips for ASM architecture [message #643800 is a reply to message #643799] Mon, 19 October 2015 01:36 Go to previous messageGo to next message
fabi88
Messages: 80
Registered: November 2011
Member
Yes you are right, but I think that many of things are not gained just by reading documents, and they gain based on experience (practical work experience) that the main members of this forum have it.

[Updated on: Mon, 19 October 2015 01:54]

Report message to a moderator

Re: Best tips for ASM architecture [message #643807 is a reply to message #643780] Mon, 19 October 2015 02:24 Go to previous messageGo to next message
John Watson
Messages: 7220
Registered: January 2010
Location: Global Village
Senior Member
fabi88 wrote on Sun, 18 October 2015 09:30
Thanks Michel Cadot,


When there is just one physical disk, for example a disk with 360G storage space, and we create one Disk Group using it, is needed to partition it (for example 8 partition) for creating LUNs(8 Luns) or not(one partition with 360G space(one Lun with 360G space) is enough)?

My opinion: As you you have only one disc the number of LUNs and groups, and the AU size, are largely irrelevant. ASM is not designed to manage such a small environment.
Theoretically, even with one disc multiple partitions will force Unix to create multiple IO queues. But you'll get this benefit (if indeed it is any benefit) without the added complexity of ASM. I would not bother with it at all.

Re: Best tips for ASM architecture [message #643808 is a reply to message #643807] Mon, 19 October 2015 02:51 Go to previous messageGo to next message
fabi88
Messages: 80
Registered: November 2011
Member
Thank you so much for your useful reply Mr.John watson.

Quote:
When there is just one physical disk, for example a disk with 360G storage space, and we create one Disk Group using it, is needed to partition it (for example 8 partition) for creating LUNs(8 Luns) or not(one partition with 360G space(one Lun with 360G space) is enough)?


This was a question in my mind when there is only one disk that it became clear after your answer.
But in practice there is 3TB storage space after RAID5(we see 1 disk with 3TB space in OS), and then we partitioned this 3TB to 12 partition, is this correct that we did?

Re: Best tips for ASM architecture [message #643811 is a reply to message #643808] Mon, 19 October 2015 03:04 Go to previous messageGo to next message
John Watson
Messages: 7220
Registered: January 2010
Location: Global Village
Senior Member
I can't possible advise someone who keeps changing the story.
However, only a monumental idiot would use RAID 5 underneath ASM.
Re: Best tips for ASM architecture [message #643812 is a reply to message #643811] Mon, 19 October 2015 03:07 Go to previous message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

+1

Previous Topic: Inventory load failed... OPatch cannot load inventory for the given Oracle Home
Next Topic: ORA-03113: end-of-file on communication channel
Goto Forum:
  


Current Time: Sat Jan 20 19:59:49 CST 2018

Total time taken to generate the page: 0.25889 seconds