Oracle RAC维护

最新推荐文章于 2024-03-11 21:22:07 发布
最新推荐文章于 2024-03-11 21:22:07 发布
阅读量433 收藏
点赞数
分类专栏： oracle RAC 文章标签： Oracle RAC维护
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/huangbaokang/article/details/103281853
版权

查看服务状态

[root@node1 oracle]# su - grid
[grid@node1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    node1       
ora.FLASH.dg   ora....up.type ONLINE    ONLINE    node1       
ora.GRIDDG.dg  ora....up.type ONLINE    ONLINE    node1       
ora....ER.lsnr ora....er.type ONLINE    ONLINE    node1       
ora....N1.lsnr ora....er.type ONLINE    ONLINE    node1       
ora.asm        ora.asm.type   ONLINE    ONLINE    node1       
ora.devdb.db   ora....se.type ONLINE    ONLINE    node1       
ora.eons       ora.eons.type  ONLINE    ONLINE    node1       
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    node1       
ora....SM1.asm application    ONLINE    ONLINE    node1       
ora....E1.lsnr application    ONLINE    ONLINE    node1       
ora.node1.gsd  application    OFFLINE   OFFLINE               
ora.node1.ons  application    ONLINE    ONLINE    node1       
ora.node1.vip  ora....t1.type ONLINE    ONLINE    node1       
ora....SM2.asm application    ONLINE    ONLINE    node2       
ora....E2.lsnr application    ONLINE    ONLINE    node2       
ora.node2.gsd  application    OFFLINE   OFFLINE               
ora.node2.ons  application    ONLINE    ONLINE    node2       
ora.node2.vip  ora....t1.type ONLINE    ONLINE    node2       
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE               
ora.ons        ora.ons.type   ONLINE    ONLINE    node1       
ora....ry.acfs ora....fs.type ONLINE    ONLINE    node1       
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    node1

检查CRS状态

[grid@node1 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

从帮助文档可以查看更多使用

[grid@node1 ~]$ crsctl check -h
Usage:
  crsctl check crs
     Check status of OHAS and CRS stack

  crsctl check cluster [[-all]|[-n <server>[...]]]
     Check status of CRS stack

  crsctl check ctss
    Check status of Cluster Time Synchronization Services

  crsctl check resource {<resName> [...]|-w <filter>} [-n <server>] [-k <cid>] [-d <did>]
     Check status of resource(s)

  crsctl check css
     Check status of Cluster Synchronization Services

查看集群状态

[grid@node1 ~]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[grid@node1 ~]$ crsctl check cluster -all
**************************************************************
node1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
node2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

查看集群中节点的配置信息

[grid@node1 ~]$ olsnodes -h
Usage: olsnodes [ [-n] [-i] [-s] [-t] [<node> | -l [-p]] | [-c] ] [-g] [-v]
	where
		-n print node number with the node name
		-p print private interconnect address for the local node
		-i print virtual IP address with the node name
		<node> print information for the specified node
		-l print information for the local node 
		-s print node status - active or inactive 
		-t print node type - pinned or unpinned 
		-g turn on logging 
		-v Run in debug mode; use at direction of Oracle Support only.
		-c print clusterware name

[grid@node1 ~]$ olsnodes -n -i
node1	1	node1-vip
node2	2	node2-vip
[grid@node1 ~]$ olsnodes -n -i -s
node1	1	node1-vip	Active
node2	2	node2-vip	Active

查看集群软件使用版本

[grid@node1 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.1.0]

查看集群软件发行版本信息

[grid@node1 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.1.0]

查看集群软件安装版本信息

[grid@node1 ~]$ crsctl query crs softwareversion
Oracle Clusterware version on node [node1] is [11.2.0.1.0]

查看集群表决磁盘信息

[grid@node1 ~]$ crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   680586e681394f53bfcb7080a2ee68da (ORCL:VOL1) [GRIDDG]
Located 1 voting disk(s).

查看集群SCAN VIP信息

[grid@node1 ~]$ srvctl config scan
SCAN name: scan-cluster.localdomain, Network: 1/192.168.78.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /scan-cluster.localdomain/192.168.78.100

查看集群SCAN Listener信息

[grid@node1 ~]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

查看集群OCR文件信息

[grid@node1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
	 Version                  :          3
	 Total space (kbytes)     :     262120
	 Used space (kbytes)      :       2692
	 Available space (kbytes) :     259428
	 ID                       : 1081413730
	 Device/File Name         :    +GRIDDG
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

	 Cluster registry integrity check succeeded

	 Logical corruption check bypassed due to non-privileged user

提示权限不足，以root执行

[root@node1 oracle]# /u01/app/11.2.0/grid/bin/ocrcheck -local
Status of Oracle Local Registry is as follows :
	 Version                  :          3
	 Total space (kbytes)     :     262120
	 Used space (kbytes)      :       2204
	 Available space (kbytes) :     259916
	 ID                       : 1866931793
	 Device/File Name         : /u01/app/11.2.0/grid/cdata/node1.olr
                                    Device/File integrity check succeeded

	 Local registry integrity check succeeded

	 Logical corruption check succeeded

查看集群OCR备份信息

[grid@node1 ~]$ ocrconfig -showbackup

node1     2019/11/28 09:38:27     /u01/app/11.2.0/grid/cdata/scan-cluster/backup00.ocr

node1     2019/11/28 05:38:18     /u01/app/11.2.0/grid/cdata/scan-cluster/backup01.ocr

node1     2019/11/28 01:38:15     /u01/app/11.2.0/grid/cdata/scan-cluster/backup02.ocr

node1     2019/11/27 13:38:00     /u01/app/11.2.0/grid/cdata/scan-cluster/day.ocr

node1     2019/11/27 13:38:00     /u01/app/11.2.0/grid/cdata/scan-cluster/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available

每隔四小时备份一次，而且每天，每周，都有相关备份，隔多长时间官网有说明，我记不清了。

启停集群数据库

先查看下当前集群状态，是运行的

[grid@node1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    node1       
ora.FLASH.dg   ora....up.type ONLINE    ONLINE    node1       
ora.GRIDDG.dg  ora....up.type ONLINE    ONLINE    node1       
ora....ER.lsnr ora....er.type ONLINE    ONLINE    node1       
ora....N1.lsnr ora....er.type ONLINE    ONLINE    node1       
ora.asm        ora.asm.type   ONLINE    ONLINE    node1       
ora.devdb.db   ora....se.type ONLINE    ONLINE    node1       
ora.eons       ora.eons.type  ONLINE    ONLINE    node1       
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    node1       
ora....SM1.asm application    ONLINE    ONLINE    node1       
ora....E1.lsnr application    ONLINE    ONLINE    node1       
ora.node1.gsd  application    OFFLINE   OFFLINE               
ora.node1.ons  application    ONLINE    ONLINE    node1       
ora.node1.vip  ora....t1.type ONLINE    ONLINE    node1       
ora....SM2.asm application    ONLINE    ONLINE    node2       
ora....E2.lsnr application    ONLINE    ONLINE    node2       
ora.node2.gsd  application    OFFLINE   OFFLINE               
ora.node2.ons  application    ONLINE    ONLINE    node2       
ora.node2.vip  ora....t1.type ONLINE    ONLINE    node2       
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE               
ora.ons        ora.ons.type   ONLINE    ONLINE    node1       
ora....ry.acfs ora....fs.type ONLINE    ONLINE    node1       
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    node1

执行停止集群数据库devdb

[grid@node1 ~]$ srvctl stop database -d devdb

再次查看集群运行状态

[grid@node1 ~]$ ps -ef|grep ora_
grid     24253 23542  0 10:19 pts/4    00:00:00 grep ora_

可以看到devdb已经变成了OFFLINE

[grid@node1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    node1       
ora.FLASH.dg   ora....up.type ONLINE    ONLINE    node1       
ora.GRIDDG.dg  ora....up.type ONLINE    ONLINE    node1       
ora....ER.lsnr ora....er.type ONLINE    ONLINE    node1       
ora....N1.lsnr ora....er.type ONLINE    ONLINE    node1       
ora.asm        ora.asm.type   ONLINE    ONLINE    node1       
ora.devdb.db   ora....se.type OFFLINE   OFFLINE               
ora.eons       ora.eons.type  ONLINE    ONLINE    node1       
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    node1       
ora....SM1.asm application    ONLINE    ONLINE    node1       
ora....E1.lsnr application    ONLINE    ONLINE    node1       
ora.node1.gsd  application    OFFLINE   OFFLINE               
ora.node1.ons  application    ONLINE    ONLINE    node1       
ora.node1.vip  ora....t1.type ONLINE    ONLINE    node1       
ora....SM2.asm application    ONLINE    ONLINE    node2       
ora....E2.lsnr application    ONLINE    ONLINE    node2       
ora.node2.gsd  application    OFFLINE   OFFLINE               
ora.node2.ons  application    ONLINE    ONLINE    node2       
ora.node2.vip  ora....t1.type ONLINE    ONLINE    node2       
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE               
ora.ons        ora.ons.type   ONLINE    ONLINE    node1       
ora....ry.acfs ora....fs.type ONLINE    ONLINE    node1       
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    node1

也可以看出ASM还是运行的，这个命令只是把数据库停止了

启停集群件服务，以root身份执行，grid用户执行会提示权限不足。

[root@node1 oracle]# /u01/app/11.2.0/grid/bin/crsctl stop cluster -allCRS-2673: Attempting to stop 'ora.crsd' on 'node1'
CRS-2673: Attempting to stop 'ora.crsd' on 'node2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'node1'
CRS-2673: Attempting to stop 'ora.GRIDDG.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'node1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.FLASH.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'node1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'node1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'node2'
CRS-2673: Attempting to stop 'ora.GRIDDG.dg' on 'node2'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'node2'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'node2'
CRS-2673: Attempting to stop 'ora.FLASH.dg' on 'node2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'node2'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.node1.vip' on 'node1'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'node1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.node2.vip' on 'node2'
CRS-2677: Stop of 'ora.node2.vip' on 'node2' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'node1' succeeded
CRS-2677: Stop of 'ora.node1.vip' on 'node1' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'node1' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'node2' succeeded
CRS-2677: Stop of 'ora.GRIDDG.dg' on 'node1' succeeded
CRS-2677: Stop of 'ora.FLASH.dg' on 'node1' succeeded
CRS-2677: Stop of 'ora.GRIDDG.dg' on 'node2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2677: Stop of 'ora.FLASH.dg' on 'node2' succeeded
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'node2'
CRS-2677: Stop of 'ora.asm' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.eons' on 'node2'
CRS-2673: Attempting to stop 'ora.ons' on 'node2'
CRS-2677: Stop of 'ora.ons' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'node2'
CRS-2677: Stop of 'ora.net1.network' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.eons' on 'node1'
CRS-2673: Attempting to stop 'ora.ons' on 'node1'
CRS-2677: Stop of 'ora.eons' on 'node2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'node2' has completed
CRS-2677: Stop of 'ora.ons' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'node1'
CRS-2677: Stop of 'ora.net1.network' on 'node1' succeeded
CRS-2677: Stop of 'ora.crsd' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'node2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'node2'
CRS-2673: Attempting to stop 'ora.evmd' on 'node2'
CRS-2673: Attempting to stop 'ora.asm' on 'node2'
CRS-2677: Stop of 'ora.cssdmonitor' on 'node2' succeeded
CRS-2677: Stop of 'ora.eons' on 'node1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'node1' has completed
CRS-2677: Stop of 'ora.crsd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'node1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'node1'
CRS-2673: Attempting to stop 'ora.evmd' on 'node1'
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2677: Stop of 'ora.cssdmonitor' on 'node1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'node1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'node2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'node2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'node1' succeeded
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node1'
CRS-2677: Stop of 'ora.cssd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'node1'
CRS-2677: Stop of 'ora.asm' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node2'
CRS-2677: Stop of 'ora.cssd' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'node2'
CRS-2677: Stop of 'ora.diskmon' on 'node2' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'node1' succeeded

启动集群所有服务，把stop改成start即可

黄宝康
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
Oracle RAC集群维护
Mr_Weishanghong的博客
04-02 616
Oracle RAC集群维护--个人经验整理 1、检查集群状态： 　　[grid@rac02 ~]$ crsctl check cluster 　　CRS-4537: Cluster Ready Services is online 　　CRS-4529: Cluster Synchronization Services is online 　　CRS-4533: Event Manag...
再说 Oracle RAC services
fsfsdfsdw的博客
11-15 233
再说 Oracle RAC services
Oracle Rac集群日常维护管理命令
the_coco的博客
03-11 1127
在11g R2中，默认 oc4j和gsd资源是 disable的；gsd是 CRS 用于跟 9i RAC 进行通信的一个模块,是为了向后兼容才保留的，不影响性能；在第一节中，看到直接停止集群，相关的Resource 也会被停止。但一些实际情况下，我们操作更多的是对某些资源的操作。查看各资源状态(nodeapps节点应用程序，ASM实例，数据库等)1、通过SRVCTL命令来startstopcheck所有的实例。使用srvctl status obj 来查询集群、资源的状态。停止：关闭数据库，关闭CRS。
RAC详细命令(转)
congrang4672的博客
09-22 608
Oracle Clusterware的命令集可以分为以下4种： 节点层：osnodes 网络层：oifcfg 集群层：crsctl, ocrcheck,ocrdump,ocrconfig ...
Oracle 11gR2 RAC 常用维护操作 说明
数据库
12-26 309
之前整理了2篇Oracle 10gRAC的启动与关闭相关的文章，参考： Oracle 10gRAC 启动与关闭 http://blog.csdn.net/tianlesoftware/article/details/5349003 Oracle RAC 常用维护工具和命令 http://blog.csdn.net/tianlesoftware/article/details/535857...
Oracle RAC 资料收集日常基本维护命令
04-28
Oracle RAC 资料收集日常基本维护命令
oracle_rac日常基本维护命令
04-28
oracle rac日常基本维护命令 2 Oracle RAC性能调整 12 详解Oracle RAC入门和提高 27 ORACLE RAC数据库配置Dataguard环境 49 老白对于RAC应用调优的建议 51
oracle rac 维护命令记录笔记
06-24
oracle rac 维护命令记录笔记
Oracle RAC中的几个IP
12-14
Oracle RAC（Real Application Clusters）是Oracle数据库的一种高可用性解决方案，允许多个数据库实例共享同一份物理数据，提供故障切换和负载均衡的能力。在Oracle RAC中，有几种特定的IP地址配置，以实现集群的...
oracle rac常用维护命令（全）
最新发布
06-28
oracle rac常用维护命令（全）
oracle rac日常基本维护命令
08-30
oracle rac日常基本维护命令 所有实例和服务的状态 $ srvctl status database -d orcl Instance orcl1 is running on node linux1 Instance orcl2 is running on node linux2 单个实例的状态 $ srvctl status instance -d orcl -i orcl2 Instance orcl2 is running on node linux2 在数据库全局命名服务的状态 $ srvctl status service -d orcl -s orcltest Service orcltest is running on instance(s) orcl2, orcl1 特定节点上节点应用程序的状态 $ srvctl status nodeapps -n linux1 VIP is running on node: linux1 GSD is running on node: linux1 Listener is running on node: linux1 ONS daemon is running on node: linux1 ASM 实例的状态 $ srvctl status asm -n linux1 ASM instance +ASM1 is running on node linux1. 列出配置的所有数据库 $ srvctl config database orcl 显示 RAC 数据库的配置 $ srvctl config database -d orcl linux1 orcl1 /u01/app/oracle/product/10.2.0/db_1 linux2 orcl2 /u01/app/oracle/product/10.2.0/db_1 显示指定集群数据库的所有服务 $ srvctl config service -d orcl orcltest PREF: orcl2 orcl1 AVAIL: 显示节点应用程序的配置 —（VIP、GSD、ONS、监听器） $ srvctl config nodeapps -n linux1 -a -g -s -l VIP exists.: /linux1-vip/192.168.1.200/255.255.255.0/eth0:eth1 GSD exists. ONS daemon exists. Listener exists. 显示 ASM 实例的配置 $ srvctl config asm -n linux1 +ASM1 /u01/app/oracle/product/10.2.0/db_1 集群中所有正在运行的实例 SELECT inst_id , instance_number inst_no , instance_name inst_name , parallel , status , database_status db_status , active_state state , host_name host FROM gv$instance ORDER BY inst_id; INST_ID INST_NO INST_NAME PAR STATUS DB_STATUS STATE HOST -------- -------- ---------- --- ------- ------------ --------- ------- 1 1 orcl1 YES OPEN ACTIVE NORMAL rac1 2 2 orcl2 YES OPEN ACTIVE NORMAL rac2 位于磁盘组中的所有数据文件 select name from v$datafile union select member from v$logfile union select name from v$controlfile union select name from v$tempfile; NAME ------------------------------------------- +FLASH_RECOVERY_AREA/orcl/controlfile/current.258.570913191 +FLASH_RECOVERY_AREA/orcl/onlinelog/group_1.257.570913201 +FLASH_RECOVERY_AREA/orcl/onlinelog/group_2.256.570913211 +FLAS
Oracle RAC原理.doc
09-11
Oracle RAC，全称为Real ...然而，RAC的实施和维护需要深入了解Oracle数据库和集群技术，确保系统的稳定和高效运行。在设计和配置RAC时，必须考虑到网络、存储、硬件和软件之间的交互，以实现最佳性能和可用性。
ORACLE RAC维护手册
09-24
以下是一些关于ORACLE RAC维护的关键知识点： 1. **实例和服务状态**：通过`srvctl status database`命令可以查看整个ORCL数据库的所有实例和服务状态。例如，`srvctl status database -d orcl`会显示所有实例的...
oracle rac 维护经验,Oracle RAC日常基本维护命令
weixin_30369779的博客
04-07 184
欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入 所有实例和服务的状态 $ srvctl status database -d orcl Instance orcl1 is running on node linux1 Instance orcl2 is running on node linux2 单个实例的状态 $ srvctl status instance -...
你不可不看的 Oracle RAC 日常基本维护命令
Enmotech的博客
05-09 3979
所有实例和服务的状态$ srvctl status database -d orclInstance orcl1 is running on node linux1Ins...
oracle RAC的常用维护操作
data eudemon
08-22 1107
    1. 查看各资源状态(nodeapps节点应用程序，ASM实例，数据库实例等)： [root@rac01 u01]# su - grid ITPUB个人空间/E6dV0Cu3dZ#q,d[grid@rac01 ~]$ crs_stat -t   (命令兼容10g)ITPUB个人空间VNg7\6fej*Y%uName          Type          Target    S...
Oracle RAC 常用维护工具和命令
ysds20211402的博客
04-09 471
转自：微点阅读https://www.weidianyuedu.com/content/3117756287208.html oracle RAc 常用维护工具和命令 oracle 的管理可以通过oEM或者命令行接口。 oracle clusterware的命令集可以分为以下4种： 节点层：osnodes 网络层：oifcfg 集群层：crsctl, ocrcheck,ocrdump,ocrconfig 应用层：srvctl,onsctl,crs_stat 下面分别来介绍这些命令。 ...
Oracle 11g环境，RAC的关闭和启动顺序
gaobudong1234的博客
06-13 6522
在Oracle 11g环境中，Oracle的关闭和启动顺序如下：       关闭顺序：   1、关闭数据库,oracl用户执行srvctl命令：    [oracle@rac1 ~]$ srvctl stop database -d ORCL ---停止所有节点上的实例   或者每个节点登录数据库后执行SQL>shutdown immediate   2
ORA-01196: file 1 is inconsistent due to a failed media recovery session
huangbaokang的博客
01-02 1676
在Oracle RAC物理备库启动的时候报如下错误： SQL> startup ORACLE instance started. Total System Global Area 839282688 bytes Fixed Size 2217992 bytes Variable Size 574621688 bytes Database Buffers 2558525...
oracle rac 维护
06-06
以下是 Oracle RAC 维护的一些常见步骤： 1. 定期备份：定期备份是保护数据的最基本的维护任务之一，可以使用 Oracle 自带的备份工具或第三方备份工具。 2. 定期监控：监控集群的状态和性能是维护的另一个重要任务...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

黄宝康

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值