| Adding Data_file [message #282626] |
Thu, 22 November 2007 12:17  |
youngb912
Messages: 56
Registered: October 2007
Location: New York
|
Member |
|
|
Happy Thanksgiving to you all....
I need helping creating/adding datafile to a tablespace.
Below is the comman I have just used to create my logical volume. The logical volume is now created. I need to know how do I get the datafile created. I am using raw device as you can see. Or is the LV the datafile?
mklv -U oracle -G dba -P 600 -t raw -y rmandb_0032_003stagevg 1
|
|
|
|
|
|
|
|
|
|
| Re: Adding Data_file [message #282784 is a reply to message #282781] |
Fri, 23 November 2007 07:37  |
youngb912
Messages: 56
Registered: October 2007
Location: New York
|
Member |
|
|
Maybe, I needed to explain myself. Sorry for any confusion.
In Oracle database administration, (raw device in UNIX) a DBA is task with creating a datafile, creating tablespce and adding the datafile to the tablespace. In most shop a UNIX Administrator might do the datafile creation.
Firstly, I created the volume group
Next the logical volume
Later created a tablespace
My question now is how do I create a datafile to add to the the tablespace or is the logival volume preceded by a letter the datafile?
To answer this question you must be a dba with UNIX experience.
|
|
|
|
|
|
| Re: Adding Data_file [message #282789 is a reply to message #282788] |
Fri, 23 November 2007 07:55 |
youngb912
Messages: 56
Registered: October 2007
Location: New York
|
Member |
|
|
Let me stretch my luck one more time!
Procedure I am following to add datafile to this tablespace base on my environment is:
CREATE a logical volume as root
1.
mklv -U oracle -G dba -P 600 -t raw -y rmandb_0032_003stagevg h1
RUN the following to add a datafile
2.
Alter tablespace tablespace_name add datafile ‘/dev/<device_name>’ seize ##;
In this case what will my device_name be? The device name is what I have been referring to as datafile all this time. I hope you understand my question now.
To rephrase….I have created the LV above and need to add a datafile to a tablespace. Where does the datafile name/device name come from?
Please send me any question that will enable you help me.
Thanks
[Updated on: Fri, 23 November 2007 07:57] Report message to a moderator |
|
|
|
|
|
| Re: Adding Data_file [message #282796 is a reply to message #282793] |
Fri, 23 November 2007 08:22 |
youngb912
Messages: 56
Registered: October 2007
Location: New York
|
Member |
|
|
I finally got everything done. The device I created while creating the logical volume is the one I aded to the tablespace as datafile....just preceded the device_name by r for raw.
Thanks moderator.....your responses gave me the courage to dig deeper.
[Updated on: Fri, 23 November 2007 09:07] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
