- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Confrim the process of addition and deletion o...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-20-2008 12:55 PM
тАО03-20-2008 12:55 PM
Confrim the process of addition and deletion of raw file in db ~
Below are the detailed steps and dba steps to add these luns to database:
Sample file: LUN
/dev/rdsk/c13t12d4
: /dev/rdsk/c12t12d4
Server1
Server1dev/rdsk > ls -l | grep c13t12d4
crw-r----- 1 bin sys 188 0x0dc400 Aug 24 11:16 c13t12d4
****verify device file existence and obtain major minor numbers
Server1dev/rdsk > ls -l | grep 0x0dc400
crw-r----- 1 bin sys 188 0x0dc400 Aug 24 11:16 c13t12d4
****ensure nothing else is associated with this device by searching on minor
Create a link using mknod command : very very careful using this command improper use this command may currpt the correspondin the LUN which you were not supposed to use :
# /usr/sbin/mknod sid_f11_fix_50g c 188 0x0dc400
Now Verify that file has been hooked up to the LUN :
# ls -l | grep 0x0dc400
crw-r----- 1 bin sys 188 0x0dc400 Aug 24 11:16 c13t12d4
crw-r--r-- 1 root sys 188 0x0dc400 Aug 24 12:36 rdw1_f11_fix_50g
*****verify node matches correct device
Give the required Oracle righs to the file :
chown oracle:dba rdw1_f11_fix_50g
# ls -l | grep 0x0dc400
crw-r----- 1 bin sys 188 0x0dc400 Aug 24 11:16 c13t12d4
crw-r--r-- 1 oracle dba 188 0x0dc400 Aug 24 12:36 sid_f11_fix_50
And add this file on both the cluster node and add the file to database using alter database datafile..
Similaraly.. i have many unused raw devices which are not being used in oracle.. I wanted to re-make use of them..
Can any one givs me the commands to clear the raw devies and re-add the raw to db.
Thank you
Sredhar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-20-2008 12:59 PM
тАО03-20-2008 12:59 PM
Re: Confrim the process of addition and deletion of raw file in db ~
Sample file: LUN
/dev/rdsk/c13t12d4
: /dev/rdsk/c12t12d4
Server1
Server1dev/rdsk > ls -l | grep c13t12d4
crw-r----- 1 bin sys 188 0x0dc400 Aug 24 11:16 c13t12d4
****verify device file existence and obtain major minor numbers
Server1dev/rdsk > ls -l | grep 0x0dc400
crw-r----- 1 bin sys 188 0x0dc400 Aug 24 11:16 c13t12d4
****ensure nothing else is associated with this device by searching on minor
Create a link using mknod command : very very careful using this command improper use this command may currpt the correspondin the LUN which you were not supposed to use :
# /usr/sbin/mknod sid_f11_fix_50g c 188 0x0dc400
Now Verify that file has been hooked up to the LUN :
# ls -l | grep 0x0dc400
crw-r----- 1 bin sys 188 0x0dc400 Aug 24 11:16 c13t12d4
crw-r--r-- 1 root sys 188 0x0dc400 Aug 24 12:36 sid_f11_fix_50g
*****verify node matches correct device
Give the required Oracle righs to the file :
chown oracle:dba sid_f11_fix_50g
# ls -l | grep 0x0dc400
crw-r----- 1 bin sys 188 0x0dc400 Aug 24 11:16 c13t12d4
crw-r--r-- 1 oracle dba 188 0x0dc400 Aug 24 12:36 sid_f11_fix_50
And add this file on both the cluster node and add the file to database using alter database datafile..
Similaraly.. i have many unused raw devices which are not being used in oracle.. I wanted to re-make use of them..
Can any one givs me the commands to clear the raw devies and re-add the raw to db.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-20-2008 01:03 PM
тАО03-20-2008 01:03 PM
Re: Confrim the process of addition and deletion of raw file in db ~
ll /dev/vg*/lv*
This will list all of your logical volumes. Your logical volumes are the 2nd level of data access. Level 1 will be the disk or physical volume. Level 3 will be the file system. Since you have no file system you have no level 3. This is what makes a raw file system. Only a level 2 logical volume. Which can be listed out with the above command.
You'll then want to verify the existence of these lvol'v in /etc/lvmtab.
strings /etc/lvmtab
If the lvols are in /etc/lvmtab then use the lvremove command. If not, then use the 'rm' command on all lvols and rlvols.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-20-2008 01:26 PM
тАО03-20-2008 01:26 PM
Re: Confrim the process of addition and deletion of raw file in db ~
How can i associate logical volumes to LUN in this case : /dev/rdsk/c13t12d4
My admins wil give me LUN numbers in cluster for each node. I assoicate and create the link and make use of them..
I just wanted to clarify the process which am following above..
And
dd if=/dev/zero of= /dev/rdsk/c13t12d4 bs=16384
is the right command to delete contents of raw.. or can I use the softlink name instead.
Thank you
Sreedhar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-20-2008 01:34 PM
тАО03-20-2008 01:34 PM
Re: Confrim the process of addition and deletion of raw file in db ~
Here is the output as per your suggested commands :
# strings /etc/lvmtab
/dev/vg00
/dev/dsk/c2t1d0s2
/dev/dsk/c3t0d0s2
/dev/vgorabkp
/dev/dsk/c13t0d3
/dev/dsk/c13t0d4
/dev/dsk/c13t12d5
/dev/vgu03
F_'W
/dev/dsk/c13t11d4
/dev/vg800
/dev/dsk/c13t14d0
# ls -ltr /dev/dsk/c2t1d0s2
brw-r----- 1 bin sys 31 0x021002 Dec 5 2004 /dev/dsk/c2t1d0s2
# ls -ltr |grep 0x021002
# cd /dev/
# ls -ltr vg*
vg00:
total 0
crw-r----- 1 root sys 64 0x000000 Jan 5 2005 group
brw-r----- 1 root sys 64 0x000005 Jan 5 2005 lvol5
brw-r----- 1 root sys 64 0x000006 Jan 5 2005 lvol6
crw-r----- 1 root sys 64 0x000006 Jan 5 2005 rlvol6
brw-r----- 1 root sys 64 0x000007 Jan 5 2005 lvol7
crw-r----- 1 root sys 64 0x000007 Jan 5 2005 rlvol7
brw-r----- 1 root sys 64 0x000008 Jan 5 2005 lvol8
crw-r----- 1 root sys 64 0x000008 Jan 5 2005 rlvol8
crw-r----- 1 root sys 64 0x000004 Jan 5 2005 rlvol4
crw-r----- 1 root sys 64 0x000005 Jan 5 2005 rlvol5
brw-r----- 1 root sys 64 0x000004 Jan 5 2005 lvol4
brw-r----- 1 root sys 64 0x000001 Jan 5 2005 lvol1
brw-r----- 1 root sys 64 0x000002 Jan 5 2005 lvol2
crw-r----- 1 root sys 64 0x000002 Jan 5 2005 rlvol2
crw-r----- 1 root sys 64 0x000001 Jan 5 2005 rlvol1
brw-r----- 1 root sys 64 0x000003 Jan 5 2005 lvol3
crw-r----- 1 root sys 64 0x000003 Jan 5 2005 rlvol3
br--r----- 1 root sys 64 0x000009 Feb 9 2005 lvol9
cr--r----- 1 root sys 64 0x000009 Feb 9 2005 rlvol9
brw-r----- 1 root sys 64 0x00000a Feb 28 2005 restore
crw-r----- 1 root sys 64 0x00000a Feb 28 2005 rrestore
How can I co-relate with my number raw devices avaliable in /dev/rdsk/*
Thank you
Sreehar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-20-2008 04:03 PM
тАО03-20-2008 04:03 PM
Re: Confrim the process of addition and deletion of raw file in db ~
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-20-2008 06:56 PM
тАО03-20-2008 06:56 PM
Re: Confrim the process of addition and deletion of raw file in db ~
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2008 07:20 AM
тАО03-21-2008 07:20 AM
Re: Confrim the process of addition and deletion of raw file in db ~
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2008 11:11 AM
тАО03-21-2008 11:11 AM
Re: Confrim the process of addition and deletion of raw file in db ~
I donot maintain any of those..
All I do is :
I request size of the luns : For ex If I need to add 100g lun to the database.
Sysadmin will give me /dev/rdsk/c13t12d4
I will use this lun using mknod,major number.
All am verifying the process of addition and deletion of lun/raw.
In case if i need to delete the raw contents and assign the raw disk to another tablespace.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2008 11:51 AM
тАО03-21-2008 11:51 AM
Re: Confrim the process of addition and deletion of raw file in db ~
#ll /dev/rdsk
and please highlight the devices used as raw volumes.