Oracle RAC日常管理命令(四)
ecords in表决磁盘中的记录数
208864+0 records out
106938368 bytes (107 MB) copied, 104.614 seconds, 1.0 MB/s
[root@rac1 oracle]# ll
total 104644
drwxr-xr-x 3 oracle oinstall 4096 Jul 5 2013 Desktop
-rw-r--r-- 1 root root 97517 Jul 4 17:57 ocr_bk.dmp
-rw-r--r-- 1 root root 106938368 Jul 4 18:37voting_disk.bak
[root@rac1 oracle]# du -sm voting_disk.bak备份文件103MB
103 voting_disk.bak
(3)恢复votedisk盘
[root@rac1 oracle]# dd if=/home/oracle/voting_disk.bak of=/dev/raw/raw2
使用上述命令即可恢复表决磁盘,由于我们的表决磁盘是正常状态,因此不做恢复演示
(4)通过strings命令查看votedisk内容
[root@rac1 oracle]# strings voting_disk.bak |sort -u
fSLC
ssLckcoT
SslcLlik
sSlcrEp0
}|{z
srvctl是应用层命令,称作“服务管理工具”可以操作database;instance;listener;nodes;ASM;service;application
,其中application又包括“GSD ONS VIP”,这些资源都可以通过srvctl工具统一管理。
演示
(1)关闭节点1的RAC实例
RACDB1@rac1 /home/oracle$ srvctl stop instance -d racdb -i racdb1 -o immediate
RACDB1@rac1 /home/oracle$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application OFFLINE OFFLINE
ora....B2.inst application ONLINE ONLINE rac2
ora....DB1.srv application ONLINE ONLINE rac2
ora.....TAF.cs application ONLINE ONLINE rac2
ora.RACDB.db application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
节点2还是可以正常登陆数据库
RACDB2@rac2 /home/oracle$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 4 19:39:02 2013
Copyright (c) 1982, 2005,
Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL>
(2)关闭节点2的RAC实例,当srvctl监测到RAC集群的所有实例都关闭后会自动关闭数据库
RAC
DB2@rac2 /home/oracle$ srvctl stop instance -d racdb -i racdb2 -o immediate
RACDB2@rac2 /home/oracle$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application OFFLINE OFFLINE
ora....B2.inst application OFFLINE OFFLINE
ora....DB1.srv application OFFLINE OFFLINE
ora.....TAF.cs application OFFLINE OFFLINE
ora.RACDB.db application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
但ASM实例还在启动状态,监听lsnr也在启动状态,application进程也在启动状态
RACDB2@rac2 /home/oracle$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 4 19:45:15