Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

45

积分

0

好友

3

主题
1#
发表于 2012-5-15 14:35:50 | 查看: 6237| 回复: 2
RHEL5.4  GI 11.2.0.1

[root@slave ~]# /etc/init.d/oracleasm listdisks
VOLB
VOLC
VOLD

[root@slave ~]# cat /proc/partitions
major minor  #blocks  name
   8     0   31457280 sda
   8     1     200781 sda1
   8     2   10241437 sda2
   8     3    2096482 sda3
   8     4   18916537 sda4
   8    16   20971520 sdb
   8    17   20964793 sdb1
   8    32   20971520 sdc
   8    33   20964793 sdc1
   8    48   20971520 sdd
   8    49   20964793 sdd1

[root@slave ~]# ll /dev/oracleasm/disks/
总计 0
brw-rw---- 1 grid asmadmin 8, 17 05-15 13:54 VOLB
brw-rw---- 1 grid asmadmin 8, 33 05-15 13:54 VOLC
brw-rw---- 1 grid asmadmin 8, 49 05-15 13:55 VOLD


[grid@slave dbs]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 15 14:11:21 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
SQL> shutdown immediate
ORA-15100: invalid or missing diskgroup name

ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area  284565504 bytes
Fixed Size      1336036 bytes
Variable Size    258063644 bytes
ASM Cache     25165824 bytes
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"

SQL> SELECT GROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS, PATH FROM V$ASM_DISK;
GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU PATH
------------ ----------- ------- ------------ --------------------
    0        0 CLOSED  PROVISIONED  /dev/oracleasm/disks
           /VOLD
    0        2 CLOSED  PROVISIONED  /dev/oracleasm/disks
           /VOLB
    0        1 CLOSED  PROVISIONED  /dev/oracleasm/disks
           /VOLC

alter日志:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option.
Using parameter settings in server-side pfile /u02/app/grid/dbs/init+ASM.ora
System parameters with non-default values:
  large_pool_size          = 12M
  instance_type            = "asm"
  remote_login_passwordfile= "EXCLUSIVE"
  asm_diskstring           = "/dev/oracleasm/disks/VOL*"
  asm_diskgroups           = "DATA"
  asm_power_limit          = 1
  diagnostic_dest          = "/u02/app/grid"
Tue May 15 14:13:14 2012
PMON started with pid=2, OS id=31320
Tue May 15 14:13:14 2012
VKTM started with pid=3, OS id=31322 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Tue May 15 14:13:14 2012
GEN0 started with pid=4, OS id=31326
Tue May 15 14:13:14 2012
DIAG started with pid=5, OS id=31328
Tue May 15 14:13:14 2012
PSP0 started with pid=6, OS id=31330
Tue May 15 14:13:14 2012
DIA0 started with pid=7, OS id=31332
Tue May 15 14:13:14 2012
MMAN started with pid=8, OS id=31334
Tue May 15 14:13:14 2012
DBW0 started with pid=9, OS id=31336
Tue May 15 14:13:15 2012
LGWR started with pid=10, OS id=31338
Tue May 15 14:13:15 2012
CKPT started with pid=11, OS id=31340
Tue May 15 14:13:15 2012
SMON started with pid=12, OS id=31342
Tue May 15 14:13:15 2012
RBAL started with pid=13, OS id=31344
Tue May 15 14:13:15 2012
GMON started with pid=14, OS id=31346
Tue May 15 14:13:15 2012
MMON started with pid=15, OS id=31348
Tue May 15 14:13:15 2012
MMNL started with pid=16, OS id=31350
ORACLE_BASE from environment = /u02/app
Tue May 15 14:13:15 2012
SQL> ALTER DISKGROUP ALL MOUNT
NOTE: Diskgroups listed in ASM_DISKGROUPS are
   DATA
NOTE: cache registered group DATA number=1 incarn=0xe7ba2e3a
NOTE: cache began mount (first) of group DATA number=1 incarn=0xe7ba2e3a
NOTE: Loaded library: /opt/oracle/extapi/32/asm/orcl/1/libasm.so
ERROR: no PST quorum in group: required 2, found 0
NOTE: cache dismounting (clean) group 1/0xE7BA2E3A (DATA)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 1/0xE7BA2E3A (DATA)
NOTE: cache ending mount (fail) of group DATA number=1 incarn=0xe7ba2e3a
kfdp_dismount(): 2
kfdp_dismountBg(): 2
ERROR: diskgroup DATA was not mounted
NOTE: cache deleting context for group DATA 1/-407228870
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
ERROR: ALTER DISKGROUP ALL MOUNT


刘大,帮忙看看,谢了

[ 本帖最后由 wonder 于 2012-5-15 14:46 编辑 ]
2#
发表于 2012-5-16 15:43:47
查看一下你 /dev/raw/ 下的 raw 的权限 根据您自己的权限分配情况{仔仔细细}看一下!  是不是  grid:asmadmin

回复 只看该作者 道具 举报

3#
发表于 2012-5-16 20:19:44
在2个节点 上运行以下SQL,并贴出结果

ls -l /dev/oracleasm/disks

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-25 13:42 , Processed in 0.046233 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569