半瓶内容

 results 1 - 1 of about 1 for 记录一下关小机和Oracle RAC的步骤. (0.366 seconds) 

记录一下关小机和Oracle RAC的步骤

简单记录一下停机维护的步骤:

先停数据库连接,一般关闭应用
进行数据库全库或日志备份,AIX操作系统根据情况看是否要备份。
以root用户登录,停止ORACLE资源,执行以下脚本:
su - oracle
emctl stop dbconsole   #停止EM
sqlplus / as sysdba后shutdown immediate 数据库,切记全部执行正常!
srvctl stop nodeapps -n p5a1 #关闭oracle vip,gsd,listen等资源
crs_stat -t   #查看各节点crs资源是否OFF
exit
/etc/init.crs stop  #停CRS
停止AIX hacmp系统
以root用户登录,执行#smitty clstop命令,出现选择画面后,按回车执行
如果是启动hacmp则是#smitty clstart命令
应用系统完全停止后,才能shutdown操作系统。
以root用户登录,执行#shutdown -F命令关闭系统,
如果是要重启执行则执行#shutdown –Fr命令。

p5b1@/#su - oracle
ERPDB2@/home/oracle>emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0 
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
http://p5a1:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
 ...  Stopped.
ERPDB2@/home/oracle>sqlplus " / as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Jul 17 22:11:12 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ERPDB2@/home/oracle>srvctl stop nodeapps -n p5b1
ERPDB2@/home/oracle>crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora....b1.inst application    OFFLINE   OFFLINE              
ora....b2.inst application    OFFLINE   OFFLINE              
ora....rpdb.db application    OFFLINE   OFFLINE              
ora....A1.lsnr application    OFFLINE   OFFLINE              
ora.p5a1.gsd   application    OFFLINE   OFFLINE              
ora.p5a1.ons   application    OFFLINE   OFFLINE              
ora.p5a1.vip   application    OFFLINE   OFFLINE              
ora....B1.lsnr application    OFFLINE   OFFLINE              
ora.p5b1.gsd   application    OFFLINE   OFFLINE              
ora.p5b1.ons   application    OFFLINE   OFFLINE              
ora.p5b1.vip   application    OFFLINE   OFFLINE              
ERPDB2@/home/oracle>exit
p5b1@/#/etc/init.crs stop
Shutting down Oracle Cluster Ready Services (CRS):
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
p5b1@/#smitty clstop

* Stop now, on system restart or both                 now                                                                        +
  Stop Cluster Services on these nodes               [p5b1]                                                                      +
  BROADCAST cluster shutdown?                         true

Broadcast message from root@p5b1 (tty) at 22:14:37 ...

HACMP/ES for AIX on p5b1 shutting down.
Please exit any cluster applications...

p5b1@/#shutdown -F

SHUTDOWN PROGRAM
Fri Jul 17 22:14:59 BEIST 2009
Shutting down Oracle Cluster Ready Services (CRS):
Stopping resources.
Error while stopping resources. Possible cause: CRSD is down.
Stopping CSSD.
Unable to communicate with the CSS daemon.
Shutdown has begun. The daemons should exit soon.
0513-044 The radiusd Subsystem was requested to stop.

Wait for '....Halt completed....' before stopping.
Dead Man Switch Disabled
Jul 17 2009 22:15:19 /usr/es/sbin/cluster/utilities/clstop: called with flags -f -y -s -N -S

Error reporting has stopped.
Advanced Accounting has stopped...
Process accounting has stopped.
nfs_clean: Stopping NFS/NIS Daemons
0513-004 The Subsystem or Group, nfsd, is currently inoperative.
0513-044 The biod Subsystem was requested to stop.
0513-044 The rpc.lockd Subsystem was requested to stop.
0513-044 The rpc.statd Subsystem was requested to stop.
0513-004 The Subsystem or Group, gssd, is currently inoperative.
0513-004 The Subsystem or Group, nfsrgyd, is currently inoperative.
0513-004 The Subsystem or Group, rpc.mountd, is currently inoperative.
0513-004 The Subsystem or Group, ypserv, is currently inoperative.
0513-004 The Subsystem or Group, ypbind, is currently inoperative.
0513-004 The Subsystem or Group, yppasswdd, is currently inoperative.
0513-004 The Subsystem or Group, ypupdated, is currently inoperative.
0513-004 The Subsystem or Group, nis_cachemgr, is currently inoperative.
0513-004 The Subsystem or Group, rpc.nisd, is currently inoperative.
0513-004 The Subsystem or Group, rpc.nispasswdd, is currently inoperative.
0513-044 The aixmibd Subsystem was requested to stop.
0513-044 The hostmibd Subsystem was requested to stop.
0513-044 The muxatmd Subsystem was requested to stop.
0513-044 The qdaemon Subsystem was requested to stop.
0513-044 The writesrv Subsystem was requested to stop.
0513-044 The ctrmc Subsystem was requested to stop.
0513-044 The clcomdES Subsystem was requested to stop.
0513-044 The IBM.ServiceRM Subsystem was requested to stop.
0513-044 The IBM.ERRM Subsystem was requested to stop.
0513-044 The IBM.AuditRM Subsystem was requested to stop.
0513-044 The IBM.HostRM Subsystem was requested to stop.
All processes currently running will now be killed...
Unmounting the file systems...


Leave a Comment