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

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

0

积分

0

好友

1

主题
1#
发表于 2013-5-2 14:41:18 | 查看: 4095| 回复: 3
连接存储的光纤交换机重启了一次后,ASM实例中的一个diskgroup没有认到。其中VOL1,VOL2,VOL3对应的diskgroup为DG,被一个实例使用正常。VOL4,VOL5对应的diskgroup为ABIZDG被另外一个实例使用。在交换机重启后在listdisk后已经无法找到VOL4,VOL5。其中VOL1,VOL2,VOL3是用fdisk分区直接建立的,而VOL4,VOL5用的是逻辑卷建立的。请问各位大神碰没碰见过这种情况?

asmalert.txt

15.6 KB, 下载次数: 732

asminfo.txt

3.28 KB, 下载次数: 711

2#
发表于 2013-5-2 15:11:25
/dev/mapper/abizdata-lvabiz02: LABEL="VOL5" TYPE="oracleasm"
/dev/mapper/abizdata-lvabiz01: LABEL="VOL4" TYPE="oracleasm"


收集如下信息:

# /etc/init.d/oracleasm scandisks

# /etc/init.d/oracleasm listdisks

# ls -l -R /dev/oracleasm/

# ls -l /etc/sysconfig/oracleasm

# cat /etc/sysconfig/oracleasm

回复 只看该作者 道具 举报

3#
发表于 2013-5-2 15:26:50
root@test2 luzheng]# /etc/init.d/oracleasm scandisks
Scanning the system for Oracle ASMLib disks: [  OK  ]
[root@test2 luzheng]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
[root@test2 luzheng]# ls -l -R /dev/oracleasm/
/dev/oracleasm/:
total 0
drwxr-xr-x 1 root   root 0 May  2 12:26 disks
drwxrwx--- 1 oracle dba  0 May  2 12:26 iid

/dev/oracleasm/disks:
total 0
brw-rw---- 1 oracle dba 8, 49 May  2 15:20 VOL1
brw-rw---- 1 oracle dba 8, 33 May  2 15:20 VOL2
brw-rw---- 1 oracle dba 8, 17 May  2 15:20 VOL3

/dev/oracleasm/iid:
total 0
-rwxr-x--- 1 oracle oinstall 0 May  2 12:29 0000000000000001
-rwxr-x--- 1 oracle oinstall 0 May  2 12:31 0000000000000002
-rwxr-x--- 1 oracle oinstall 0 May  2 12:33 0000000000000003
-rwxr-x--- 1 oracle oinstall 0 May  2 13:23 0000000000000004
-rwxr-x--- 1 oracle oinstall 0 May  2 13:26 0000000000000005
-rwxr-x--- 1 root   root     0 May  2 13:31 0000000000000006
-rwxr-x--- 1 root   root     0 May  2 13:54 0000000000000007
-rwxr-x--- 1 root   root     0 May  2 14:00 0000000000000008
-rwxr-x--- 1 oracle oinstall 0 May  2 14:17 0000000000000009
-rwxr-x--- 1 oracle oinstall 0 May  2 14:26 000000000000000A
-rwxr-x--- 1 oracle oinstall 0 May  2 14:30 000000000000000B
-rwxr-x--- 1 oracle oinstall 0 May  2 14:38 000000000000000C
-rwxr-x--- 1 oracle oinstall 0 May  2 14:38 000000000000000D
-rwxr-x--- 1 oracle oinstall 0 May  2 15:02 000000000000000E
-rwxr-x--- 1 oracle oinstall 0 May  2 15:14 000000000000000F
-rwxr-x--- 1 oracle oinstall 0 May  2 15:15 0000000000000010
[root@test2 luzheng]# ls -l /etc/sysconfig/oracleasm
lrwxrwxrwx 1 root root 24 Mar 29  2010 /etc/sysconfig/oracleasm -> oracleasm-_dev_oracleasm
[root@test2 luzheng]# cat /etc/sysconfig/oracleasm
#
# This is a configuration file for automatic loading of the Oracle
# Automatic Storage Management library kernel driver.  It is generated
# By running /etc/init.d/oracleasm configure.  Please use that method
# to modify this file
#

# ORACLEASM_ENABELED: 'true' means to load the driver on boot.
ORACLEASM_ENABLED=true

# ORACLEASM_UID: Default user owning the /dev/oracleasm mount point.
ORACLEASM_UID=oracle

# ORACLEASM_GID: Default group owning the /dev/oracleasm mount point.
ORACLEASM_GID=dba

# ORACLEASM_SCANBOOT: 'true' means scan for ASM disks on boot.
ORACLEASM_SCANBOOT=true

# ORACLEASM_SCANORDER: Matching patterns to order disk scanning
ORACLEASM_SCANORDER=""

# ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan
ORACLEASM_SCANEXCLUDE=""

目前已经启动

回复 只看该作者 道具 举报

4#
发表于 2013-5-2 15:29:39
修改了初始化参数后可以正常启动
[oracle@test2 dbs]$ more init+ASM.ora
*.asm_diskgroups='DG','DGABIZ'+ASM.asm_diskgroups='DG','DGABIZ'#Manual Dismount
*.asm_diskstring='/dev/oracleasm/disks/*','/dev/mapper/*'*.background_dump_dest='/u01/app/oracle/admin/+ASM/bdump'
*.core_dump_dest='/u01/app/oracle/admin/+ASM/cdump'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='SHARED'
*.user_dump_dest='/u01/app/oracle/admin/+ASM/udump'
标红部分是新添加的
但是让我想不通的是认不到disk却可以启动

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-11-16 12:37 , Processed in 0.055312 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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