OracleracfailovertestOracle认证考试

文章作者 100test 发表时间 2009:08:09 16:36:41
来源 100Test.Com百考试题网

"gklt"> 　　oracle@orac-b:~>. sqlplus system/holeinone@rac
　　SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 12 20:08:00 2009
　　Copyright (c) 1982, 2005, Oracle. All rights reserved.
　　Connected to:
　　Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
　　With the Partitioning, Real Application Clusters, OLAP and Data Mining options
　　SQL>. 0select instance_name from gv$instance.
　　INSTANCE_NAME
　　----------------
　　rac1
　　rac2
　　SQL>. @checkracstat.sql.
　　INSTANCE_NAME HOST_NAME FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER
　　------------- --------- ------------- --------------- -----------
　　rac1 orac-a
　　 NONE NONE NO
　　SQL>. exit
　　Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
　　With the Partitioning, Real Application Clusters, OLAP and Data Mining options
　　oracle@orac-b:~>. srvctl status database -d rac
　　Instance rac1 is running on node orac-a
　　Instance rac2 is running on node orac-b
　　oracle@orac-b:~>. srvctl stop instance -d rac -i rac1 -o abort
　　oracle@orac-b:~>. srvctl status database -d rac
　　Instance rac1 is not running on node orac-a
　　Instance rac2 is running on node orac-b
　　oracle@orac-b:~>. sqlplus system/holeinone@rac
　　SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 12 20:10:16 2009
　　Copyright (c) 1982, 2005, Oracle. All rights reserved.
　　Connected to:
　　Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
　　With the Partitioning, Real Application Clusters, OLAP and Data Mining options
　　SQL>. 0select instance_name from gv$instance.
　　SQL>. @checkracstat.sql.
　　INSTANCE_NAME HOST_NAME FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER
　　------------- --------- ------------- --------------- -----------
　　rac2 orac-b
　　 NONE NONE NO
　　SQL>.
　　checkracstat.sql
　　# more checkracstat.sql
　　COL instance_name FORMAT a13.
　　COL host_name FORMAT a9.
　　COL failover_method FORMAT a15.
　　COL failed_over FORMAT a11.
　　SELECT instance_name,host_name,
　　NULL AS failover_type,NULL AS failover_method,
　　NULL AS failed_over
　　FROM v$instance
　　UNION
　　SELECT NULL,NULL,failover_type,failover_method,failed_over
　　FROM v$session
　　WHERE username = SYSTEM.

　　编辑特别推荐:

　　oracle认证考试费用

　　Oracle的入门心得