Oracle11g RAC集群启动关闭管理

最新推荐文章于 2024-07-11 22:47:10 发布

脚灬印

最新推荐文章于 2024-07-11 22:47:10 发布

阅读量9.6k

点赞数 1

分类专栏： Oracle 文章标签： oracle oracle 11g 集群

本文链接：https://blog.csdn.net/lt53130640688/article/details/49658465

版权

本文档介绍了Oracle11g RAC集群的简单启动和关闭管理，包括切换到集群用户grid，检查资源状态，以及详细阐述了关闭和启动服务器的步骤。

摘要由CSDN通过智能技术生成

简单的Oracle11g RAC集群启动关闭管理

1.切换到集群用户grid

[root@rac1 ~]# su - grid

2.查看集群资源状态（ora.gsd 11G不使用此资源所以OFFLINE为正常状态）

[grid@rac1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
ora.CRSDG.dg   ora....up.type ONLINE    ONLINE    rac1        
ora.DATADG.dg  ora....up.type ONLINE    ONLINE    rac1        
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac2        
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1        
ora.bnuoa.db   ora....se.type ONLINE    ONLINE    rac1        
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac2        
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    rac1        
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac2        
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1        
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    OFFLINE   OFFLINE               
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1        
ora....SM2.asm application    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    OFFLINE   OFFLINE               
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2        
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1        
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac2

3.关闭服务器步骤

（1）关闭数据库（两个节点都要执行） ORACLE用户
-------第一节点
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ echo $ORACLE_SID
bnuoa1
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 20 09:59:29 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

-------第二节点
[oracle@rac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release