This content has been marked as final. Show 6 replies
dont need downtime. add the nfs or disk, stamp it with asm, once youve created the asm disk, add it to your asm datagroup
asm rebalances automatically.
this link is good for me as a DBA , but now i'm asking for o.s level i mean the my database is take from the storage is 600 GB
if i take more then 1TB is this require downtime add new disk or expand the existing one ??
theres nothing about the 1tb mark that will explicitly mean you have to take down a storage device. Some storage can be extended some needs rescanning where you need downtime. Depending on what you have youll have to take it down whether you want to extend by 1mb or 1tb. ie, if it needs to come down, it needs to come down
Ive had a storage guy extend a volume from a SAN, I rescanned the HBAs and no downtime needed on ASM.
861100 wrote:That depends on your storage architecture and ASM diskgroup layout. Do you have spare space on existing disks? In what format? What sizes? How is the in-use space configured and how is it used by ASM?
kindly we need your advice we have oracle 11g.2 ASM RAC under OL 5.6
and we have storage is 5.6 TB allocated for med database is 600 GB now we need more space
which option is batter expand space to our disk or add new disk
For example, if the existing ASM diskgroup is high redundancy, 600GB of database space requires 3x600GB storage space.
If the existing diskgroup is a 2x500GB disks configured as external redundancy, then adding a 600GB disk will unbalance the diskgroup as the new disk is not the same size as the existing disks. Ideally 2x500GB disks need to be added instead to make 600GB available. Etc.
So it all comes down to WHAT you use as storage and HOW you use it. Which you neglected to mention...
but i need to tell me is this action require downtime ??? due to we use ASM ???ASM enables you to rip out the entire existing storage layer and replace it with a brand new layer (from actual storage servers to fabric layer, to I/O protocol) - without a single second of database downtime.
So yes, ASM provides one with a rich set of features and functionality to manage the storage layer with as little impact as possible on the database layer. However, the actual impact depends entirely on what needs to be done to address the storage problem/change.
"which option is batter expand space to our disk or add new disk"
i am 100% sure the answer is in the Oracle manuals.
it states that you should preferably ADD disks and not RESIZE them, although the latter is possible.
resizing is riskier. you could easily lose data if you make a mistake.
as always, there is no simple rule. it may be that your initial disk size is way too small to be practical. in that case you may want to 'resize' which you could do in various ways, like resizing the disks in an existing diskgroup, or creatiing a new diskgroup and copy the data.
as for the manuals: you realy, realy should read them. there full of important information, which may be a lot more trustworthy than the advice from forum folk like me :)
thanks all i get good idea .