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

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

0

积分

0

好友

11

主题
1#
发表于 2014-5-14 10:37:13 | 查看: 1870| 回复: 0
虚拟机:virtual box 4.3.6
操作系统:Oracle Linux Server release 5.6
clusterware:10.2.0.1.0
数据库:10.2.0.1.0

现象: 在虚拟机上安装的RAC,原来使用的是固定大小的共享盘,系统内通过raw方式配置,现在raw设备结果如下
/etc/sysconfig/rawdevices文件:
/dev/raw/raw1   /dev/sdb1
/dev/raw/raw2   /dev/sdb2
/dev/raw/raw4   /dev/sdd

# fdisk -l /dev/sdb

Disk /dev/sdb: 1073 MB, 1073741824 bytes
255 heads, 63 sectors/track, 130 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
   Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1          32      257008+  83  Linux
/dev/sdb2              33          64      257040   83  Linux

# raw -qa
/dev/raw/raw1:  bound to major 8, minor 17
/dev/raw/raw2:  bound to major 8, minor 18
/dev/raw/raw4:  bound to major 8, minor 48

# ls -l  /dev/raw/*
crw-r----- 1 root   oinstall 162, 1 May 14 10:16 /dev/raw/raw1
crw-r--r-- 1 oracle oinstall 162, 2 May 14 10:16 /dev/raw/raw2
crw-rw---- 1 oracle oinstall 162, 4 May 14 10:16 /dev/raw/raw4

# cat /etc/oracle/ocr.loc
ocrconfig_loc=/dev/raw/raw1
local_only=FALSE

后来测试Linux 的multipath ,通过Openfiler,连接两个网卡模拟,创建了一个normal 的diskgroup 。
# multipath -ll
14f504e46494c45523478335277462d7147304c2d5372756e dm-6 OPNFILER,VIRTUAL-DISK
size=128M features='0' hwhandler='0' wp=rw
|-+- policy='round-robin 0' prio=1 status=active
| `- 5:0:0:2 sdj 8:144 active ready running
`-+- policy='round-robin 0' prio=1 status=enabled
  `- 4:0:0:2 sdi 8:128 active ready running

vdisk2 (14f504e46494c45526d45565364762d317930612d4c6f6868) dm-7 OPNFILER,VIRTUAL-DISK
size=512M features='0' hwhandler='0' wp=rw
|-+- policy='round-robin 0' prio=1 status=active
| `- 4:0:0:1 sdg 8:96  active ready running
`-+- policy='round-robin 0' prio=1 status=enabled
  `- 5:0:0:1 sdh 8:112 active ready running
vdisk1 (14f504e46494c45525776336b52702d36784b382d6f717342) dm-5 OPNFILER,VIRTUAL-DISK
size=512M features='0' hwhandler='0' wp=rw
|-+- policy='round-robin 0' prio=1 status=active
| `- 5:0:0:0 sdf 8:80  active ready running
`-+- policy='round-robin 0' prio=1 status=enabled
  `- 4:0:0:0 sde 8:64  active ready running


重启数据库主机后,CRS不能启动/var/log/messages内容:
May 14 10:33:51 db1 logger: Cluster Ready Services waiting on dependencies. Diagnostics in /tmp/crsctl.2962.
May 14 10:33:51 db1 logger: Cluster Ready Services waiting on dependencies. Diagnostics in /tmp/crsctl.2931.

# cat /tmp/crsctl.2931
OCR initialization failed accessing OCR device: PROC-26: Error while accessing the physical storage Operating System error [Device or resource busy] [16]


现在看OCR的磁盘raw和fdisk结果跟以前没什么区别,这个该从哪下手解决解决?




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

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

GMT+8, 2024-12-21 03:29 , Processed in 0.046472 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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