Oracle_11g_RAC数据库维护手册-v01

11gr1RAC数据库维护手册目录11gr1RAC数据库维护手册...........................................................................................................2一、运行状态查询...........................................................................................................................2二、启动关闭...................................................................................................................................2三、OEM启动关闭.........................................................................................................................3四、RAC集群日志查看.................................................................................................................4五、RAC数据库日志查看.............................................................................................................4六、操作系统日志查看...................................................................................................................411gr1RAC数据库维护手册一、运行状态查询以下命令以oracle用户执行。1、查看RAC集群运行状态crs_stat–t返回结果都为“ONLINE”表示正常。2、查看RAC数据库运行状态srvctlstatusdatabase-dracdb3、查看RAC注册表磁盘状态ocrcheck4、查看RAC仲裁盘状态crsctlquerycssvotedisk5、查看监听运行状态lsnrctlstatus二、启动关闭以下命令以oracle用户执行。1、启动CRScrs_start-all2、关闭CRScrs_stop-all3、启动RAC数据库srvctlstartdatabase-dracdb4、关闭RAC数据库srvctlstopdatabase-dracdb5、启动RAC数据库实例srvctlstartinstance-dracdb-iracdb1或srvctlstartinstance-dracdb-iracdb26、关闭RAC数据库实例srvctlstopinstance-dracdb-iracdb1或srvctlstopinstance-dracdb-iracdb2三、OEM启动关闭以下命令以oracle用户执行。1、查看EM运行状态emctlstatusdbconsole2、启动EMemctlstartdbconsole3、关闭EMemctlstopdbconsole四、RAC集群日志查看RAC集群日志位置：/opt/crs/log重点查看alert*.log、ocssd.log、crsd.log日志。五、RAC数据库日志查看实例racdb1alert日志位置：/opt/oracle/diag/rdbms/racdb/racdb1/trace/alert_racdb1.log实例racdb2alert日志位置：/opt/oracle/diag/rdbms/racdb/racdb2/trace/alert_racdb2.log六、操作系统日志查看操作系统日志位置：/var/adm/message*