美文网首页Oracle
分享 | RAC 节点重做记录

分享 | RAC 节点重做记录

作者: 益达_glmsb | 来源:发表于2022-01-28 16:07 被阅读0次

10.2.0.4 及 11.2.0.3 测试
[oracle@mmdb2 ~]crs_stat -t Name Type Target State Host +++++++++++++++++++++++++++++++++++ ora.mmdb.db application ONLINE ONLINE mmdb2 ora....b1.inst application ONLINE OFFLINE ora....b2.inst application ONLINE ONLINE mmdb2 ora....SM1.asm application ONLINE OFFLINE ora....B1.lsnr application ONLINE OFFLINE ora.mmdb1.gsd application ONLINE OFFLINE ora.mmdb1.ons application ONLINE OFFLINE ora.mmdb1.vip application ONLINE ONLINE mmdb2 ora....SM2.asm application ONLINE ONLINE mmdb2 ora....B2.lsnr application ONLINE ONLINE mmdb2 ora.mmdb2.gsd application ONLINE ONLINE mmdb2 ora.mmdb2.ons application ONLINE ONLINE mmdb2 ora.mmdb2.vip application ONLINE ONLINE mmdb2 [oracle@mmdb2 ~]
[root@mmdb1 crs]# more root.sh

!/bin/sh

/oracle/product/10.2.0/crs/install/rootinstall
/oracle/product/10.2.0/crs/install/rootconfig

拷贝grid(base及home)
[root@mmdb1 crs]# ./root.sh
WARNING: directory '/oracle/product/10.2.0' is not owned by root
WARNING: directory '/oracle/product' is not owned by root
WARNING: directory '/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.

Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/oracle/product/10.2.0' is not owned by root
WARNING: directory '/oracle/product' is not owned by root
WARNING: directory '/oracle' is not owned by root
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: mmdb1 mmdb1-priv mmdb1
node 2: mmdb2 mmdb2-priv mmdb2
clscfg: Arguments check out successfully.

NO KEYS WERE WRITTEN. Supply -force parameter to override.
-force is destructive and will destroy any previous cluster
configuration.
Oracle Cluster Registry for cluster has already been initialized
Startup will be queued to init within 30 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.

mmdb1
mmdb2
CSS is active on all nodes.
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
Running vipca(silent) for configuring nodeapps

Creating VIP application resource on (0) nodes.
Creating GSD application resource on (0) nodes.
Creating ONS application resource on (0) nodes.
Starting VIP application resource on (2) nodes...
Starting GSD application resource on (2) nodes...
Starting ONS application resource on (2) nodes...

Done.

拷贝ORACLE安装目录
[oracle@mmdb1 ~]$ crs_stat -t
Name Type Target State Host

++++++++++++++++++++++++++++++++++++++++++++++
ora.mmdb.db application ONLINE ONLINE mmdb2
ora....b1.inst application ONLINE OFFLINE
ora....b2.inst application ONLINE ONLINE mmdb2
ora....SM1.asm application ONLINE OFFLINE
ora....B1.lsnr application ONLINE OFFLINE
ora.mmdb1.gsd application ONLINE ONLINE mmdb1
ora.mmdb1.ons application ONLINE ONLINE mmdb1
ora.mmdb1.vip application ONLINE ONLINE mmdb1
ora....SM2.asm application ONLINE ONLINE mmdb2
ora....B2.lsnr application ONLINE ONLINE mmdb2
ora.mmdb2.gsd application ONLINE ONLINE mmdb2
ora.mmdb2.ons application ONLINE ONLINE mmdb2
ora.mmdb2.vip application ONLINE ONLINE mmdb2

[root@mmdb1 db]# ./root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/product/10.2.0/db

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

[oracle@mmdb1 ~]crs_star -all -bash: crs_star: command not found [oracle@mmdb1 ~] crs_start -all
Attempting to start ora.mmdb1.ASM1.asm on member mmdb1
Start of ora.mmdb1.ASM1.asm on member mmdb1 succeeded.
Attempting to start ora.mmdb.mmdb1.inst on member mmdb1
Start of ora.mmdb.mmdb1.inst on member mmdb1 succeeded.
Attempting to start ora.mmdb1.LISTENER_MMDB1.lsnr on member mmdb1
Start of ora.mmdb1.LISTENER_MMDB1.lsnr on member mmdb1 succeeded.

[oracle@mmdb1 ~]$ crs_stat -t
Name Type Target State Host

+++++++++++++++++++++++++++++++++++++++++++++++
ora.mmdb.db application ONLINE ONLINE mmdb2
ora....b1.inst application ONLINE ONLINE mmdb1
ora....b2.inst application ONLINE ONLINE mmdb2
ora....SM1.asm application ONLINE ONLINE mmdb1
ora....B1.lsnr application ONLINE ONLINE mmdb1
ora.mmdb1.gsd application ONLINE ONLINE mmdb1
ora.mmdb1.ons application ONLINE ONLINE mmdb1
ora.mmdb1.vip application ONLINE ONLINE mmdb1
ora....SM2.asm application ONLINE ONLINE mmdb2
ora....B2.lsnr application ONLINE ONLINE mmdb2
ora.mmdb2.gsd application ONLINE ONLINE mmdb2
ora.mmdb2.ons application ONLINE ONLINE mmdb2
ora.mmdb2.vip application ONLINE ONLINE mmdb2

相关文章

  • 分享 | RAC 节点重做记录

    10.2.0.4 及 11.2.0.3 测试[oracle@mmdb2 ~][root@mmdb1 crs]# m...

  • Oracle RAC 添加节点

    摘要:Oracle RAC 添加节点操作,跟安装类似,配置所需OS参数、IP规划等,需要在rac层和db层分别添加...

  • 分布式事务-柔性事务

    引入日志和补偿机制 柔性事务的原子性主要由日志保证。 参与者节点会根据重做或回滚需要而记录REDO/UNDO日志。...

  • centos7部署oracle 11g rac安装部署(一)

    一、安装前准备 1.Oracle RAC 节点内存规划 建议SGA+PGA占整个节点物理内存的65%,其中,SGA...

  • 使用ReactiveCocoa改善工作流程

    使用 ReactiveCocoa (下文将用 RAC 简称)有一段时间了,写点东西记录一下心得,权当分享。我的知识...

  • RAC节点频繁重启

    主要的trc文件是:/home/oracle/product/admin/ilndb/udump/ilndb3_o...

  • 解耦-用RAC处理网络请求

    最近接手的项目中使用了RAC,也研究学习了下,发现使用RAC确实清晰便利了许多,下面记录一下用RAC处理网络请求实...

  • 归档日志与在联机日志

    redolog:重做日志,记录数据库得更改,(原理:在数据更新操作commit前,将更改得sql脚本写入重做日志。...

  • ArcGis使用技巧

    Z:放大 X:缩小 C:漫游 V:显示节点 ESC:取消 Ctrl+Z:撤销 Ctrl+Y重做 Spacebar:...

  • 晚饭的茶真强劲

    记录一下今天踩过的坑rac使用的时候我们经常使用rac_signalForSelector 来抓代理方法. 有时候...

网友评论

    本文标题:分享 | RAC 节点重做记录

    本文链接:https://www.haomeiwen.com/subject/ewltkrtx.html