使用crs profile管理RAC资源配置文件

悠悠 2022-03-19 18:26 286阅读 0赞

profile通常指配置文件，crs\_profile望文生义可知，就是管理集群的配置文件。在Oraclele RAC中，所有的CRS资源存放在OCR磁盘中，对于OCR更形象的比喻是类似于Windows的注册表。我们知道Windows注册表由类似树状的节点构成，其形式是KEY-VALUE，集群中的资源也是如此。Windows注册表可以整个导出，分支导出，也可以导入注册表信息。针对集群资源的管理crs\_profile结合crs\_register与crs\_unregisterd等同于一个类似于Windows的regedit 管理工具。这么说就不陌生了吧，接着往下看。

一、crs\_profile的帮助信息  
对于Oracle clusterware大部分集群命令行工具而言，都提供丰富的操作指导。命令行下直接输入crs\_profile将给出帮助信息  
[oracle@bo2dbp][oracle_bo2dbp]:~> crs\_profile  
Usage: crs\_profile -create resource\_name -t application  
\[-dir directory\_path\] \[-a action\_script\] \[-B binary\_pathname\]  
\[-d description\] \[-h hosting\_members\] \[-r required\_resources\]  
\[-l optional\_resources\] \[-p placement\_policy\]  
\[-o as=auto\_start,ci=check\_interval,ft=failure\_threshold,  
fi=failure\_interval,ra=restart\_attempts,fd=failover\_delay,  
st=script\_timeout,ap=active\_placement,bt=rebalance,  
ut=uptime\_threshold,rt=start\_timeout,pt=stop\_timeout\] \[-f\] \[-q\]

crs\_profile -create resource\_name -I template\_file \[-dir directory\_path\] \[-f\] \[-q\]

crs\_profile -delete resource\_name \[-dir directory\_path\] \[-q\]

crs\_profile -print \[resource\_name \[...\]\] \[-dir directory\_path\] \[-q\]

crs\_profile -template resource\_name \[-dir directory\_path\] \[-O template\_file\]

crs\_profile -template -t application \[-O template\_file\]

crs\_profile -update resource\_name \[-dir directory\_path\] \[option ...\] \[-o option,...\] \[-q\]

crs\_profile -validate resource\_name \[-dir directory\_path\] \[-q\]

二、使用crs\_profile操作集群资源

1、查看当前集群中的资源#使用crs_stat查看集群中含srv的配置信息oracle@bo2dbp:~> crs_stat -p | grep srvNAME=ora.GOBO4.GOBO4_SRV.GOBO4A.srvNAME=ora.ora10g.hr_ora10g.ora10g1.srvDESCRIPTION=ora.ora10g.hr_ora10g.ora10g1.srv#使用crs_stat查看集群的service服务当前处于online状态oracle@bo2dbp:~> crs_stat -t | grep srvora....O4A.srv application    ONLINE    ONLINE    bo2dbp      ora....0g1.srv application    ONLINE    ONLINE    bo2dbp  2、使用crs_profile导出指定的集群资源信息到文件        oracle@bo2dbp:~> crs_profile -create ora.ora10g.hr_ora10g.ora10g1.srv -t application #导出到缺省路径oracle@bo2dbp:~> crs_profile -create ora.ora10g.hr_ora10g.ora10g1.srv -t application -dir /users/oracle #导出到指定路径oracle@bo2dbp:~> ls -hltr ora.ora10g.hr_ora10g.ora10g1.srv*-rw-r--r-- 1 oracle oinstall 820 2012-11-07 17:34 ora.ora10g.hr_ora10g.ora10g1.srv.caporacle@bo2dbp:~> ls -hltr $ORA_CRS_HOME/crs/public/ora.ora10g.hr_ora10g.ora10g1.srv*  #此处是缺省路径-rw-r--r-- 1 oracle oinstall 833 2012-11-07 17:29 /u01/oracle/crs/crs/public/ora.ora10g.hr_ora10g.ora10g1.srv.cap3、 查看已导出的资源配置文件的信息oracle@bo2dbp:~> crs_profile -print ora.ora10g.hr_ora10g.ora10g1.srv #未指定路径的时候print缺省路径的内容NAME=ora.ora10g.hr_ora10g.ora10g1.srvTYPE=applicationACTION_SCRIPT=/u01/oracle/crs/crs/public/ora.ora10g.hr_ora10g.ora10g1.srv.scrACTIVE_PLACEMENT=0AUTO_START=restoreCHECK_INTERVAL=60DESCRIPTION=ora.ora10g.hr_ora10g.ora10g1.srvFAILOVER_DELAY=0FAILURE_INTERVAL=0FAILURE_THRESHOLD=0HOSTING_MEMBERS=OPTIONAL_RESOURCES=PLACEMENT=balancedREQUIRED_RESOURCES=RESTART_ATTEMPTS=1SCRIPT_TIMEOUT=60START_TIMEOUT=0STOP_TIMEOUT=0UPTIME_THRESHOLD=7dUSR_ORA_ALERT_NAME=USR_ORA_CHECK_TIMEOUT=0USR_ORA_CONNECT_STR=/ as sysdbaUSR_ORA_DEBUG=0USR_ORA_DISCONNECT=falseUSR_ORA_FLAGS=USR_ORA_IF=USR_ORA_INST_NOT_SHUTDOWN=USR_ORA_LANG=USR_ORA_NETMASK=USR_ORA_OPEN_MODE=USR_ORA_OPI=falseUSR_ORA_PFILE=USR_ORA_PRECONNECT=noneUSR_ORA_SRV=USR_ORA_START_TIMEOUT=0USR_ORA_STOP_MODE=immediateUSR_ORA_STOP_TIMEOUT=0USR_ORA_VIP=4、资源配置文件中常用子项说明 参数名称     说明                    参数指令（以create为例） --------------    -----------------             -------------------------- NAME               资源名称                   crs_profile –create resource_name  TYPE               资源类型(application, generic)      crs_profile –create resource_name –t …  ACTION_SCRIPT      用来管理HA方案脚本           crs_profile –create resource_name –a …  ACTIVE_PLACEMENT   资源贮存的位置/节点           crs_profile –create resource_name –o –ap …  AUTO_START         资源自启动               crs_profile –create resource_name –o –as …  CHECK_INTERVAL     资源监控间隔              crs_profile –create resource_name –o –ci …  FAILOVER_DELAY     资源failover的等待时间         crs_profile –create resource_name –o –fd …  FAILURE_INTERVAL   资源重启尝试间隔            crs_profile –create resource_name –o –fi …  FAILURE_THRESHOLD  资源重启尝试次数(最大20次)       crs_profile –create resource_name –o –ft …  HOSTING_MEMBERS    资源启动或者failover的首要节点选择   crs_profile –create resource_name –h …  PLACEMENT          资源启动或者failover的节点选择模式   crs_profile –create resource_name -p  REQUIRED_RESOURCES 当前资源所依赖的资源         crs_profile –create resource_name -r  RESTART_ATTEMPTS   资源重配置之前的尝试启动次数     crs_profile –create resource_name –o –ra …  SCRIPT_TIMEOUT     等待ACTION_SCRIPT的结果返回时间    crs_profile –create resource_name –o –st …  USR_ORA_VIP        Vip地址     crs_profile –create vip_name -t application –a $ORA_CRS_HOME/bin/uservip –o oi=…,ov=…,on=…5、删除已导出的资源配置文件oracle@bo2dbp:~> crs_profile -delete ora.ora10g.hr_ora10g.ora10g1.srv -dir /users/oracleoracle@bo2dbp:~> crs_profile -print ora.ora10g.hr_ora10g.ora10g1.srv -dir /users/oracle #再次查看时提示配置文件不存在CRS-0181: Cannot access the resource profile 'ora.ora10g.hr_ora10g.ora10g1.srv'.6、更新资源配置文件中的项oracle@bo2dbp:~> crs_profile -update ora.ora10g.hr_ora10g.ora10g1.srv -o as=never  #此处更新资源配置文件中的AUTO_START项oracle@bo2dbp:~> crs_profile -print ora.ora10g.hr_ora10g.ora10g1.srvNAME=ora.ora10g.hr_ora10g.ora10g1.srvTYPE=applicationACTION_SCRIPT=/u01/oracle/crs/crs/public/ora.ora10g.hr_ora10g.ora10g1.srv.scrACTIVE_PLACEMENT=0AUTO_START=never  #此时，此项已经由原来的restore变成neverCHECK_INTERVAL=60DESCRIPTION=ora.ora10g.hr_ora10g.ora10g1.srvFAILOVER_DELAY=0FAILURE_INTERVAL=0FAILURE_THRESHOLD=0HOSTING_MEMBERS=OPTIONAL_RESOURCES=PLACEMENT=balancedREQUIRED_RESOURCES=RESTART_ATTEMPTS=1SCRIPT_TIMEOUT=60START_TIMEOUT=0STOP_TIMEOUT=0UPTIME_THRESHOLD=7dUSR_ORA_ALERT_NAME=USR_ORA_CHECK_TIMEOUT=0USR_ORA_CONNECT_STR=/ as sysdbaUSR_ORA_DEBUG=0USR_ORA_DISCONNECT=falseUSR_ORA_FLAGS=USR_ORA_IF=USR_ORA_INST_NOT_SHUTDOWN=USR_ORA_LANG=USR_ORA_NETMASK=USR_ORA_OPEN_MODE=USR_ORA_OPI=falseUSR_ORA_PFILE=USR_ORA_PRECONNECT=noneUSR_ORA_SRV=USR_ORA_START_TIMEOUT=0USR_ORA_STOP_MODE=immediateUSR_ORA_STOP_TIMEOUT=0USR_ORA_VIP=#AUTO_START的值也可以用0,1,2来表示，其中0 等同always， 1 等同restore， 2 等同never 7、验证资源配置文件的正确性oracle@bo2dbp:~> crs_profile -validate ora.ora10g.hr_ora10g.ora10g1.srv#下面尝试将AUTO_START项值改为3oracle@bo2dbp:~> vi $ORA_CRS_HOME/crs/public/ora.ora10g.hr_ora10g.ora10g1.srv.caporacle@bo2dbp:~> crs_profile -print ora.ora10g.hr_ora10g.ora10g1.srv | grep AUTO_STARTAUTO_START=3#下面验证的时候产生了错误oracle@bo2dbp:~> crs_profile -validate ora.ora10g.hr_ora10g.ora10g1.srv  Error: AUTO_START invalid: 3 CRS-0180: Resource '/u01/oracle/crs/crs/public/ora.ora10g.hr_ora10g.ora10g1.srv.cap' validation failed.#再次使用update参数更新配置文件oracle@bo2dbp:~> crs_profile -update ora.ora10g.hr_ora10g.ora10g1.srv -o as=1oracle@bo2dbp:~> crs_profile -print ora.ora10g.hr_ora10g.ora10g1.srv | grep AUTO_STARTAUTO_START=1oracle@bo2dbp:~> crs_profile -validate ora.ora10g.hr_ora10g.ora10g1.srv  #此处验证成功8、导出资源配置模板#下面导出指定资源模板oracle@bo2dbp:~> crs_profile -template ora.ora10g.hr_ora10g.ora10g1.srvoracle@bo2dbp:~> ls -hltr *temp*-rw-r--r-- 1 oracle oinstall 700 2012-11-07 18:27 template.cap#可以看到下面的模板配置文件中包含了指定资源所需的所有子项，有些子项不需要的则其值为空oracle@bo2dbp:~> more template.capNAME=TYPE=applicationACTION_SCRIPT=ACTIVE_PLACEMENT=0AUTO_START=1CHECK_INTERVAL=60DESCRIPTION=FAILOVER_DELAY=0FAILURE_INTERVAL=0FAILURE_THRESHOLD=0HOSTING_MEMBERS=OPTIONAL_RESOURCES=PLACEMENT=balancedREQUIRED_RESOURCES=RESTART_ATTEMPTS=1SCRIPT_TIMEOUT=60START_TIMEOUT=0STOP_TIMEOUT=0UPTIME_THRESHOLD=7dUSR_ORA_ALERT_NAME=USR_ORA_CHECK_TIMEOUT=0USR_ORA_CONNECT_STR=/ as sysdbaUSR_ORA_DEBUG=0USR_ORA_DISCONNECT=falseUSR_ORA_FLAGS=USR_ORA_IF=USR_ORA_INST_NOT_SHUTDOWN=USR_ORA_LANG=USR_ORA_NETMASK=USR_ORA_OPEN_MODE=USR_ORA_OPI=falseUSR_ORA_PFILE=USR_ORA_PRECONNECT=noneUSR_ORA_SRV=USR_ORA_START_TIMEOUT=0USR_ORA_STOP_MODE=immediateUSR_ORA_STOP_TIMEOUT=0USR_ORA_VIP=#导出所有application的资源配置通用模板oracle@bo2dbp:~> crs_profile -template -t application -O tmplate.caporacle@bo2dbp:~> ls -hltr *.cap-rw-r--r-- 1 oracle oinstall 700 2012-11-07 18:27 template.cap-rw-r--r-- 1 oracle oinstall 706 2012-11-07 18:32 tmplate.cap#Author : Robinson#Blog   : http://blog.csdn.net/robinson_0612

三、总结  
crs\_profile是用于管理OCR配置文件中资源的工具，可以对application等资源进行导出以实现备份，以及导出后进行更新，查看等。  
对于其更新之后的新的配置文件可以使用crs\_register工具将其注册到OCR。

四、更多参考

有关Oracle RAC请参考  
[使用crs\_setperm修改RAC资源的所有者及权限  
][crs_setperm_RAC_] [使用crs\_profile管理RAC资源配置文件  
][crs_profile_RAC_] [RAC 数据库的启动与关闭  
][RAC _] [再说 Oracle RAC services  
][Oracle RAC services] [Services in Oracle Database 10g  
][Services in Oracle Database 10g] [Migrate datbase from single instance to Oracle RAC  
][Migrate datbase from single instance to Oracle RAC] [Oracle RAC 连接到指定实例  
][Oracle RAC _] [Oracle RAC 负载均衡测试(结合服务器端与客户端)  
][Oracle RAC _ 1] [Oracle RAC 服务器端连接负载均衡(Load Balance)  
][Oracle RAC _Load Balance_] [Oracle RAC 客户端连接负载均衡(Load Balance)  
][Oracle RAC _Load Balance_ 1] [ORACLE RAC 下非缺省端口监听配置(listener.ora tnsnames.ora)][ORACLE RAC _listener.ora tnsnames.ora]  
[ORACLE RAC 监听配置 (listener.ora tnsnames.ora)  
][ORACLE RAC _ _listener.ora tnsnames.ora_] [配置 RAC 负载均衡与故障转移  
][RAC _ 1] [CRS-1006 , CRS-0215 故障一例][CRS-1006 _ CRS-0215]  
[基于Linux (RHEL 5.5) 安装Oracle 10g RAC][Linux _RHEL 5.5_ _Oracle 10g RAC]  
[使用 runcluvfy 校验Oracle RAC安装环境][runcluvfy _Oracle RAC]

有关Oracle 网络配置相关基础以及概念性的问题请参考：  
[配置非默认端口的动态服务注册][Link 1]  
[配置sqlnet.ora限制IP访问Oracle  
][sqlnet.ora_IP_Oracle] [Oracle 监听器日志配置与管理][Oracle]  
[设置 Oracle 监听器密码(LISTENER)  
][Oracle _LISTENER_] [配置ORACLE 客户端连接到数据库][ORACLE]

有关基于用户管理的备份和备份恢复的概念请参考  
[Oracle 冷备份  
][Oracle _] [Oracle 热备份  
][Oracle _ 1] [Oracle 备份恢复概念  
][Oracle _ 2] [Oracle 实例恢复  
][Oracle _ 3] [Oracle 基于用户管理恢复的处理  
][Oracle _ 4] [SYSTEM 表空间管理及备份恢复  
][SYSTEM _] [SYSAUX表空间管理及恢复  
][SYSAUX_] [Oracle 基于备份控制文件的恢复(unsing backup controlfile)][Oracle _unsing backup controlfile]

有关RMAN的备份恢复与管理请参考  
[RMAN 概述及其体系结构  
][RMAN _] [RMAN 配置、监控与管理  
][RMAN _ 1] [RMAN 备份详解  
][RMAN _ 2] [RMAN 还原与恢复  
][RMAN _ 3] [RMAN catalog 的创建和使用  
][RMAN catalog _] [基于catalog 创建RMAN存储脚本  
][catalog _RMAN_] [基于catalog 的RMAN 备份与恢复  
][catalog _RMAN _] [RMAN 备份路径困惑  
][RMAN _ 4] [使用RMAN实现异机备份恢复(WIN平台)  
][RMAN_WIN_] [使用RMAN迁移文件系统数据库到ASM  
][RMAN_ASM] [linux 下RMAN备份shell脚本  
][linux _RMAN_shell_] [使用RMAN迁移数据库到异机][RMAN]

有关ORACLE体系结构请参考  
[Oracle 表空间与数据文件  
][Oracle _ 5] [Oracle 密码文件  
][Oracle _ 6] [Oracle 参数文件  
][Oracle _ 7] [Oracle 联机重做日志文件(ONLINE LOG FILE)  
][Oracle _ONLINE LOG FILE_] [Oracle 控制文件(CONTROLFILE)  
][Oracle _CONTROLFILE_] [Oracle 归档日志  
][Oracle _ 8] [Oracle 回滚(ROLLBACK)和撤销(UNDO)  
][Oracle _ROLLBACK_UNDO_] [Oracle 数据库实例启动关闭过程  
][Oracle _ 9] [Oracle 10g SGA 的自动化管理  
][Oracle 10g SGA _] [Oracle 实例和Oracle数据库(Oracle体系结构)][Oracle _Oracle_Oracle]

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！[https://blog.csdn.net/jiangjunshow][https_blog.csdn.net_jiangjunshow]

[oracle_bo2dbp]: mailto:oracle@bo2dbp
[crs_setperm_RAC_]: http://blog.csdn.net/robinson_0612/article/details/8219242
[crs_profile_RAC_]: http://blog.csdn.net/robinson_0612/article/details/8192571
[RAC _]: http://blog.csdn.net/robinson_0612/article/details/8129506
[Oracle RAC services]: http://blog.csdn.net/robinson_0612/article/details/8124232
[Services in Oracle Database 10g]: http://blog.csdn.net/robinson_0612/article/details/8089812
[Migrate datbase from single instance to Oracle RAC]: http://blog.csdn.net/robinson_0612/article/details/8090095
[Oracle RAC _]: http://blog.csdn.net/robinson_0612/article/details/8073620
[Oracle RAC _ 1]: http://blog.csdn.net/robinson_0612/article/details/8072367
[Oracle RAC _Load Balance_]: http://blog.csdn.net/robinson_0612/article/details/8064599
[Oracle RAC _Load Balance_ 1]: http://blog.csdn.net/robinson_0612/article/details/8060634
[ORACLE RAC _listener.ora tnsnames.ora]: http://blog.csdn.net/robinson_0612/article/details/8053007
[ORACLE RAC _ _listener.ora tnsnames.ora_]: http://blog.csdn.net/robinson_0612/article/details/8020800
[RAC _ 1]: http://blog.csdn.net/robinson_0612/article/details/6791667
[CRS-1006 _ CRS-0215]: http://blog.csdn.net/robinson_0612/article/details/7926241
[Linux _RHEL 5.5_ _Oracle 10g RAC]: http://blog.csdn.net/robinson_0612/article/details/7906282
[runcluvfy _Oracle RAC]: http://blog.csdn.net/robinson_0612/article/details/6533094
[Link 1]: http://blog.csdn.net/robinson_0612/article/details/5925526
[sqlnet.ora_IP_Oracle]: http://blog.csdn.net/robinson_0612/article/details/6629141
[Oracle]: http://blog.csdn.net/robinson_0612/article/details/6629043
[Oracle _LISTENER_]: http://blog.csdn.net/robinson_0612/article/details/6629249
[ORACLE]: http://blog.csdn.net/robinson_0612/article/details/5917103
[Oracle _]: http://blog.csdn.net/robinson_0612/article/details/5791597
[Oracle _ 1]: http://blog.csdn.net/robinson_0612/article/details/5816012
[Oracle _ 2]: http://blog.csdn.net/robinson_0612/article/details/5791585
[Oracle _ 3]: http://blog.csdn.net/robinson_0612/article/details/5768233
[Oracle _ 4]: http://blog.csdn.net/robinson_0612/article/details/6041217
[SYSTEM _]: http://blog.csdn.net/robinson_0612/article/details/6041207
[SYSAUX_]: http://blog.csdn.net/robinson_0612/article/details/5810732
[Oracle _unsing backup controlfile]: http://blog.csdn.net/robinson_0612/article/details/7962187
[RMAN _]: http://blog.csdn.net/robinson_0612/article/details/6032525
[RMAN _ 1]: http://blog.csdn.net/robinson_0612/article/details/6032597
[RMAN _ 2]: http://blog.csdn.net/robinson_0612/article/details/6032739
[RMAN _ 3]: http://blog.csdn.net/robinson_0612/article/details/6041247
[RMAN catalog _]: http://blog.csdn.net/robinson_0612/article/details/6043649
[catalog _RMAN_]: http://blog.csdn.net/robinson_0612/article/details/6073020
[catalog _RMAN _]: http://blog.csdn.net/robinson_0612/article/details/6073069
[RMAN _ 4]: http://blog.csdn.net/robinson_0612/article/details/6414338
[RMAN_WIN_]: http://blog.csdn.net/robinson_0612/article/details/6639064
[RMAN_ASM]: http://blog.csdn.net/robinson_0612/article/details/6453954
[linux _RMAN_shell_]: http://blog.csdn.net/robinson_0612/article/details/8029245
[RMAN]: http://blog.csdn.net/robinson_0612/article/details/8076841
[Oracle _ 5]: http://blog.csdn.net/robinson_0612/article/details/5611738
[Oracle _ 6]: http://blog.csdn.net/robinson_0612/article/details/5611672
[Oracle _ 7]: http://blog.csdn.net/robinson_0612/article/details/5559174
[Oracle _ONLINE LOG FILE_]: http://blog.csdn.net/robinson_0612/article/details/5749556
[Oracle _CONTROLFILE_]: http://blog.csdn.net/robinson_0612/article/details/5737527
[Oracle _ 8]: http://blog.csdn.net/robinson_0612/article/details/5784713
[Oracle _ROLLBACK_UNDO_]: http://blog.csdn.net/robinson_0612/article/details/5731158
[Oracle _ 9]: http://blog.csdn.net/robinson_0612/article/details/5542983
[Oracle 10g SGA _]: http://blog.csdn.net/robinson_0612/article/details/5534832
[Oracle _Oracle_Oracle]: http://blog.csdn.net/robinson_0612/article/details/5529239
[https_blog.csdn.net_jiangjunshow]: https://blog.csdn.net/jiangjunshow/article/details/77338485