ASM File size [message #486654] |
Sat, 18 December 2010 00:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
Hi, we are new to ASM storage.
In 10g and above,with normal fize system ,we used to have multiple files for each tablespaces, with same size.
eg :Tablespace USERS
Users1.dbf 4gb
Users2.dbf 4gb
Users3.dbf 4gb etc...
What is the best option,with an ASM storage.Create a sigle file of 12GB or use multiple files ? Thanks
|
|
|
|
|
Re: ASM File size [message #486670 is a reply to message #486654] |
Sat, 18 December 2010 03:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
Thanks Mike.
@MR:
To distribute I/O to multilpe filesystem.
And better rman backup perfomance(i am still not sure how).
Would rman backup perfomance gona affect having a single large file ?
|
|
|
Re: ASM File size [message #486671 is a reply to message #486670] |
Sat, 18 December 2010 03:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Would rman backup perfomance gona affect having a single large file ?
Not with ASM, a file does not mean a single disk (unless you only have one physical disk).
Regards
Michel
[Updated on: Sat, 18 December 2010 03:35] Report message to a moderator
|
|
|
Re: ASM File size [message #486672 is a reply to message #486671] |
Sat, 18 December 2010 03:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
i just read about "SECTION SIZE" in rman , to enable "Multi-section backups" .I gues its a new 11g feature.
I need to do r&d wit this. I will update you if any finding.
Please share your exp if you are already using it. THANKS
|
|
|