Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

5

主题
1#
发表于 2014-7-1 16:41:50 | 查看: 4608| 回复: 2
本帖最后由 xychong123 于 2014-7-1 16:43 编辑

asm 磁盘路径名称变更(由./dev/rhdisk* 变更成为/dev/rhdiskdpd*)?
在grid不做任何修改可以正常启动。
gpnp profile:DiscoveryString内容为空,那么grid在启动时候怎么确定votedisk磁盘位置的呢?



crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.1.0]

1,没有使用多路径软件,单条路径
lspv
hdisk1 00c326c248aee442 rootvg active
hdisk0 none None
hdisk2 none None
hdisk3 none None
hdisk4 none None
hdisk5 none None
hdisk6 none None
hdisk7 none None        
p520b:/home/grid$asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 40960 40337 0 40337 0 N CRS/
MOUNTED EXTERN N 512 4096 1048576 102400 99931 0 99931 0 N DATA/
ASMCMD> lsdsk -G crs
Path
/dev/rhdisk2
/dev/rhdisk3
/dev/rhdisk4
/dev/rhdisk5
ASMCMD> lsdsk -G data
Path
/dev/rhdisk6
/dev/rhdisk7
ASMCMD> exit
p520b:/home/grid$crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 711fde562d314ff3bf948fbaf20c38f0 (/dev/rhdisk2) [CRS]
Located 1 voting disk(s).
p520b:/home/grid$kfod disk=all
--------------------------------------------------------------------------------
Disk Size Path User Group
================================================================================
1: 10240 Mb /dev/rhdisk0 grid dba
2: 10240 Mb /dev/rhdisk2 grid dba
3: 10240 Mb /dev/rhdisk3 grid dba
4: 10240 Mb /dev/rhdisk4 grid dba
5: 51200 Mb /dev/rhdisk5 grid dba
6: 51200 Mb /dev/rhdisk6 grid dba
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME
================================================================================
+ASM1 /u01/grid/asm


2,多路径聚合之后:hdiskdpd为聚合之后的磁盘。
p520b:/home/grid$lspv
hdisk1 00c326c248aee442 rootvg active
hdisk0 none None
hdisk2 none None
hdisk3 none None
hdisk4 none None
hdisk5 none None
hdisk6 none None
hdisk7 none None
hdisk8 none None
hdisk9 none None
hdisk10 none None
hdisk11 none None
hdisk12 none None
hdisk13 none None
hdiskdpdctrl none None
hdiskdpd0 none None
hdiskdpd1 none None
hdiskdpd2 none None
hdiskdpd3 none None
hdiskdpd4 none None
hdiskdpd5 none None


p520b:/home/grid$asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 40960 40337 0 40337 0 N CRS/
MOUNTED EXTERN N 512 4096 1048576 102400 99931 0 99931 0 N DATA/
ASMCMD> lsdsk -G crs
Path
/dev/rhdiskdpd0
/dev/rhdiskdpd1
/dev/rhdiskdpd2
/dev/rhdiskdpd3
ASMCMD> lsdsk -G data
Path
/dev/rhdiskdpd4
/dev/rhdiskdpd5
ASMCMD> exit
p520b:/home/grid$crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 711fde562d314ff3bf948fbaf20c38f0 (/dev/rhdiskdpd0) [CRS]
Located 1 voting disk(s).
p520b:/home/grid$kfod disk=all
--------------------------------------------------------------------------------
Disk Size Path User Group
================================================================================
1: 10240 Mb /dev/rhdiskdpd0 grid dba
2: 10240 Mb /dev/rhdiskdpd1 grid dba
3: 10240 Mb /dev/rhdiskdpd2 grid dba
4: 10240 Mb /dev/rhdiskdpd3 grid dba
5: 51200 Mb /dev/rhdiskdpd4 grid dba
6: 51200 Mb /dev/rhdiskdpd5 grid dba
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME
================================================================================
+ASM1 /u01/grid/asm

3,
gpnp profile:DiscoveryString内容为空,那么asm启动的时候去哪寻找磁盘?

<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="9" ClusterUId="8281f6e48f6aef12ffedab1b80064077" ClusterName="p520b-cluster" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" IP="192.168.1.0" Adapter="en0" Use="public"/><gpnp:Network id="net2" IP="192.168.2.0" Adapter="en1" Use="cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile>

<orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="" SPFile="+CRS/p520b-cluster/asmparameterfile/registry.253.850134431"/>

<ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>iPNNnIxLiD60C0rzvpSeO0GG5HU=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>j5D0Iwdjhf0N3Tv2fInlanSu/MZe6f3lrE2uOeidLW512b9yGYwB1I8D/9oLUAtEFMzkERF6RPH/+fhFUmPXk3KImyibnF9ASWkDZVdwyRvoZ3GWW9JGw9i88S7BmMC94QspxXBSI7Hy+LVR/t+b02gdtaEhD0nxT4SUtZcwpCg=</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>
2#
发表于 2014-7-3 20:54:41
gpnp profile:DiscoveryString内容为空,那么asm启动的时候去哪寻找磁盘?

没有测试,但应当是默认的地方, 所谓默认的地方 例如linux上的/dev/raw和asmlib的orcl

回复 只看该作者 道具 举报

3#
发表于 2014-7-3 21:02:02
那么grid在启动时候怎么确定votedisk磁盘位置的呢?


这个 我们需要了解一些底层 数据结构, 还要用到kfed


[oracle@mlab2 ~]$ kfed read /oracleasm/asm-disk01|grep kfdhdb.vf

kfdhdb.vfstart:                     128 ; 0x0ec: 0x00000080 <<<< Starting allocation unit of voting file
kfdhdb.vfend:                       160 ; 0x0f0: 0x000000a0 <<<< Ending allocation unit of voting fille

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-21 06:38 , Processed in 0.050822 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569