- 11gRAC 常用命令
11gRAC 常用命令
11gRAC对比10GRAC的命令有了许多变化，下面一一叙述
一、在Oracle 11g环境中，Oracle的关闭和启动顺序
1.关闭顺序
1、关闭数据库,oracl用户执行srvctl命令：
[oracle@rac1 ~]$ srvctl stop database -d ORCL ---停止所有节点上的实例
或者每个节点登录数据库后执行
SQL>shutdown immediate
2、停止集群服务，必须以root用户：
[root@rac1 oracle]# cd /u01/grid/11.2.0/grid/bin
[root@rac1 bin]# ./crsctl stop cluster -all ----停止所有节点服务
[root@rac1 bin]# ./crsctl stop cluster ----停止本节点集群服务，每个节点分别执行
PS:
也可以如下控制所停节点：
[root@rac1 bin]# ./crsctl stop cluster -n rac1
3、停止HAS(High Availability Services)，必须以root用户
[root@rac1 oracle]# cd /u01/grid/11.2.0/grid/bin
[root@rac1 bin]# ./crsctl stop has –f
注：在运行crsctl stop cluster命令之后，如果 Oracle Clusterware 管理的资源中有任何一个还在运行，则整个命令失败。使用 -f 选项无条件地停止所有资源并停止 Oracle Clusterware 系统。
另请注意，可通过指定 -all 选项在集群中所有服务器上停止 Oracle Clusterware 系统。
2.启动顺序
11g R2的RAC默认开机会自启动，当然如果需要手工启动。手工启动按照HAS,cluster, database的顺序启动即可，具体命令如下：
1、启动HAS(High Availability Services)，必须以root用户
[root@rac1 bin]# ./crsctl start has
以上has启动命令需要在每个节点分别执行
2、启动集群（cluster）
[root@rac1 ~]# ./crsctl start cluster -all --所有节点同时启动
或者只启动指定节点的
[root@rac1 ~]# ./crsctl start cluster -n rac1 rac2 --两个节点同时启动
3、启动数据库,oracl用户执行srvctl命令（假设数据库名为ORCL）：
[oracle@rac1 ~]$ srvctl start database -d ORCL ---停止所有节点上的实例
或者每个节点登录数据库后执行SQL>startup
4、使用crs_stat命令来进程验证
[grid@oracle1 ~]$ crs_stat -t -v
3.启动和停止CRS
以下操作需用root用户执行
[root@racnode2 bin]# /u01/app/11.2.0/grid/bin/crsctl stop crs
CRS-2791: 正在启动用于关闭 'racnode2' 上 Oracle High Availability Services 管理的资源的操作
CRS-2673: 尝试停止 'ora.crsd' (在 'racnode2' 上)
CRS-2790: 正在启动关闭 'racnode2' 上集群就绪服务管理的资源的操作
CRS-2673: 尝试停止 'ora.CRS.dg' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.racdb.db' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.LISTENER.lsnr' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.LISTENER_SCAN1.lsnr' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.LISTENER.lsnr' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.racnode2.vip' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.LISTENER_SCAN1.lsnr' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.scan1.vip' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.racnode2.vip' (在 'racnode2' 上)
CRS-2672: 尝试启动 'ora.racnode2.vip' (在 'racnode1' 上)
CRS-2677: 成功停止 'ora.scan1.vip' (在 'racnode2' 上)
CRS-2672: 尝试启动 'ora.scan1.vip' (在 'racnode1' 上)
CRS-2676: 成功启动 'ora.scan1.vip' (在 'racnode1' 上)
CRS-2676: 成功启动 'ora.racnode2.vip' (在 'racnode1' 上)
CRS-2672: 尝试启动 'ora.LISTENER_SCAN1.lsnr' (在 'racnode1' 上)
CRS-2676: 成功启动 'ora.LISTENER_SCAN1.lsnr' (在 'racnode1' 上)
CRS-2677: 成功停止 'ora.CRS.dg' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.racdb.db' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.FRA.dg' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.RACDB_DATA.dg' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.FRA.dg' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.RACDB_DATA.dg' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.asm' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.asm' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.eons' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.ons' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.ons' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.net1.network' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.net1.network' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.eons' (在 'racnode2' 上)
CRS-2792: 关闭 'racnode2' 上集群就绪服务管理的资源的操作已完成
CRS-2677: 成功停止 'ora.crsd' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.mdnsd' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.cssdmonitor' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.ctssd' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.evmd' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.asm' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.cssdmonitor' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.evmd' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.mdnsd' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.ctssd' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.asm' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.cssd' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.cssd' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.gpnpd' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.diskmon' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.gpnpd' (在 'racnode2' 上)
CRS-2673: 尝试停止 'ora.gipcd' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.gipcd' (在 'racnode2' 上)
CRS-2677: 成功停止 'ora.diskmon' (在 'racnode2' 上)
CRS-2793: 关闭 'racnode2' 上 Oracle High Availability Services 管理的资源的操作已完成
CRS-4133: Oracle High Availability Services has been stopped.
[root@racnode2 bin]# /u01/app/11.2.0/grid/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
二、检查集群状态
1.检查 CRS 状态
[grid@racnode1 ~]$ 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
2.检查集群的运行状况
[grid@racnode1 ~]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
3.查看各资源状态
包括:nodeapps节点应用程序，ASM实例，数据库实例等
[root@racnode1 ~]# su - grid
[grid@racnode1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.CRS.dg ora....up.type 0/5 0/ ONLINE ONLINE racnode1
ora.FRA.dg ora....up.type 0/5 0/ ONLINE ONLINE racnode1
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE racnode1
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE racnode2
ora....DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE racnode1
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE racnode1
ora.eons ora.eons.type 0/3 0/ ONLINE ONLINE racnode1
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE racnode1
ora.oc4j ora.oc4j.type 0/5 0/0 OFFLINE OFFLINE
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE racnode1
ora.racdb.db ora....se.type 0/2 0/1 ONLINE ONLINE racnode1
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE racnode1
ora....E1.lsnr application 0/5 0/0 ONLINE ONLINE racnode1
ora....de1.gsd application 0/5 0/0 OFFLINE OFFLINE
ora....de1.ons application 0/3 0/0 ONLINE ONLINE racnode1
ora....de1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE racnode1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE racnode2
ora....E2.lsnr application 0/5 0/0 ONLINE ONLINE racnode2
ora....de2.gsd application 0/5 0/0 OFFLINE OFFLINE
ora....de2.ons application 0/3 0/0 ONLINE ONLINE racnode2
ora....de2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE racnode2
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE racnode2
4.查看各资源状态(nodeapps节点应用程序，ASM实例，数据库实例等)
[grid@racnode1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
ONLINE ONLINE racnode1
ONLINE ONLINE racnode2
ora.FRA.dg
ONLINE ONLINE racnode1
ONLINE ONLINE racnode2
ora.LISTENER.lsnr
ONLINE ONLINE racnode1
ONLINE ONLINE racnode2
ora.RACDB_DATA.dg
ONLINE ONLINE racnode1
ONLINE ONLINE racnode2
ora.asm
ONLINE ONLINE racnode1 Started
ONLINE ONLINE racnode2
ora.eons
ONLINE ONLINE racnode1
ONLINE ONLINE racnode2
ora.gsd
OFFLINE OFFLINE racnode1
OFFLINE OFFLINE racnode2
ora.net1.network
ONLINE ONLINE racnode1
ONLINE ONLINE racnode2
ora.ons
ONLINE ONLINE racnode1
ONLINE ONLINE racnode2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE racnode2
ora.oc4j
1 OFFLINE OFFLINE
ora.racdb.db
1 ONLINE ONLINE racnode1 Open
2 ONLINE ONLINE racnode2 Instance Shutdown
ora.racnode1.vip
1 ONLINE ONLINE racnode1
ora.racnode2.vip
1 ONLINE ONLINE racnode2
ora.scan1.vip
1 ONLINE ONLINE racnode2
5.查看数据库状态
[grid@racnode1 ~]$ srvctl status database -d racdb
实例 racdb1 正在节点 racnode1 上运行
实例 racdb2 正在节点 racnode2 上运行
6.检查单个实例状态
[grid@racnode1 ~]$ srvctl status instance -d racdb -i racdb1
实例 racdb1 正在节点 racnode1 上运行
7.节点应用程序状态
[grid@racnode1 ~]$ srvctl status instance -d racdb -i racdb1
实例 racdb1 正在节点 racnode1 上运行
[grid@racnode1 ~]$ srvctl status nodeapps
VIP racnode1-vip 已启用
VIP racnode1-vip 正在节点上运行: racnode1
VIP racnode2-vip 已启用
VIP racnode2-vip 正在节点上运行: racnode2
网络已启用
网络正在节点上运行: racnode1
网络正在节点上运行: racnode2
GSD 已禁用
GSD 没有运行的节点: racnode1
GSD 没有运行的节点: racnode2
ONS 已启用
ONS 守护程序正在节点上运行:racnode1
ONS 守护程序正在节点上运行:racnode2
eONS 已启用
eONS 守护程序正在节点上运行:racnode1
eONS 守护程序正在节点上运行:racnode2
8.列出所有的配置数据库
[grid@racnode1 ~]$ srvctl config database
racdb
9.数据库配置
[grid@racnode1 ~]$ srvctl config database -d racdb -a
数据库唯一名称: racdb
数据库名: racdb
Oracle 主目录: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle 用户: oracle
Spfile: +RACDB_DATA/racdb/spfileracdb.ora
域: path_finder.info
启动选项: open
停止选项: immediate
数据库角色: PRIMARY
管理策略: AUTOMATIC
服务器池: racdb
数据库实例: racdb1,racdb2
磁盘组: RACDB_DATA,FRA
服务:
数据库已启用
数据库是管理员管理的
10.ASM状态以及ASM配置
[grid@racnode1 ~]$ srvctl status asm
ASM 正在 racnode1,racnode2 上运行
[grid@racnode1 ~]$ srvctl status asm -a
ASM 正在 racnode1,racnode2 上运行
ASM 已启用。
[grid@racnode1 ~]$ srvctl config asm -a
ASM 主目录: /u01/app/11.2.0/grid
ASM 监听程序: LISTENER
ASM 已启用。
11.检查 Oracle 集群注册表 (OCR)
[grid@racnode1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2568
Available space (kbytes) : 259552
ID : 1884152943
Device/File Name : +CRS
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
12.查看表决磁盘
[grid@racnode1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 2aae1495c66a4f50bf63a503076ef792 (ORCL:CRSVOL1) [CRS]
Located 1 voting disk(s).
13.TNS监听器状态以及配置
[grid@racnode1 ~]$ srvctl status listener
监听程序 LISTENER 已启用
监听程序 LISTENER 正在节点上运行: racnode1,racnode2
[grid@racnode1 ~]$ srvctl config listener -a
名称: LISTENER
网络: 1, 所有者: grid
主目录: <CRS home>
节点 racnode2,racnode1 上的 /u01/app/11.2.0/grid
端点: TCP:1521
14.SCAN状态以及配置
[grid@racnode1 ~]$ srvctl status scan
SCAN VIP scan1 已启用
SCAN VIP scan1 正在节点 racnode2 上运行
[grid@racnode1 ~]$ srvctl config scan
SCAN 名称: racnode-cluster-scan, 网络: 1/10.236.101.0/255.255.255.0/eth0
SCAN VIP 名称: scan1, IP: /racnode-cluster-scan/10.236.101.234
15.VIP各个节点的状态以及配置
[grid@racnode1 ~]$ srvctl status vip -n racnode1
VIP racnode1-vip 已启用
VIP racnode1-vip 正在节点上运行: racnode1
[grid@racnode1 ~]$ srvctl status vip -n racnode2
VIP racnode2-vip 已启用
VIP racnode2-vip 正在节点上运行: racnode2
[grid@racnode1 ~]$ srvctl config vip -n racnode1
VIP 已存在。:racnode1
VIP 已存在。: /racnode1-vip/10.236.101.232/255.255.255.0/eth0
[grid@racnode1 ~]$ srvctl config vip -n racnode2
VIP 已存在。:racnode2
VIP 已存在。: /racnode2-vip/10.236.101.233/255.255.255.0/eth0
16.验证所有集群节点间的时钟同步
[grid@racnode1 ~]$ cluvfy comp clocksync -verbose
验证 各集群节点上的时钟同步
正在检查是否在所有节点上安装了集群件...
集群件的安装检查通过
正在检查 CTSS 资源是否在所有节点上运行...
检查: CTSS 资源是否正在所有节点上运行
节点名 状态
------------------------------------ ------------------------
racnode1 通过
结果:CTSS 资源检查通过
正在查询所有节点上时间偏移量的 CTSS...
结果:时间偏移量的 CTSS 查询通过
检查 CTSS 状态已启动...
检查: CTSS 状态
节点名 状态
------------------------------------ ------------------------
racnode1 活动
CTSS 处于活动状态。正在继续检查所有节点上的时钟时间偏移量...
引用时间偏移量限制: 1000.0 毫秒
检查: 引用时间偏移量
节点名 时间偏移量 状态
------------ ------------------------ ------------------------
racnode1 0.0 通过
以下节点集的时间偏移量在指定的限制之内:
"[racnode1]"
结果:时钟时间偏移量检查通过
Oracle 集群时间同步服务检查已通过
各集群节点上的时钟同步 的验证成功。
三、用SQL查看状态
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;
2.所有数据库文件及它们所在的 ASM 磁盘组
SQL> select name from v$datafile union select member from v$logfile union select name from v$controlfile union select name from v$tempfile;
NAME
--------------------------------------------------------
+FRA/racdb/controlfile/current.256.949053765
+FRA/racdb/onlinelog/group_1.257.949053775
+FRA/racdb/onlinelog/group_2.258.949053785
+FRA/racdb/onlinelog/group_3.259.949064369
+FRA/racdb/onlinelog/group_4.260.949064379
+RACDB_DATA/racdb/controlfile/current.256.949053757
+RACDB_DATA/racdb/datafile/rac_data1.dbf
+RACDB_DATA/racdb/datafile/rac_data2.dbf
+RACDB_DATA/racdb/datafile/sysaux.260.949053881
+RACDB_DATA/racdb/datafile/system.259.949053795
+RACDB_DATA/racdb/datafile/undotbs1.261.949053941
+RACDB_DATA/racdb/datafile/undotbs2.263.949054029
+RACDB_DATA/racdb/datafile/users.264.949054051
+RACDB_DATA/racdb/onlinelog/group_1.257.949053771
+RACDB_DATA/racdb/onlinelog/group_2.258.949053781
+RACDB_DATA/racdb/onlinelog/group_3.265.949064363
+RACDB_DATA/racdb/onlinelog/group_4.266.949064373
+RACDB_DATA/racdb/tempfile/rac_temp1.dbf
+RACDB_DATA/racdb/tempfile/temp.262.949053963
19 rows selected.
3.ASM 磁盘卷
SQL> SELECT path FROM v$asm_disk;
PATH
--------------------------------------------------------------------------------
ORCL:CRSVOL1
ORCL:DATAVOL1
ORCL:FRAVOL1
查看11g 数据库实例的alert log及trace
数据库alert日志的路径在：
[oracle@racnode1 ~]$ more /u01/app/oracle/diag/rdbms/racdb/racdb1/trace/alert_racdb1.log
查看RAC 11g 集群log及trace
grid的日志在：
[grid@racnode1 ~]$ cd /u01/app/11.2.0/grid/log/racnode1
[grid@racnode1 racnode1]$ ls
admin/ agent/
alertracnode1.log client/ crsd/ cssd/ ctssd/ diskmon/ evmd/ gipcd/ gnsd/ gpnpd/ mdnsd/ ohasd/ racg/ srvm/
[grid@racnode1 racnode1]$ cd crsd
[grid@racnode1 crsd]$ ls
crsd.l01 crsd.l02 crsd.l03 crsd.l04
crsd.log crsdOUT.log crsd.trc
[grid@racnode1 crsd]$ cat crsd.log |more
Oracle Database 11g Clusterware Release 11.2.0.1.0 - Production Copyright 1996, 2009 Oracle. All rights reserved.
2017-08-07 10:10:08.735: [UiServer][1516341568] Sending message to PE. ctx= 0x2aaaac09be60
2017-08-07 10:10:08.736: [ CRSCCL][1484839232]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 595 msglen = 1160 clschdr.size_clscmsgh= 1248 src= (1, 805586624) dest= (2, 4294883590)
2017-08-07 10:10:08.742: [ CRSCCL][1474349376]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 603 msglen = 828 clschdr.size_clscmsgh= 916 src= (2, 4294883590) dest= (1, 805586624)
2017-08-07 10:10:08.743: [UiServer][1516341568] Done for ctx=0x2aaaac09be60
2017-08-07 10:10:08.982: [ OCRUTL][1285531968]u_freem: mem passed is null
2017-08-07 10:10:51.772: [UiServer][1518442816] S(0x2aaaac057740): set Properties ( grid,0x3f2dc40)
2017-08-07 10:10:51.783: [UiServer][1516341568] processMessage called
2017-08-07 10:10:51.783: [UiServer][1516341568] Sending message to PE. ctx= 0x2aaaac06bf20
2017-08-07 10:10:51.786: [ CRSCCL][1484839232]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 596 msglen = 1116 clschdr.size_clscmsgh= 1204 src= (1, 805586624) dest= (2, 4294883590)
2017-08-07 10:10:51.791: [ CRSCCL][1474349376]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 604 msglen = 825 clschdr.size_clscmsgh= 913 src= (2, 4294883590) dest= (1, 805586624)
2017-08-07 10:10:51.793: [UiServer][1516341568] Done for ctx=0x2aaaac06bf20
2017-08-07 10:10:51.809: [UiServer][1518442816] S(0x2aaaac050f30): set Properties ( grid,0x3f2dc40)
2017-08-07 10:10:51.820: [UiServer][1516341568] processMessage called
2017-08-07 10:10:51.820: [UiServer][1516341568] Sending message to PE. ctx= 0x2aaaac06cce0
2017-08-07 10:10:51.831: [ CRSCCL][1484839232]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 597 msglen = 1127 clschdr.size_clscmsgh= 1215 src= (1, 805586624) dest= (2, 4294883590)
2017-08-07 10:10:51.836: [ CRSCCL][1474349376]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 605 msglen = 828 clschdr.size_clscmsgh= 916 src= (2, 4294883590) dest= (1, 805586624)
2017-08-07 10:10:51.837: [UiServer][1516341568] Done for ctx=0x2aaaac06cce0
2017-08-07 10:10:51.853: [UiServer][1518442816] S(0x2aaaac0572e0): set Properties ( grid,0x3f1ff20)
2017-08-07 10:10:51.881: [UiServer][1516341568] processMessage called
2017-08-07 10:10:51.881: [UiServer][1516341568] Sending message to PE. ctx= 0x2aaaac086eb0
2017-08-07 10:10:51.885: [ CRSCCL][1484839232]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 598 msglen = 1116 clschdr.size_clscmsgh= 1204 src= (1, 805586624) dest= (2, 4294883590)
2017-08-07 10:10:51.890: [ CRSCCL][1474349376]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 606 msglen = 825 clschdr.size_clscmsgh= 913 src= (2, 4294883590) dest= (1, 805586624)
2017-08-07 10:10:51.891: [UiServer][1516341568] Done for ctx=0x2aaaac086eb0
2017-08-07 10:10:51.906: [UiServer][1518442816] S(0x2aaaac050ad0): set Properties ( grid,0x3f2dc40)
2017-08-07 10:10:51.918: [UiServer][1516341568] processMessage called
2017-08-07 10:10:51.919: [UiServer][1516341568] Sending message to PE. ctx= 0x2aaaac09be30
2017-08-07 10:10:51.971: [ CRSCCL][1484839232]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 599 msglen = 1118 clschdr.size_clscmsgh= 1206 src= (1, 805586624) dest= (2, 4294883590)
2017-08-07 10:10:51.976: [ CRSCCL][1474349376]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 607 msglen = 848 clschdr.size_clscmsgh= 936 src= (2, 4294883590) dest= (1, 805586624)
2017-08-07 10:10:51.977: [UiServer][1516341568] Done for ctx=0x2aaaac09be30
2017-08-07 10:10:52.012: [UiServer][1518442816] S(0x2aaaac064030): set Properties ( grid,0x3f2dc40)
2017-08-07 10:10:52.024: [UiServer][1516341568] processMessage called
2017-08-07 10:10:52.024: [UiServer][1516341568] Sending message to PE. ctx= 0x2aaaac06bf40
2017-08-07 10:10:52.031: [ CRSCCL][1484839232]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 600 msglen = 1125 clschdr.size_clscmsgh= 1213 src= (1, 805586624) dest= (2, 4294883590)
2017-08-07 10:10:52.091: [ CRSCCL][1474349376]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 608 msglen = 830 clschdr.size_clscmsgh= 918 src= (2, 4294883590) dest= (1, 805586624)
2017-08-07 10:10:52.092: [UiServer][1516341568] Done for ctx=0x2aaaac06bf40
2017-08-07 10:10:52.254: [UiServer][1518442816] S(0x2aaaac068cf0): set Properties ( grid,0x3f2dc40)
[grid@racnode1 ~]$ cd /u01/app/11.2.0/grid/log/diag/tnslsnr/racnode1/listener_scan1/trace
[grid@racnode1 trace]$ ls
listener_scan1.log
[grid@racnode1 trace]$ cat listener_scan1.log|more
Tue Jul 11 08:56:49 2017
Create Relation ADR_CONTROL
Create Relation ADR_INVALIDATION
Create Relation INC_METER_IMPT_DEF
Create Relation INC_METER_PK_IMPTS
系统参数文件为/u01/app/11.2.0/grid/network/admin/listener.ora
写入/u01/app/11.2.0/grid/log/diag/tnslsnr/racnode1/listener_scan1/alert/log.xml的日志信息
写入/u01/app/11.2.0/grid/log/diag/tnslsnr/racnode1/listener_scan1/trace/ora_5279_47079032759072.trc的跟踪信息
跟踪级别当前为0
以 pid=5279 开始
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
11-7月 -2017 08:56:53 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
11-7月 -2017 08:56:54 * version * 0
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.236.101.234)(PORT=1521)))
11-7月 -2017 08:56:54 * service_register * LsnrAgt * 0
11-7月 -2017 08:56:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
Tue Jul 11 08:57:54 2017
11-7月 -2017 08:57:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
Tue Jul 11 08:58:54 2017
11-7月 -2017 08:58:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
Tue Jul 11 08:59:54 2017
11-7月 -2017 08:59:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
Tue Jul 11 09:00:54 2017
11-7月 -2017 09:00:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
Tue Jul 11 09:01:54 2017
11-7月 -2017 09:01:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
Tue Jul 11 09:02:54 2017
11-7月 -2017 09:02:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
Tue Jul 11 09:03:54 2017
11-7月 -2017 09:03:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
Tue Jul 11 09:04:54 2017
11-7月 -2017 09:04:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
Tue Jul 11 09:05:54 2017
11-7月 -2017 09:05:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
Tue Jul 11 09:06:54 2017
11-7月 -2017 09:06:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
Tue Jul 11 09:07:54 2017
11-7月 -2017 09:07:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=racnode1)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186646784)) * status * 0
四、RAC上的数据库运维
1.创建表空间及增加数据文件
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
UNDOTBS2
USERS
RAC_DATA
RAC_TEMP
8 rows selected.
SQL> select name from v$datafile union select member from v$logfile union select name from v$controlfile union select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
+FRA/racdb/controlfile/current.256.949053765
+FRA/racdb/onlinelog/group_1.257.949053775
+FRA/racdb/onlinelog/group_2.258.949053785
+FRA/racdb/onlinelog/group_3.259.949064369
+FRA/racdb/onlinelog/group_4.260.949064379
+RACDB_DATA/racdb/controlfile/current.256.949053757
+RACDB_DATA/racdb/datafile/rac_data1.dbf
+RACDB_DATA/racdb/datafile/rac_data2.dbf
+RACDB_DATA/racdb/datafile/sysaux.260.949053881
+RACDB_DATA/racdb/datafile/system.259.949053795
+RACDB_DATA/racdb/datafile/undotbs1.261.949053941
+RACDB_DATA/racdb/datafile/undotbs2.263.949054029
+RACDB_DATA/racdb/datafile/users.264.949054051
+RACDB_DATA/racdb/onlinelog/group_1.257.949053771
+RACDB_DATA/racdb/onlinelog/group_2.258.949053781
+RACDB_DATA/racdb/onlinelog/group_3.265.949064363
+RACDB_DATA/racdb/onlinelog/group_4.266.949064373
+RACDB_DATA/racdb/tempfile/rac_temp1.dbf
+RACDB_DATA/racdb/tempfile/temp.262.949053963
19 rows selected.
[grid@racnode1 ]$ asmcmd
ASMCMD> pwd
+
ASMCMD> ls
CRS/
FRA/
RACDB_DATA/
ASMCMD> cd +RACDB_DATA/racdb/datafile/
ASMCMD> pwd
+RACDB_DATA/racdb/datafile
ASMCMD> ls
RAC_DATA.268.950270625
RAC_DATA.269.950274149
SYSAUX.260.949053881
SYSTEM.259.949053795
UNDOTBS1.261.949053941
UNDOTBS2.263.949054029
USERS.264.949054051
rac_data1.dbf
rac_data2.dbf
ASMCMD>
ASMCMD> ls -ls
Type Redund Striped Time Sys Block_Size Blocks Bytes Space Name
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 2621441 21474844672 21476933632 RAC_DATA.268.950270625
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 2621441 21474844672 21476933632 RAC_DATA.269.950274149
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 147201 1205870592 1207959552 SYSAUX.260.949053881
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 90881 744497152 746586112 SYSTEM.259.949053795
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 41601 340795392 342884352 UNDOTBS1.261.949053941
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 25601 209723392 211812352 UNDOTBS2.263.949054029
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 641 5251072 6291456 USERS.264.949054051
N rac_data1.dbf => +RACDB_DATA/RACDB/DATAFILE/RAC_DATA.268.950270625
N rac_data2.dbf => +RACDB_DATA/RACDB/DATAFILE/RAC_DATA.269.950274149
ASMCMD> exit
[oracle@racnode1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 7 17:27:46 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> alter tablespace RAC_DATA add datafile '+RACDB_DATA/racdb/datafile/rac_data3.dbf' size 20G ;
Tablespace altered.
[grid@racnode1 trace]$ asmcmd
ASMCMD> pwd
+
ASMCMD> cd +RACDB_DATA/racdb/datafile/
ASMCMD> ls -ls
Type Redund Striped Time Sys Block_Size Blocks Bytes Space Name
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 2621441 21474844672 21476933632 RAC_DATA.268.950270625
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 2621441 21474844672 21476933632 RAC_DATA.269.950274149
DATAFILE UNPROT COARSE AUG 07 17:00:00 Y 8192 2621441 21474844672 21476933632 RAC_DATA.271.951411029
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 147201 1205870592 1207959552 SYSAUX.260.949053881
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 90881 744497152 746586112 SYSTEM.259.949053795
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 41601 340795392 342884352 UNDOTBS1.261.949053941
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 25601 209723392 211812352 UNDOTBS2.263.949054029
DATAFILE UNPROT COARSE AUG 07 11:00:00 Y 8192 641 5251072 6291456 USERS.264.949054051
N rac_data1.dbf => +RACDB_DATA/RACDB/DATAFILE/RAC_DATA.268.950270625
N rac_data2.dbf => +RACDB_DATA/RACDB/DATAFILE/RAC_DATA.269.950274149
N rac_data3.dbf => +RACDB_DATA/RACDB/DATAFILE/RAC_DATA.271.951411029
ASMCMD> ls
RAC_DATA.268.950270625
RAC_DATA.269.950274149
RAC_DATA.271.951411029
SYSAUX.260.949053881
SYSTEM.259.949053795
UNDOTBS1.261.949053941
UNDOTBS2.263.949054029
USERS.264.949054051
rac_data1.dbf
rac_data2.dbf
rac_data3.dbf
ASMCMD>
SQL> create tablespace RAC_DATA datafile '+RACDB_DATA/racdb/datafile/rac_data1.dbf' size 20G ;