移动ndmc系统ndmcdb01和ndmcdb02数据库vcs健康检查报告

1、1.介对目范1.介对目范术结2.客户环3.VCS 健康检查项License Key检GAB port检VCS心跳网络检VCS日志检VCSCluster节点及ServiceGroup运行状态检VCS进程检4.结1对本文档是用来辅助 Symantec Business Critical Servi目1对本文档是用来辅助 Symantec Business Critical Servi目范术HighAlogicalofservers(nodes)providingfailoverVERITAS Cluster Server VERITAS File System Cluster Volume Man

2、ager Cluster File SystemVERITASStorageFoundationforRAC (包括VCSVXVM,支持Oracle结通过系列健康检查项目的成功完成，验证VCS 22系统健康检查时间：2014117symantec工程师用户工程师参加主机名操作系统版本管ORACLE 版3.VCS 3.1LicenseKey3.VCS 3.1LicenseKeyLicense Key License Key 后，一旦系统重启， VCS 进程将无法正常启动。在生产系统上，要避免使用DemoLicense.使用vxlicrep命令可以检查License的类型.以下检查结果：VERIT

3、ASClusterServer 的Licensekey3.2GABportVCS gabconfig a 主机上运行了那些模块，以下是gabconfig aVCS cluster VCS 跳网络是否正常, 检查输出如下ndmcdb01:#llts -nvv LLT node information:S e Link S us *0ndmcdb01 link1 UP 00:18:82:D9:41:4D link2 UP 00:18:82:D9:42:39 link3 UP 00:18:82:D9:42:381link1 UP 00:18:82:D3:D8:41 link2 UP 00:18:82

4、:D3:D8:A9 link3 UP 00:18:82:D3:D8:A9ndmcdb01:#gabconfig-a GAB Port MembershipsPort a gen32c802membership01 Porth32c80bmembershipProduct=VERITASClusterLicense=3.4VCS日志检查 VCS 的日志文件， 察看近期是否有异常/var/VRTSvcs/log/engine_A.log3.4VCS日志检查 VCS 的日志文件， 察看近期是否有异常/var/VRTSvcs/log/engine_A.log ， 信息。VCS 日志文件是的 检查结果：

5、VCS日誌近期无异信息,11月29日系统做了一次切换，直至目系统运行正常3.5VCSClusterServiceGroup检2个节点的VCS运行状态以及所有的ServiceGroupndmcdb01:#us-SYSTEM- A A 2013/12/2401:42:21VCSINFOV-16-1-10463Sendingsnapshottonode:2013/12/24 01:42:21 VCS INFO V-16-1-10297 Resourerviceip (Owner: unknown, Group: RCS_DB_SG) is online on ndmcdb01 (2013/12/24

6、 01:42:21 VCS NOTICE V-16-1-10233 Clearing Restartribute fRCS_DB_SG on all nodes2013/12/2401:42:22VCSNOTICEV-16-1-10322Systemndmcdb02(Node1) changed e from REMOTE_BUILD to RUNNING2013/12/24 01:42:22 VCS INFO V-16-1-10304 Resourerviceip (Owner: unknown, Group: RCS_DB_SG) is offline on ndmcdb02 (2013/

7、12/2401:42:22VCSINFOV-16-1-10297ResourceDBVG(Owner:unknown,Group: RCS_DB_SG) is online on ndmcdb01 (2013/12/24 01:42:22 VCS NOTICE V-16-1-10233 Clearing Restartribute fRCS_DB_SG on all nodes2013/12/24 01:42:23 VCS INFO V-16-1-10297 Resource LSNR_lsnr (Owner: unknown, Group: RCS_DB_SG) is online on n

8、dmcdb01 (2013/12/24 01:42:23 VCS NOTICE V-16-1-10233 Clearing Restartribute fRCS_DB_SG on all nodes2013/12/24 01:42:23 VCS INFO V-16-1-10304 Resource DBVG (Owner: unknown, Group: RCS_DB_SG) is offline on ndmcdb02 ( probe)2013/12/24 01:42:23 VCS INFO V-16-1-10304 Resource ORA_SRV (Owner: unknown, Gro

9、up: RCS_DB_SG) is offline on ndmcdb02 ( probe)2013/12/24 01:42:23 VCS INFO V-16-1-10304 Resource LSNR_lsnr (Owner: unknown, Group: RCS_DB_SG) is offline on ndmcdb02 ( probe)2013/12/24 01:42:23 VCS NOTICE V-16-1-10438 Group RCS_DB_SG has been probed on system ndmcdb022013/12/24 01:42:23 VCS NOTICE V-

10、16-1-10439 Group (RCS_DB_SG) waiting to probe on all alive nodes in SystemList. Not initiating auto-start online of group on system ndmcdb02 aft robe2013/12/24 01:42:27 VCS INFO V-16-1-10297 Resource ORA_SRV (Owner: unknown, Group: RCS_DB_SG) is online on ndmcdb01 ( probe)2013/12/24 01:42:27 VCS NOT

11、ICE V-16-1-10233 ClearingRestar tributef roup RCS_DB_SG on all nodes2013/12/24 01:42:27 VCS NOTICE V-16-1-10438 Group RCS_DB_SG has been probed on system ndmcdb012013/12/24 01:42:27 VCS NOTICE V-16-1-10447 Group RCS_DB_SG is online on system 从以上输出可以看出，ndmcdb01ndmcdb02Cluster 集群内，运行状态正常，都为 RUNNING 状态

12、；各个服务组状态正常。主要检查进程had从以上输出可以看出，ndmcdb01ndmcdb02Cluster 集群内，运行状态正常，都为 RUNNING 状态；各个服务组状态正常。主要检查进程had和hashadow检查结果：had和hadshadow3.7 VCS 配置文件的一致性检查VCS/etc/VRTSvcs/conf/config/main.cf检查结果：VCS的配置文件main.cfndmcdb01:#cat/etc/VRTSvcs/conf/config/main.cf include types.cfincludeclusterndmcdbC1UserNames=admin=aj

13、kCjeJgkFkkIskEjh Administrators = admin )systemndmcdb01ShutdownTimeout=)systemndmcdb02ShutdownTimeout=)groupRCS_DB_SGSystemList=ndmcdb01=0,ndmcdb02=1 AutoStartList = ndmcdb01, ndmcdb02 ndmcdb01: # hacf -verify 1 0Nov2900:00:121 0Nov2900:00:00-GROUP- B B OnlineRetryLimit=)ApplicationDBVGUser= StartPr

14、ogram = /home/oracOnlineRetryLimit=)ApplicationDBVGUser= StartProgram = /home/oracStopProgram = /home/oracCleanProgram = /home/oracMonitorProgram = /home/orac)IPserviceipDevice=Address=NetMask=)NIC(Device=)( Owner=Home=TnsAdmin=/home/oracle/app/product/11g/db/network/admin Listener = LISTENERMonScri

15、pt=)OracleORA_SRVSid = ndmcdb Owner=oracleHome=Pfile=/home/oracle/app/product/11g/db/dbs/initndmcdb.ora EnvFile = /home/oracle/.bash_profileDetailMonitor=MonScript=/opt/VRTSvcs/bin/Oracle/SqlTest.pl User = vcsmonPword=cmiOpgDilIiiNqgMj Table = vcstest)LSNR_lsnrrequiresserviceip ORA_SRV requires DBVG ORA_SRV r