《oracle11grac数据库节点损坏恢复资料》由会员分享，可在线阅读，更多相关《oracle11grac数据库节点损坏恢复资料（18页珍藏版）》请在金锄头文库上搜索。
1、 Oracle11gR2 Rac节点损坏恢复方正国际公共安全事业部技术文档1. 文档属性文档属性内容文档名称Oracle11gR2 Rac 节点损坏恢复报告文档版本号A1文档状态正式稿文档编写完成日期2016年9月14日作 者2.文档变更历史清单文件版本号修正日期修正人备 注3.本次修改变更说明序号变更内容简述1.2.3.4.5.第1章 概述辽宁省厅警务综合平台项目中，锦州数据库现场的用户因为在未停止数据库的情况下，扩展磁盘阵列，更换磁盘，导致1节点本地磁盘阵列挂不上，导致只能一个节点使用数据库，需要重新配置oracle集群信息。第2章 系统环境项目名称服务器名RAC节点1RAC节点2操作系统
2、RedHat 6RedHat 6集群软件Oracle GRIDOracle GRID服务器主机名his1his2IP 地址（示例）172.31.1.50172.31.1.51 系统用户用户名RootGridoracle系统组dbaasmdbaasmadminoinstallasmoperdbaasmdbaasmadminoinstallasmoper第3章 数据库环境项目名称服务器名称RAC节点1RAC 节点2公共IP地址172.31.1.50172.31.1.51虚拟IP地址172.31.1.52172.31.1.53心跳IP地址192.168.0.1192.168.0.2ScanIP 地址
3、172.31.1.54Oracle RAC SIDorcl1orcl2数据库名称orcl数据文件路径+DATA归档文件+ARCH数据库版本Oracle Database 11g Enterprise Edition Release 11.2.0.4.0(64位)GRID_BASE目录 /u01/app/gridGRID_HOME目录/u01/app/grid/11.2.0ORACLE_BASE目录/u01/app/oracleORACLE_HOME目录/u01/app/oracle /11.2.0数据库监听端口1521数据库字符集ZHS16GBK数据库用户（sys,system）密码oracl
4、e数据库硬盘管理方式ASM第4章 实施步骤4.1 操作系统准备工作包括如下操作，主要和rac安装文档相同，如果需要重新安装操作系统，请参考rac安装文档的操作，进行操作系统配置。下面只列出：4.1.1 配置grid用户及oracle用户等效性Grid用户(his2先删除.shh目录)在his1上：su - grid$ mkdir /.ssh$ chmod 700 /.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa$ cat /.ssh/id_rsa.pub /.ssh/authorized_keys$ cat /.ssh/id_dsa.pub /.ssh/a
5、uthorized_keys在his2上：$ mkdir /.ssh$ chmod 700 /.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa在his1上：$ ssh jkkdb2 cat /.ssh/id_rsa.pub /.ssh/authorized_keys$ ssh jkkdb2 cat /.ssh/id_dsa.pub /.ssh/authorized_keys$ scp /.ssh/authorized_keys jkkdb2:/.ssh/authorized_keys验证$ ssh his1 date$ ssh his1-priv date$
6、 ssh his2 date$ ssh his2-priv dateOracle用户()在his1上：su - grid$ mkdir /.ssh$ chmod 700 /.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa$ cat /.ssh/id_rsa.pub /.ssh/authorized_keys$ cat /.ssh/id_dsa.pub /.ssh/authorized_keys在his2上：$ mkdir /.ssh$ chmod 700 /.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa在his1上：$
7、ssh jkkdb2 cat /.ssh/id_rsa.pub /.ssh/authorized_keys$ ssh jkkdb2 cat /.ssh/id_dsa.pub /.ssh/authorized_keys$ scp /.ssh/authorized_keys jkkdb2:/.ssh/authorized_keys验证$ ssh his1 date$ ssh his1-priv date$ ssh his2 date$ ssh his2-priv date4.1.2 设置raw,磁盘阵列联系硬件厂家，扩展磁盘操作等等，两个机器的磁盘信息相同，主要是挂的磁盘号要一致。4.1.3 重启
8、his1服务器4.2 停止原来1节点vip$ srvctl disable listener -l listener_name -n his1$ srvctl stop listener -l listener_name -n his14.3 删除原1节点数据库实例信息oracle用户执行：$dbca -silent -deleteInstance -nodeList his1 -gdbName orcl -instanceName orcl1 -sysDBAUserName sys -sysDBAPassword oracle此时查看数据库信息：$srvctl config database
9、 -d orclDatabase unique name: orclDatabase name: Oracle home: /oracle/product/11.2.0/db_1Oracle user: oracleSpfile: Domain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: orclDatabase instances: his2 -原来是his1，his2Disk Groups: DATAMount point
10、 paths: Services: Type: RACDatabase is administrator managed4.4 清除rac信息清除grid/grid/gridhome/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/grid/gridhome CLUSTER_NODES=his2 CRS=TRUE -silentStarting Oracle Universal Installer.Checking swap space: must be greater than 500 MB. Actual 20480 MB PassedT
11、he inventory pointer is located at /etc/oraInst.locThe inventory is located at /grid/gridbase/oraInventoryUpdateNodeList was successful.清除oracle/oracle/product/11.2.0/db_1/oui/binrunInstaller -updateNodeList ORACLE_HOME= /oracle/product/11.2.0/db_1 CLUSTER_NODES=his2Starting Oracle Universal Install
12、er.Checking swap space: must be greater than 500 MB. Actual 20480 MB PassedThe inventory pointer is located at /etc/oraInst.locThe inventory is located at /oracle/oraInventoryUpdateNodeList was successful.查看/grid/gridhome/opmen/conf/ons.config文件usesharedinstall=trueallowgroup=truelocalport=6100 # li
13、ne added by Agentremoteport=6200 # line added by Agentnodes=his2:6200 # line added by Agent如果还有his1信息，手工删除4.5 清除1节点vip$srvctl remove vip -i his1-vipPlease confirm that you intend to remove the VIPs his1-vip (y/n) y4.6 检查当前集群信息$olsnodes -s t$crs_stat t$cluvfy stage -post nodedel -n his1 -verbosePerfo
14、rming post-checks for node removal Checking CRS integrity.Clusterware version consistency passedThe Oracle Clusterware is healthy on node his2CRS integrity check passedResult: Node removal check passedPost-check for node removal was successful.4.7 重新添加1节点到集群4.7.1 添加grid软件环境检查$cluvfy comp peer -refnode his2 -n his1 -verbose$cluvfy s
