oracle restart体验(续)
本站文章除注明转载外,均为本站原创: 转载自love wife love life —Roger的Oracle/MySQL/PostgreSQL数据恢复博客
本文链接地址: oracle restart体验(续)
1 |
今天上午准备在11gR2 测试环境上研究TDE,发现asm和db实例无法启动,如下: |
1 2 3 4 5 6 7 8 9 10 11 12 |
[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 |
1 |
查看日志,发现如下内容: |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
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" |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 |
[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 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
[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 |
1 2 |
需要说明一点的是,11gR2 asm已经放到grid里面了,我们设置ORACLE_HOME的时候 需要设置为grid安装的home目录。 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 |
[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. |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 |
[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 |
1 |
我们可以看到,background_dump_dest和user_dump_dest在11.2中已经被废弃了。 |
1 2 3 4 5 6 7 8 9 10 11 12 13 |
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))))' |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 |
[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 '11gr2test' 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 |
1 |
最后启动实例以后,再次查询,就正常了,再次也说明 Tanel Poder 的scripts似乎存在一些问题: |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
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 |
1 2 |
最后再补充一点,关于create pfile from memory出来以后,为什么里面会多那么多隐含参数呢? 做个10046 event发现了执行了如下的sql: |
1 |
select num,name,type,display_value,update_comment from v$system_parameter4 order by lower(name),ordinal |
1 2 3 4 5 |
难怪。。。 最好搜索MOS,居然发现了这样一篇文档,大家可以参考如下note: Why does create PFILE|SPFILE from MEMORY output differ from that of SPFILE|PFILE? [ID 784133.1] |
One Response to “oracle restart体验(续)”
Very good blog article.Really looking forward to read more. Much obliged.
Leave a Reply
You must be logged in to post a comment.