sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 故障案例 >

【案例】Oracle RAC环境asm和db实例无法启动的解决办法笔记

时间:2016-11-25 23:13   来源:Oracle研究中心   作者:网络   点击:

天萃荷净 Oracle研究中心案例分析:分享一篇关于Oracle RAC环境中关于ASM和DB实例无法启动的笔记,该笔记详细记录了无法启动解决办法。

本站文章除注明转载外,均为本站原创: 转载自love wife & love life —Roger 的Oracle技术博客
本文链接地址: oracle restart体验(续)

发现asm和db实例无法启动,如下:
[ora11g@11gr2test ~]$ crs_stat -t

Name           Type           Target    State     Host      
------------------------------------------------------------
ora.DATA1.dg   ora....up.type ONLINE    OFFLINE             
ora....ER.lsnr ora....er.type ONLINE    ONLINE    11gr2test 
ora.asm        ora.asm.type   ONLINE    ONLINE    11gr2test 
ora.cssd       ora.cssd.type  ONLINE    ONLINE    11gr2test 
ora.diskmon    ora....on.type ONLINE    ONLINE    11gr2test 
ora.evmd       ora.evm.type   ONLINE    ONLINE    11gr2test 
ora.ons        ora.ons.type   OFFLINE   OFFLINE             
ora.roger.db   ora....se.type ONLINE    OFFLINE

查看日志,发现如下内容:
2011-10-09 19:59:24.746: [ora.LISTENER.lsnr][3022314384] {0:0:2} [check] LsnrAgent::check }
2011-10-09 19:59:29.432: [    AGFW][3018111888] {0:0:92} Agent received the message: RESOURCE_START[ora.DATA1.dg 11gr2test 1] ID 4098:344
2011-10-09 19:59:29.432: [    AGFW][3018111888] {0:0:92} Preparing START command for: ora.DATA1.dg 11gr2test 1
2011-10-09 19:59:29.433: [    AGFW][3018111888] {0:0:92} ora.DATA1.dg 11gr2test 1 state changed from: OFFLINE to: STARTING
2011-10-09 19:59:29.437: [ora.DATA1.dg][3022314384] {0:0:92} [start] clsn_agent::start {
2011-10-09 19:59:29.438: [ora.DATA1.dg][3022314384] {0:0:92} [start] DgpAgent::start: enter {
2011-10-09 19:59:29.438: [ USRTHRD][3022314384] {0:0:92} ConnectionPool::~ConnectionPool m_oracleHome:/home/ora11g/11.2/grid, m_oracleSid:+ASM, m_usrOraEnv:
2011-10-09 19:59:29.438: [ora.DATA1.dg][3022314384] {0:0:92} [start] DgpAgent::getConnxn new pool
2011-10-09 19:59:29.438: [ora.DATA1.dg][3022314384] {0:0:92} [start] DgpAgent::getConnxn new pool m_oracleHome:/home/ora11g/11.2/grid m_oracleSid:+ASM m_usrOraEnv:
2011-10-09 19:59:29.438: [ora.DATA1.dg][3022314384] {0:0:92} [start] ConnectionPool::ConnectionPool 2 m_oracleHome:/home/ora11g/11.2/grid, m_oracleSid:+ASM, m_usrOraEnv:
2011-10-09 19:59:29.439: [ora.DATA1.dg][3022314384] {0:0:92} [start] ConnectionPool::getConnection 260 pConnxn 09a2b628
2011-10-09 19:59:29.439: [ora.DATA1.dg][3022314384] {0:0:92} [start] DgpAgent::getConnxn connected
2011-10-09 19:59:29.443: [ora.DATA1.dg][3022314384] {0:0:92} [start] InstConnection:connectInt:is up
2011-10-09 19:59:29.455: [ora.DATA1.dg][3022314384] {0:0:92} [start] DgpAgent::queryDgStatus no data found in v$asm_diskgroup_stat
2011-10-09 19:59:29.455: [ora.DATA1.dg][3022314384] {0:0:92} [start] DgpAgent::runCheck:clsagfw_res_status 1
2011-10-09 19:59:29.456: [ora.DATA1.dg][3022314384] {0:0:92} [start] InstConnection:connectInt:is up
2011-10-09 19:59:29.552: [ora.DATA1.dg][3022314384] {0:0:92} [start] ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA1" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA1"

2011-10-09 19:59:29.552: [ora.DATA1.dg][3022314384] {0:0:92} [start] ConnectionPool::releaseConnection InstConnection 09a2b628
2011-10-09 19:59:29.553: [   AGENT][3022314384] {0:0:92} UserErrorException: Locale is
2011-10-09 19:59:29.554: [ora.DATA1.dg][3022314384] {0:0:92} [start] clsnUtils::error Exception type=2 string=
CRS-5017: The resource action "ora.DATA1.dg start" encountered the following error:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA1" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA1"

[ora11g@11gr2test ~]$ export ORACLE_SID=+ASM
[ora11g@11gr2test ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production ON Sun Oct 9 20:03:44 2011
Copyright (c) 1982, 2010, Oracle.  ALL rights reserved.
Connected TO an idle instance.

SQL> startup mount
ORA-32004: obsolete OR deprecated parameter(s) specified FOR ASM instance
ORA-01031: insufficient privileges

SQL> conn sys/roger AS sysdba
Connected TO an idle instance.

SQL> startup mount
ORA-32004: obsolete OR deprecated parameter(s) specified FOR ASM instance
ORA-01031: insufficient privileges

SQL> exit
Disconnected

[ora11g@11gr2test ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production ON Sun Oct 9 20:08:41 2011
Copyright (c) 1982, 2010, Oracle.  ALL rights reserved.
Connected TO an idle instance.

SQL> startup force       
ORA-32004: obsolete OR deprecated parameter(s) specified FOR ASM instance
ORA-01031: insufficient privileges

SQL> exit
Disconnected

[ora11g@11gr2test ~]$ pwd
/home/ora11g

[ora11g@11gr2test ~]$ export ORACLE_HOME=/home/ora11g/11.2/grid
[ora11g@11gr2test ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production ON Sun Oct 9 20:09:21 2011
Copyright (c) 1982, 2010, Oracle.  ALL rights reserved.

Connected TO:
Oracle DATABASE 11g Enterprise Edition Release 11.2.0.2.0 - Production
WITH the Automatic Storage Management OPTION

SQL> SHOW parameter asm

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups                       string
asm_diskstring                       string
asm_power_limit                      INTEGER     1
asm_preferred_read_failure_groups    string

SQL> SELECT * FROM v$asm_diskgroup_stat;
no ROWS selected

SQL> SHOW parameter spfile
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string

SQL> ALTER system SET asm_diskgroups='DATA1','DATA';
System altered.

SQL> SHOW parameter asm
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups                       string      DATA1, DATA
asm_diskstring                       string
asm_power_limit                      INTEGER     1
asm_preferred_read_failure_groups    string

SQL> ALTER system SET asm_diskstring='/dev/sdc','/dev/sdb','/dev/sdd';
System altered.

SQL> SELECT * FROM v$asm_diskgroup_stat;
no ROWS selected

SQL> SET LINESIZE  145
SQL> SET PAGESIZE  9999
SQL> SET VERIFY    off

SQL> COLUMN group_name             FORMAT a20           HEAD 'Disk Group|Name'
SQL> COLUMN sector_size            FORMAT 99,999        HEAD 'Sector|Size'
SQL> COLUMN block_size             FORMAT 99,999        HEAD 'Block|Size'
SQL> COLUMN allocation_unit_size   FORMAT 999,999,999   HEAD 'Allocation|Unit Size'
SQL> COLUMN state                  FORMAT a11           HEAD 'State'
SQL> COLUMN TYPE                   FORMAT a6            HEAD 'Type'
SQL> COLUMN total_mb               FORMAT 999,999,999   HEAD 'Total Size (MB)'
SQL> COLUMN used_mb                FORMAT 999,999,999   HEAD 'Used Size (MB)'
SQL> COLUMN pct_used               FORMAT 999.99        HEAD 'Pct. Used'

SQL> break ON report ON disk_group_name skip 1

SQL> compute SUM label "Grand Total: " OF total_mb used_mb ON report

SQL> SELECT
2      name                                     group_name
3    , sector_size                              sector_size
4    , block_size                               block_size
5    , allocation_unit_size                     allocation_unit_size
6    , state                                    state
7    , TYPE                                     TYPE
8    , total_mb                                 total_mb
9    , (total_mb - free_mb)                     used_mb
10    , ROUND((1- (free_mb / total_mb))*100, 2)  pct_used
11  FROM
12      v$asm_diskgroup
13  ORDER BY
14      name
15  /
, ROUND((1- (free_mb / total_mb))*100, 2)  pct_used
*
ERROR at line 10:
ORA-01476: divisor IS equal TO zero

SQL> exit

Disconnected FROM Oracle DATABASE 11g Enterprise Edition Release 11.2.0.2.0 - Production
WITH the Automatic Storage Management OPTION

[ora11g@11gr2test ~]$ crs_start ora.DATA1.dg

Attempting to start `ora.DATA1.dg` on member `11gr2test`
Start of `ora.DATA1.dg` on member `11gr2test` succeeded.
Attempting to start `ora.roger.db` on member `11gr2test`
Start of `ora.roger.db` on member `11gr2test` succeeded.

[ora11g@11gr2test ~]$ crs_stat -t

Name           Type           Target    State     Host      
------------------------------------------------------------
ora.DATA1.dg   ora....up.type ONLINE    ONLINE    11gr2test 
ora....ER.lsnr ora....er.type ONLINE    ONLINE    11gr2test 
ora.asm        ora.asm.type   ONLINE    ONLINE    11gr2test 
ora.cssd       ora.cssd.type  ONLINE    ONLINE    11gr2test 
ora.diskmon    ora....on.type ONLINE    ONLINE    11gr2test 
ora.evmd       ora.evm.type   ONLINE    ONLINE    11gr2test 
ora.ons        ora.ons.type   OFFLINE   OFFLINE             
ora.roger.db   ora....se.type ONLINE    ONLINE    11gr2test

需要说明一点的是,11gR2 asm已经放到grid里面了,我们设置ORACLE_HOME的时候需要设置为grid安装的home目录。

[ora11g@11gr2test ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production ON Sun Oct 9 20:17:38 2011
Copyright (c) 1982, 2010, Oracle.  ALL rights reserved.

Connected TO:
Oracle DATABASE 11g Enterprise Edition Release 11.2.0.2.0 - Production
WITH the Automatic Storage Management OPTION

SQL> SHOW parameter asm

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups                       string      DATA1, DATA
asm_diskstring                       string      /dev/sdc, /dev/sdb, /dev/sdd
asm_power_limit                      INTEGER     1
asm_preferred_read_failure_groups    string

SQL> SHOW parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string

SQL> SHOW parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string

SQL> CREATE spfile FROM pfile;

CREATE spfile FROM pfile
*
ERROR at line 1:
ORA-01078: failure IN processing system parameters
LRM-00109: could NOT OPEN parameter file '/home/ora11g/11.2/grid/dbs/init+ASM.ora'

SQL> CREATE pfile='/home/ora11g/11.2/grid/dbs/init+ASM.ora' FROM pfile;

CREATE pfile='/home/ora11g/11.2/grid/dbs/init+ASM.ora' FROM pfile
*
ERROR at line 1:
ORA-00922: missing OR invalid OPTION

SQL> CREATE pfile='/home/ora11g/11.2/grid/dbs/init+ASM.ora' FROM spfile;

CREATE pfile='/home/ora11g/11.2/grid/dbs/init+ASM.ora' FROM spfile
*
ERROR at line 1:
ORA-01565: error IN identifying file ' /dbs/spfile@.ora'
ORA-27037: unable TO obtain file STATUS
Linux Error: 2: No such file OR directory
Additional information: 3

SQL> CREATE pfile='/home/ora11g/11.2/grid/dbs/init+ASM.ora' FROM memory;

File created.
[ora11g@11gr2test ~]$ strings /home/ora11g/11.2/grid/dbs/init+ASM.ora

# Oracle init.ora parameter file generated by instance +ASM on 10/09/2011 20:20:12
_aggregation_optimization_settings=0
_always_anti_join='CHOOSE'
_always_semi_join='CHOOSE'
_and_pruning_enabled=TRUE
_b_tree_bitmap_plans=TRUE
_bloom_filter_enabled=TRUE
_bloom_folding_enabled=TRUE
_bloom_pruning_enabled=TRUE
_complex_view_merging=TRUE
_compression_compatibility='11.2.0'
_connect_by_use_union_all='TRUE'
_convert_set_to_join=FALSE
_cost_equality_semi_join=TRUE
_cpu_to_io=0
_dimension_skip_null=TRUE
_dummy_instance=TRUE
_eliminate_common_subexpr=TRUE
_enable_type_dep_selectivity=TRUE
_fast_full_scan_enabled=TRUE
_first_k_rows_dynamic_proration=TRUE
_gby_hash_aggregation_enabled=TRUE
_generalized_pruning_enabled=TRUE
_globalindex_pnum_filter_enabled=TRUE
_gs_anti_semi_join_allowed=TRUE
_improved_outerjoin_card=TRUE
_improved_row_length_enabled=TRUE
_index_join_enabled=TRUE
_ksb_restart_policy_times='0'
_ksb_restart_policy_times='60'
_ksb_restart_policy_times='120'
_ksb_restart_policy_times='240' # internal update to set default
_left_nested_loops_random=TRUE
_local_communication_costing_enabled=TRUE
_minimal_stats_aggregation=TRUE
_mmv_query_rewrite_enabled=TRUE
_new_initial_join_orders=TRUE
_new_sort_cost_estimate=TRUE
_nlj_batching_enabled=1
_optim_adjust_for_part_skews=TRUE
_optim_enhance_nnull_detection=TRUE
_optim_new_default_join_sel=TRUE
_optim_peek_user_binds=TRUE
_optimizer_adaptive_cursor_sharing=TRUE
_optimizer_better_inlist_costing='ALL'
_optimizer_cbqt_no_size_restriction=TRUE
_optimizer_coalesce_subqueries=TRUE
_optimizer_complex_pred_selectivity=TRUE
_optimizer_compute_index_stats=TRUE
_optimizer_connect_by_combine_sw=TRUE
_optimizer_connect_by_cost_based=TRUE
_optimizer_connect_by_elim_dups=TRUE
_optimizer_correct_sq_selectivity=TRUE
_optimizer_cost_based_transformation='LINEAR'
_optimizer_cost_hjsmj_multimatch=TRUE
_optimizer_cost_model='CHOOSE'
_optimizer_dim_subq_join_sel=TRUE
_optimizer_distinct_agg_transform=TRUE
_optimizer_distinct_elimination=TRUE
_optimizer_distinct_placement=TRUE
_optimizer_eliminate_filtering_join=TRUE
_optimizer_enable_density_improvements=TRUE
_optimizer_enable_extended_stats=TRUE
_optimizer_enable_table_lookup_by_nl=TRUE
_optimizer_enhanced_filter_push=TRUE
_optimizer_extend_jppd_view_types=TRUE
_optimizer_extended_cursor_sharing='UDO'
_optimizer_extended_cursor_sharing_rel='SIMPLE'
_optimizer_extended_stats_usage_control=192
_optimizer_false_filter_pred_pullup=TRUE
_optimizer_fast_access_pred_analysis=TRUE
_optimizer_fast_pred_transitivity=TRUE
_optimizer_filter_pred_pullup=TRUE
_optimizer_fkr_index_cost_bias=10
_optimizer_group_by_placement=TRUE
_optimizer_improve_selectivity=TRUE
_optimizer_interleave_jppd=TRUE
_optimizer_join_elimination_enabled=TRUE
_optimizer_join_factorization=TRUE
_optimizer_join_order_control=3
_optimizer_join_sel_sanity_check=TRUE
_optimizer_max_permutations=2000
_optimizer_mode_force=TRUE
_optimizer_multi_level_push_pred=TRUE
_optimizer_native_full_outer_join='FORCE'
_optimizer_new_join_card_computation=TRUE
_optimizer_null_aware_antijoin=TRUE
_optimizer_or_expansion='DEPTH'
_optimizer_order_by_elimination_enabled=TRUE
_optimizer_outer_to_anti_enabled=TRUE
_optimizer_push_down_distinct=0
_optimizer_push_pred_cost_based=TRUE
_optimizer_rownum_bind_default=10
_optimizer_rownum_pred_based_fkr=TRUE
_optimizer_skip_scan_enabled=TRUE
_optimizer_sortmerge_join_inequality=TRUE
_optimizer_squ_bottomup=TRUE
_optimizer_star_tran_in_with_clause=TRUE
_optimizer_system_stats_usage=TRUE
_optimizer_table_expansion=TRUE
_optimizer_transitivity_retain=TRUE
_optimizer_try_st_before_jppd=TRUE
_optimizer_undo_cost_change='11.2.0.2'
_optimizer_unnest_corr_set_subq=TRUE
_optimizer_unnest_disjunctive_subq=TRUE
_optimizer_use_cbqt_star_transformation=TRUE
_optimizer_use_feedback=TRUE
_or_expand_nvl_predicate=TRUE
_ordered_nested_loop=TRUE
_parallel_broadcast_enabled=TRUE
_partition_view_enabled=TRUE
_pivot_implementation_method='CHOOSE'
_pre_rewrite_push_pred=TRUE
_pred_move_around=TRUE
_push_join_predicate=TRUE
_push_join_union_view=TRUE
_push_join_union_view2=TRUE
_px_minus_intersect=TRUE
_px_partition_scan_enabled=TRUE
_px_pwg_enabled=TRUE
_px_ual_serial_input=TRUE
_query_rewrite_setopgrw_enable=TRUE
_remove_aggr_subquery=TRUE
_replace_virtual_columns=TRUE
_right_outer_hash_enable=TRUE
_selfjoin_mv_duplicates=TRUE
_sql_model_unfold_forloops='RUN_TIME'
_subquery_pruning_enabled=TRUE
_subquery_pruning_mv_enabled=FALSE
_table_scan_cost_plus_one=TRUE
_union_rewrite_for_gs='YES_GSET_MVS'
_unnest_subquery=TRUE
_use_column_stats_for_function=TRUE
asm_diskgroups='DATA1'
asm_diskgroups='DATA'
asm_diskstring='/dev/sdc'
asm_diskstring='/dev/sdb'
asm_diskstring='/dev/sdd'
background_dump_dest='/home/ora11g/11.2/grid/log/diag/asm/+asm/+ASM/trace' #Deprecate parameter
core_dump_dest='/home/ora11g/11.2/grid/log/diag/asm/+asm/+ASM/cdump'
local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.83.10)(PORT=1521))))'
user_dump_dest='/home/ora11g/11.2/grid/log/diag/asm/+asm/+ASM/trace' #Deprecate parameter

我们可以看到,background_dump_dest和user_dump_dest在11.2中已经被废弃了。

SQL> CREATE spfile FROM pfile='/home/ora11g/asm.ora';
File created.

SQL> !strings asm.ora

asm_diskgroups='DATA1'
asm_diskgroups='DATA'
asm_diskstring='/dev/sdc'
asm_diskstring='/dev/sdb'
asm_diskstring='/dev/sdd'
core_dump_dest='/home/ora11g/11.2/grid/log/diag/asm/+asm/+ASM/cdump'
local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.83.10)(PORT=1521))))'

[ora11g@11gr2test ~]$ crs_stat -t

Name           Type           Target    State     Host      
------------------------------------------------------------
ora.DATA1.dg   ora....up.type ONLINE    ONLINE    11gr2test 
ora....ER.lsnr ora....er.type ONLINE    ONLINE    11gr2test 
ora.asm        ora.asm.type   ONLINE    ONLINE    11gr2test 
ora.cssd       ora.cssd.type  ONLINE    ONLINE    11gr2test 
ora.diskmon    ora....on.type ONLINE    ONLINE    11gr2test 
ora.evmd       ora.evm.type   ONLINE    ONLINE    11gr2test 
ora.ons        ora.ons.type   OFFLINE   OFFLINE             
ora.roger.db   ora....se.type ONLINE    ONLINE    11gr2test 

[ora11g@11gr2test ~]$ crsctl stop has

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on '11gr2test'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on '11gr2test'
CRS-2673: Attempting to stop 'ora.roger.db' on '11gr2test'
CRS-2673: Attempting to stop 'ora.evmd' on '11gr2test'
CRS-2677: Stop of 'ora.roger.db' on '11gr2test' succeeded
CRS-2673: Attempting to stop 'ora.DATA1.dg' on '11gr2test'
CRS-2677: Stop of 'ora.DATA1.dg' on '11gr2test' succeeded
CRS-2673: Attempting to stop 'ora.asm' on '11gr2test'
CRS-2677: Stop of 'ora.asm' on '11gr2tOracleоest' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on '11gr2test'
CRS-2677: Stop of 'ora.evmd' on '11gr2test' succeeded
CRS-2677: Stop of 'ora.cssd' on '11gr2test' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on '11gr2test'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on '11gr2test' succeeded
CRS-2677: Stop of 'ora.diskmon' on '11gr2test' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on '11gr2test' has completed
CRS-4133: Oracle High Availability Services has been stopped.

[ora11g@11gr2test ~]$ crsctl start has
[ora11g@11gr2test ~]$ crs_stat -t

Name           Type           Target    State     Host      
------------------------------------------------------------
ora.DATA1.dg   ora....up.type ONLINE    OFFLINE             
ora....ER.lsnr ora....er.type ONLINE    ONLINE    11gr2test 
ora.asm        ora.asm.type   ONLINE    OFFLINE             
ora.cssd       ora.cssd.type  ONLINE    OFFLINE             
ora.diskmon    ora....on.type ONLINE    ONLINE    11gr2test 
ora.evmd       ora.evm.type   ONLINE    ONLINE    11gr2test 
ora.ons        ora.ons.type   OFFLINE   OFFLINE             
ora.roger.db   ora....se.type ONLINE    OFFLINE             

[ora11g@11gr2test ~]$ crs_stat -t

Name           Type           Target    State     Host      
------------------------------------------------------------
ora.DATA1.dg   ora....up.type ONLINE    ONLINE    11gr2test 
ora....ER.lsnr ora....er.type ONLINE    ONLINE    11gr2test 
ora.asm        ora.asm.type   ONLINE    ONLINE    11gr2test 
ora.cssd       ora.cssd.type  ONLINE    ONLINE    11gr2test 
ora.diskmon    ora....on.type ONLINE    ONLINE    11gr2test 
ora.evmd       ora.evm.type   ONLINE    ONLINE    11gr2test 
ora.ons        ora.ons.type   OFFLINE   OFFLINE             
ora.roger.db   ora....se.type ONLINE    OFFLINE             

[ora11g@11gr2test ~]$ crs_stat -t

Name           Type           Target    State     Host      
------------------------------------------------------------
ora.DATA1.dg   ora....up.type ONLINE    ONLINE    11gr2test 
ora....ER.lsnr ora....er.type ONLINE    ONLINE    11gr2test 
ora.asm        ora.asm.type   ONLINE    ONLINE    11gr2test 
ora.cssd       ora.cssd.type  ONLINE    ONLINE    11gr2test 
ora.diskmon    ora....on.type ONLINE    ONLINE    11gr2test 
ora.evmd       ora.evm.type   ONLINE    ONLINE    11gr2test 
ora.ons        ora.ons.type   OFFLINE   OFFLINE             
ora.roger.db   ora....se.type ONLINE    ONLINE    11gr2test

最后启动实例以后,再次查询,就正常了,再次也说明 Tanel Poder 的scripts似乎存在一些问题:
SQL> SELECT
2      name                                     group_name
3    , sector_size                              sector_size
4    , block_size                               block_size
5    , allocation_unit_size                     allocation_unit_size
6    , state                                    state
7    , TYPE                                     TYPE
8    , total_mb                                 total_mb
9    , (total_mb - free_mb)                     used_mb
10    , ROUND((1- (free_mb / total_mb))*100, 2)  pct_used
11  FROM
12      v$asm_diskgroup
13  ORDER BY
14      name
15  /

Disk GROUP            Sector   Block   Allocation
Name                    SIZE    SIZE    Unit SIZE State       TYPE   Total SIZE (MB) Used SIZE (MB) Pct. Used
-------------------- ------- ------- ------------ ----------- ------ --------------- -------------- ---------
DATA1                    512   4,096    1,048,576 MOUNTED     EXTERN           4,096          1,714     41.85
--------------- --------------
Grand Total:                                                                   4,096          1,714

最后再补充一点,关于create pfile from memory出来以后,为什么里面会多那么多隐含参数呢?
做个10046 event发现了执行了如下的sql:
SELECT num,name,TYPE,display_value,update_comment FROM v$system_parameter4 ORDER BY LOWER(name),ordinal
难怪。。。

最好搜索MOS,居然发现了这样一篇文档,大家可以参考如下note:

Why does create PFILE|SPFILE from MEMORY output differ from that of SPFILE|PFILE  [ID 784133.1]

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle RAC环境asm和db实例无法启动的解决办法笔记

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1324.html

Oracle研究中心

关键词:

Oracle RAC环境中ASM无法启动的解决办法

Oracle RAC无法启动的案例