Home » Server Options » RAC & Failsafe » ASM (RHEL4)
ASM [message #454014] Mon, 03 May 2010 08:01 Go to next message
sherkhan@infodynamic.net
Messages: 28
Registered: August 2009
Location: dubai
Junior Member

Dear All,

i have one Oracle RAC server runing from two and half years in noarchive log mode.now need to change to archive log mode.
so the requirment is to keep archive logs on ocfs2. i configured the ocfs2.
now the problem is : how to know which slice means '/dev/sdf1' is the slice should be used for ocfs2.
worry point is : database is runing on asm and i don't know which slice is using by asm.
how i will make sure myself which are using by asm , rest i will configure with ocfs2.
[root@node1 ~]# /etc/init.d/oracleasm listdisks DISK1
DISK1
DISK2
]# fdisk -l

Disk /dev/cciss/c0d0: 146.7 GB, 146778685440 bytes
255 heads, 63 sectors/track, 17844 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/cciss/c0d0p1 * 1 64 514048+ 83 Linux
/dev/cciss/c0d0p2 65 129 522112+ 83 Linux
/dev/cciss/c0d0p3 130 3953 30716280 83 Linux
/dev/cciss/c0d0p4 7637 17844 81995760 5 Extended
/dev/cciss/c0d0p5 7637 11460 30716248+ 83 Linux
/dev/cciss/c0d0p6 11461 13500 16386268+ 83 Linux
/dev/cciss/c0d0p7 13501 14775 10241406 83 Linux
/dev/cciss/c0d0p8 14776 15795 8193118+ 82 Linux swap
/dev/cciss/c0d0p9 15796 16815 8193118+ 83 Linux
/dev/cciss/c0d0p10 16816 17835 8193118+ 83 Linux

Disk /dev/sda: 1073 MB, 1073741824 bytes
34 heads, 61 sectors/track, 1011 cylinders
Units = cylinders of 2074 * 512 = 1061888 bytes

Device Boot Start End Blocks Id System
/dev/sda1 1 120 124409+ 83 Linux

Disk /dev/sdb: 21.4 GB, 21474836480 bytes
64 heads, 32 sectors/track, 20480 cylinders
Units = cylinders of 2048 * 512 = 1048576 bytes

Device Boot Start End Blocks Id System
/dev/sdb1 1 20480 20971504 83 Linux

Disk /dev/sdc: 1073 MB, 1073741824 bytes
34 heads, 61 sectors/track, 1011 cylinders
Units = cylinders of 2074 * 512 = 1061888 bytes

Device Boot Start End Blocks Id System
/dev/sdc1 1 20 20709+ 83 Linux

Disk /dev/sdd: 107.3 GB, 107374182400 bytes
255 heads, 63 sectors/track, 13054 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdd1 1 13054 104856223+ 83 Linux

Disk /dev/sde: 107.3 GB, 107374182400 bytes
255 heads, 63 sectors/track, 13054 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Start End Blocks Id System
/dev/sde1 1 13054 104856223+ 83 Linux

Disk /dev/sdf: 214.7 GB, 214748364800 bytes
255 heads, 63 sectors/track, 26108 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdf1 1 12159 97667136 83 Linux
/dev/sdf2 12160 26108 112045342+ 83 Linux

the os guy added the space to servers and now i have to configure ocfs2 partition so i need to know which slice i can use. because its very critical .

thanks in advance.
Re: ASM [message #454021 is a reply to message #454014] Mon, 03 May 2010 09:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>database is runing on asm and i don't know which slice is using by asm
In ASM instance, v$asm_disk.path will provide the slice.
SQL> select path from v$asm_disk;

PATH
--------------------------------------------------------------------------------
/dev/rdsk/emcpower0b
/dev/rdsk/emcpower1b
/dev/rdsk/emcpower2b
/dev/rdsk/emcpower3b
/dev/rdsk/emcpower4b
/dev/rdsk/emcpower5b
/dev/rdsk/emcpower6b

With other ASM v$views, you can exactly map it with asm diskgroups etc.

Re: ASM [message #454237 is a reply to message #454021] Tue, 04 May 2010 09:31 Go to previous messageGo to next message
sherkhan@infodynamic.net
Messages: 28
Registered: August 2009
Location: dubai
Junior Member

thanks for the reply

i queried the same as guide me.

SQL> select path from v$asm_disk;

PATH
--------------------------------------------------------------------------------
ORCL:DISK1
ORCL:DISK2



but its its different from operating system slice.
like /dev/sdb1/.....etc.

how i will know its used which one.

thanks,
sher khan
Re: ASM [message #454239 is a reply to message #454237] Tue, 04 May 2010 09:52 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Okay then check label, name

SQL> desc v$asm_disk
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP_NUMBER                                       NUMBER
 DISK_NUMBER                                        NUMBER
 COMPOUND_INDEX                                     NUMBER
 INCARNATION                                        NUMBER
 MOUNT_STATUS                                       VARCHAR2(7)
 HEADER_STATUS                                      VARCHAR2(12)
 MODE_STATUS                                        VARCHAR2(7)
 STATE                                              VARCHAR2(8)
 REDUNDANCY                                         VARCHAR2(7)
 LIBRARY                                            VARCHAR2(64)
 TOTAL_MB                                           NUMBER
 FREE_MB                                            NUMBER
 NAME                                               VARCHAR2(30)
 FAILGROUP                                          VARCHAR2(30)
 LABEL                                              VARCHAR2(31)
 PATH                                               VARCHAR2(256)
 UDID                                               VARCHAR2(64)
 PRODUCT                                            VARCHAR2(32)
 CREATE_DATE                                        DATE
 MOUNT_DATE                                         DATE
 REPAIR_TIMER                                       NUMBER
 READS                                              NUMBER
 WRITES                                             NUMBER
 READ_ERRS                                          NUMBER
 WRITE_ERRS                                         NUMBER
 READ_TIME                                          NUMBER
 WRITE_TIME                                         NUMBER
 BYTES_READ                                         NUMBER
 BYTES_WRITTEN                                      NUMBER


Babu
Re: ASM [message #454286 is a reply to message #454239] Tue, 04 May 2010 23:57 Go to previous message
sherkhan@infodynamic.net
Messages: 28
Registered: August 2009
Location: dubai
Junior Member

thanks Babu for the update but its giving the same result.

SQL> select label from v$asm_disk;

LABEL
-------------------------------
DISK1
DISK2


thanks,
sher khan
Previous Topic: A clarification in RAC
Next Topic: crs-0184 cannot communicate with CRS deamon
Goto Forum:
  


Current Time: Fri Dec 19 20:26:06 CST 2014

Total time taken to generate the page: 0.14208 seconds