Oracle 10 with RAC MPXIO and ASM installation on Solaris 10 By AkH, 2 years, 11 months ago, modified Nov. 23. Oracle database is fairly simple to install. 沩妳而戰 发表在《在Linux 6上使用UDEV解决RAC ASM 存储设备名问题》 如何分析解读systemstat dump产生的trc文件 - IT大道 发表在《[转]如何阅读systemstate dump》. 该日志由 annuity 于3年前发表在综合分类下,最后更新于 2012年12月22日. 转载请注明: How to cleanup ASM installation (RAC and Non-RAC) [ID 311350.1] | 学步. Note: If you are installing Oracle Clusterware on a server that already has a single-instance Oracle Database 10g installation, then stop the existing ASM instances. RAC, ASM & Clusterware Installation - UTL_FILE_DIR and Oracle RAC RAC, ASM & Clusterware Installation Oracle Database RAC, ASM & Clusterware Installation. R2 RAC ASM启动揭秘1. 1g. R2 RAC中ocr和votedisk终于可以存放在ASM中了, 这避免了1. RAC的关键点划分裸设备的窘境, 随之 1. R2 中ASM的spfile也可以存放到ASM diskgroup中以实现多节点ASM的共享管理了。这听上去似乎有些不可思议,照常理来说 ASM实例启动并mount diskgroup后才能够访问diskgroup上的文件, 但是ASM实例只有获得ASM spfile后才能够启动实例,这2者形成了死循环。有同学在T. ASM启动的疑问:hello maclean,查看spfile位置ASMCMD> spget+CRSDG/rac/asmparameterfile/registry. ASM 也算是一种ORACLE instance,自动的系统参数文件在自己的diskgroup,我的问题是它是如何启动从自身未启动的磁盘组读的参数文件?thanks.!我们来解释这个问题:从1. Oracle Cluterware标示voting disk files的方法较之前的版本1. OCR中, 但是因为从1. 1. 2开始ocr和votedisk可以存放在ASM了 , 所以自1. GPNP profile中的CSS voting file discovery string来定位。CSS voting disk file的discovery string将指向ASM,所以它要使用ASM discovery string的值。 如以下的例子使用udev绑定设备名作为ASM使用的LUN, 这些udev获得的设备形式如/dev/rasm- disk* , 我们利用gpnptool get命令获得gpnp profile: [grid@maclean. Warning: some command line parameters were defaulted. Resulting command line. UTF- 8"?> < gpnp: GPn. P- Profile Version="1. XMLSchema- instance". Location="http: //www. Profile. Sequence="9" Cluster. UId="4. 52. 18. 5be. Cluster. Name="maclean- cluster" PALocation=""> < gpnp: Network- Profile> < gpnp: Host. Network id="gen". Host. Name="*"> < gpnp: Network id="net. IP="1. 92. 1. 68. Adapter="eth. 0". Use="public"/> < gpnp: Network id="net. IP="1. 72. 1. 68. Adapter="eth. 1". Use="cluster_interconnect"/> < /gpnp: Host. Network> < /gpnp: Network- Profile> <. CSS- Profile id="css" Discovery. String="+asm" Lease. Duration="4. 00"/> < orcl: ASM- Profile id="asm" Discovery. String="/dev/rasm*" SPFile="+SYSTEMDG/maclean- cluster/asmparameterfile/registry. Signature xmlns: ds="http: //www. Signed. Info> < ds: Canonicalization. Method Algorithm="http: //www. Signature. Method Algorithm="http: //www. Reference URI=""> < ds: Transforms> < ds: Transform Algorithm="http: //www. Transform Algorithm="http: //www. Inclusive. Namespaces. Prefix. List="gpnp orcl xsi"/> < /ds: Transform> < /ds: Transforms> <. Digest. Method Algorithm="http: //www. Digest. Value> L1. SLg. 10. Aq. GEau. CQ4ne. 9quuc. ITZA=< /ds: Digest. Value> <. /ds: Reference> < /ds: Signed. Info> < ds: Signature. Value> r. Ty. Zm. QCMuian. 6isn. ATh. Ums. V4x. Po. K2fte. Mc. 1l. 0GIv. Rv. Hnc. Mw. LQz. PM/Qr. XCGGTCEvgv. Xz. UPEKzmd. X2oy. 5v. Lczt. N6. UHr. 6AJt. A2. JYYodmrs. Fw. Ey. VBQ1. D6w. H+HQi. Oe. 2SG9. Uzd. Qn. Nt. WSbj. D4jf. Zke. QWy. MPf. Wd. Km. 07. 1Ek. 0Rfb. E=< /ds: Signature. Value> < /ds: Signature> < /gpnp: GPn. P- Profile>. Success.其中重要的2条记录:< orcl: CSS- Profile id=”css” Discovery. String=”+asm” Lease. Duration=”4. 00″/> ==》css voting disk指向+ASM< orcl: ASM- Profile id=”asm” Discovery. String=”/dev/rasm*” SPFile=”+SYSTEMDG/maclean- cluster/asmparameterfile/registry. ASM的Discovery. String=”/dev/rasm*”,即ASM实例启动时会去寻找的设备路径,SPFILE记录了ASM Parameter FILE的ALIAS但是请注意虽然GPNP记录了ASM Parameter FILE的ALIAS,但这不代表ASM直接能访问到该SPFILE,在实际Diskgroup被Mount之前光知道一个ASM ALIAS是没有用的。我们来看一下+SYSTEMDG/maclean- cluster/asmparameterfile/registry. SPFILE在ASM中所处的位置: [grid@maclean. SQL*Plus: Release 1. Production on Tue Jul 1. Copyright (c) 1. 98. Oracle. All rights reserved. Oracle Database 1. Enterprise Edition Release 1. Production. With the Real Application Clusters and Automatic Storage Management options. FILE NAME" format a. NAME "FILE NAME". AU_KFFXP "AU NUMBER". NUMBER_KFFXP "FILE NUMBER". DISK_KFFXP "DISK NUMBER". GROUP_KFFXP = GROUP_NUMBER. NUMBER_KFFXP = FILE_NUMBER. REGISTRY. 2. 53. 7. DISK_KFFXP,AU_KFFXP. FILE NAME AU NUMBER FILE NUMBER DISK NUMBER. REGISTRY. 2. 53. 7. REGISTRY. 2. 53. 7. REGISTRY. 2. 53. 7. SQL> col path for a. SQL> select disk_number,path from v$asm_disk where disk_number in (1,3,4) and GROUP_NUMBER=3. DISK_NUMBER PATH. ASM SPFILE共有三份镜像(redundancy=high),分别保留在 /dev/rasm- diskc的AU=3. AU=3. 5、/dev/rasm- diskf AU=3. ASM DISK的header: [grid@maclean. ASM disk header的kfdhdb. ASM SPFILE在这个DISK上的AU NUMBER即其位置, ASM实例在启动时只需要通过GPNP PROFILE中的 Discovery. String找到合适的设备路径,并读取其ASM disk header即可以找到kfdhdb. MOUNT DISKGROUP的情况下读取ASM SPFILE,并成功启动ASM, 这也就解决了鸡生蛋、蛋生鸡的难题。扫码关注db.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
September 2016
Categories |