测试11G Oracle Restart能否自动启动被杀掉的组件(二)

2014-11-24 09:48:19 · 作者: · 浏览: 10
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: