测试11G Oracle Restart能否自动启动被杀掉的组件(二)
om Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options
=再次测试Oracle Restart能否自动启动被杀掉的组件= [html] [oracle@oracle11g ~]$ ps -ef |grep ora_lgwr_orcl oracle 11287 1 0 10:42 00:00:00 ora_lgwr_orcl oracle 11696 8813 0 10:44 pts/1 00:00:00 grep ora_lgwr_orcl [oracle@oracle11g ~]$ kill -9 11287 [oracle@oracle11g ~]$ ps -ef |grep ora_lgwr_orcl oracle 11700 8813 0 10:45 pts/1 00:00:00 grep ora_lgwr_orcl
=发现不会再次重启,手工重启数据库= [html] oracle@oracle11g ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 19 10:46:04 2012Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> startup [html] ORACLE instance started. Total System Global Area 521936896 bytes Fixed Size 2229944 bytes Variable Size 352323912 bytes Database Buffers 163577856 bytes Redo Buffers 3805184 bytes Database mounted. Database opened. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Automatic Storage Management, OLAP, Data Miningand Real Application Testing options
=使用EM将orcl数据库实例加回到Oracle Restart配置里,如果发现页面上仍旧是Enabled则只能手工添加= [html] [oracle@oracle11g ~]$ srvctl add database -d orcl -o /u01/app/oracle/acfsmounts/acfs_db1/dbhome_1 [oracle@oracle11g ~]$ srvctl config database -d orcl Database unique name: orcl Database name: Oracle home: /u01/app/oracle/acfsmounts/acfs_db1/dbhome_1 Oracle user: oracle Spfile: Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Database instance: orcl Disk Groups: Services: [oracle@oracle11g ~]$ srvctl status database -d orcl Database is not running. [oracle@oracle11g ~]$ srvctl start database -d orcl [oracle@oracle11g ~]$ srvctl status database -d orcl Database is running. [oracle@oracle11g ~]$ srvctl config database -d orcl Database unique name: orcl Database name: Oracle home: /u01/app/oracle/acfsmounts/acfs_db1/dbhome_1 Oracle user: oracle Spfile: Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Database instance: orcl Disk Groups: Services: [oracle@oracle11g ~]$ srvctl modify database -d orcl -n orcl -p +DATA/orcl/spfileorcl.ora -a DATA,FRA [oracle@oracle11g ~]$ srvctl config database -d orcl Database unique name: orcl Database name: orcl Oracle home: /u01/app/oracle/acfsmounts/acfs_db1/dbhome_1 Oracle user: oracle Spfile: +DATA/orcl/spfileorcl.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Database instance: orcl Disk Groups: DATA,FRA Services:
=确认orcl数据库实例是否添加到Oracle Restart成功=
[html]
[oracle@oracle11g ~]$ ps -ef |grep ora_lgwr_orcl
oracle 17276 1 0 11:05 00:00:00 ora_lgwr_orcl
oracle 25574 8813 0 11:14 pts/1 00:00:00 grep ora_lgwr_orcl
[oracle@oracle11g ~]$ kill -9 17276
[oracle@oracle11g ~]$ ps -ef |grep ora_lgwr_orcl
oracle 26107 8813 0 11:14 pts/1 00:00:00 grep ora_lgwr_orcl
[oracle@oracle11g ~]$ ps -ef |grep ora_lgwr_orcl
oracle 26952 1 0 11:15 00:00:00 ora_lgwr_orcl
oracle 27282 8813 0 11: