Doubts about RAC Setup [message #438054] |
Thu, 07 January 2010 00:13 |
yousuffudin
Messages: 1 Registered: January 2010
|
Junior Member |
|
|
Hi Guyz,
I have few doubts about RAC setup.
Oracle people has configured RAC 10R2 on HP unix.The storage we are using is SAN.
The storage is not mounted.Can we user the storage without mounting it??
They created Volume groups as vgstgdata,vgstgora etc...
so in our database we have 25 tablespaces,oracle people has created 25 LVMs.
If I want to create one more tablespace say 26th tablespace,do I need to create one more LVM??
For example we have one tablespace as cargo_data,for that they have created LVM as cargo_data with 3GB size.
So,Now i don't know how to create the tablespace with this LVM??
Regards,
yousuf
|
|
|
Re: Doubts about RAC Setup [message #438152 is a reply to message #438054] |
Thu, 07 January 2010 04:46 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>> do I need to create one more LVM?
yes.
>>Now i don't know how to create the tablespace with this LVM??
Use Oracle Command "Create tablespace".
Google/search this site for more examples.
Essentially, the LVM will hold just the datafile.
One or more datafiles make the tablespace.
Create the tablespace with your options (check how others have been created). In the simplest form, it could be
something like this.
create tablespace myTablespace datafile ('/mypath/myTablespace.dbf') size X other_options;
|
|
|