关于裸设备数据的处理

 

如果用ASM管理数据库 ，将原来的数据库删除后，重新创建数据库，会出现如下报错：

CREATE DATABASE "devdb"ITPUB个人空间?i#k:@ROd!`F
*ITPUB个人空间*eg-z8{4a�tTi1{
ERROR at line 1:
H$T8yMu1F%hb0A734503 ORA-01501: CREATE DATABASE failed
U4iFV'X|w1A734503 ORA-00200: control file could not be created
*L+s*f2Caq5E7c734503 ORA-00202: control file: '+DATA/devdb/control01.ctl'
%m0@Y(/]Un734503 ORA-17502: ksfdcre:4 Failed to create file +DATA/devdb/control01.ctlITPUB个人空间Cnd%[h)uV[
ORA-15005: name "devdb/control01.ctl" is already used by an existing alias

说明以前的控制文件、数据文件，日志文件并没有删除，

如何将这些文件删除掉呢？

我的想法是，直接在裸设备上将数据清除，如下步骤去做：

1、使用DD命令，清除块设备数据：

[root@rac1 devdb]# dd if=/dev/zero of=/dev/sdc1
OVR3D{(aH&?'ha734503 dd: 正在写入 ‘/dev/sdc1’: 设备上没有空间ITPUB个人空间!Y:?ahq1L QBH
读入了 6281353+0 个块ITPUB个人空间1cxt*l l
输出了 6281352+0 个块

等等。。。。将所有的块设备数据逐个清除。

清除后，需要重启一下操作系统，否则会出现很多麻烦：

我清除后，直接建库，而没有去重新启动操作系统，报如下错误：

 

CREATE DATABASE "devdb0"ITPUB个人空间!UA yN.^M:v.w
*
)KNPbBu6ML734503 ERROR at line 1:
*SeP&XN,P9k]�A734503 ORA-01501: CREATE DATABASE failed
(YL+Vbe2H734503 ORA-00200: control file could not be created
4wm:]0PHr8XIRt734503 ORA-00202: control file: '+DATA/devdb0/control01.ctl'ITPUB个人空间:nV2?-j}p.h
ORA-17502: ksfdcre:4 Failed to create file +DATA/devdb0/control01.ctl
P-O(u?)T bF!Z N-Y734503 ORA-15130: diskgroup "DATA " is being dismountedITPUB个人空间7N4lQ-]o k^ C
ORA-15066: offlining disk "DATA_0001" may result in a data loss

曾尝试过从底层重新启用裸设备的方法，使之生效，可是没有达到预期效果：

[root@rac1 devdb]# /etc/init.d/o2cb unload
"l_0Pi&TJa~734503 Stopping O2CB cluster ocfs2: Failed
m4g4V^.}b734503 Unable to stop cluster as heartbeat region still activeITPUB个人空间/@qgua`E]
[root@rac1 devdb]# /etc/init.d/o2cb unloadITPUB个人空间B(V s"xc@ ^
Stopping O2CB cluster ocfs2: FailedITPUB个人空间M{/e+_U5u7C q_
Unable to stop cluster as heartbeat region still activeITPUB个人空间�h"f1K,XB}:[
[root@rac1 devdb]# /etc/init.d/oracleasm configureITPUB个人空间6Y/f-n#w-eNI
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM libraryITPUB个人空间"ELq xoW&N
driver.  The following questions will determine whether the driver isITPUB个人空间-c3EyDe:i3W
loaded on boot and what permissions it will have.  The current valuesITPUB个人空间R@�i1T}m+M:T
will be shown in brackets ('[]').  Hitting <ENTER> without typing an
`z-W H$W J&{ i�XN"n9b734503 answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface [oracle]: oracleITPUB个人空间@hj}'`BKX
Default group to own the driver interface [dba]: dba    
F3]iG*SK3},G734503 Start Oracle ASM library driver on boot (y/n) [y]: yITPUB个人空间bz#Jf-/#z E)o-Q
Fix permissions of Oracle ASM disks on boot (y/n) [y]: yITPUB个人空间TB;z&y(uE3rr
Writing Oracle ASM library driver configuration: [  OK  ]
?6R%Z[~R e o734503 Scanning system for ASM disks: [  OK  ]ITPUB个人空间 BQd!r+bRi@
[root@rac1 devdb]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdc1ITPUB个人空间5kz5X$]W1`1a
Marking disk "/dev/sdc1" as an ASM disk: [  OK  ]ITPUB个人空间;h.m3VZ_3B'BQ
[root@rac1 devdb]# /etc/init.d/oracleasm createdisk VOL2 /dev/sdd1ITPUB个人空间-F,w0M0E7B3R xGp
Marking disk "/dev/sdd1" as an ASM disk: [  OK  ]ITPUB个人空间5S4qH&t Ul
[root@rac1 devdb]# /etc/init.d/oracleasm createdisk VOL3 /dev/sde1
,L4`.w&L9Hs734503 Marking disk "/dev/sde1" as an ASM disk: [  OK  ]
qEn~?#j7us734503 [root@rac1 devdb]# /etc/init.d/oracleasm scandisks
:TdX%W3Kg734503 Scanning system for ASM disks: [  OK  ]ITPUB个人空间Hx*l6|H
[root@rac1 devdb]# /etc/init.d/oracleasm listdisksITPUB个人空间/?O+x]Lv1SV
VOL1
)y-pV1I}#w8^&bL�d734503 VOL2
9Vx U+GP7J /B``C|734503 VOL3
1ei1dWX"Mt e(b_$l4|"r734503 [root@rac1 devdb]# /etc/init.d/o2cb unloadITPUB个人空间Bg)ZP2t'c!/4M
Stopping O2CB cluster ocfs2: Failed
/T+ML5MH/F QG X734503 Unable to stop cluster as heartbeat region still activeITPUB个人空间w X6HM'u$|#{8YQB
[root@rac1 devdb]# /etc/init.d/o2cb status
?#WYSD#Q734503 Module "configfs": Loaded
%U8X6TD(d8V%[K^734503 Filesystem "configfs": MountedITPUB个人空间M5S~3w/c,d
Module "ocfs2_nodemanager": LoadedITPUB个人空间I,}j8F i8X,zE|
Module "ocfs2_dlm": LoadedITPUB个人空间*v7]K [D;KeP?/
Module "ocfs2_dlmfs": LoadedITPUB个人空间},q,wSOms
Filesystem "ocfs2_dlmfs": MountedITPUB个人空间�Y*S{TD_*y R
Checking O2CB cluster ocfs2: Online
f9EE8t/~2t.PCl734503   Heartbeat dead threshold: 61
C:LE~$[/Z&Y&ZT] b734503   Network idle timeout: 10000ITPUB个人空间tys~4OD/QG
  Network keepalive delay: 5000ITPUB个人空间.ER?6V,eA1u]-Zk
  Network reconnect delay: 2000ITPUB个人空间!THm~W9`U-w
Checking O2CB heartbeat: Active

看来，做完这个操作，必须重启。。。。。。

然后将所有服务启动，如下面所示：

ITPUB个人空间!GA)v P&q
rac2-> crs_stat -t
DXIm4N%a734503 Name           Type           Target    State     Host       
v QLXU*n734503 ------------------------------------------------------------            ITPUB个人空间4V(i P.fs
ora....SM1.asm application    ONLINE    ONLINE    rac1       ITPUB个人空间4q Q7D's4}
ora....C1.lsnr application    ONLINE    ONLINE    rac1       
'z!|&d5T5]2x[8u }(u Z734503 ora.rac1.gsd   application    ONLINE    ONLINE    rac1       
9L y$m2H0w]{`734503 ora.rac1.ons   application    ONLINE    ONLINE    rac1       
)R6WD:x1r8uu734503 ora.rac1.vip   application    ONLINE    ONLINE    rac1       
&kfbd#W+|:Q734503 ora....SM2.asm application    ONLINE    ONLINE    rac2       ITPUB个人空间9V*[+a,t"l%g7b
ora....C2.lsnr application    ONLINE    ONLINE    rac2       ITPUB个人空间x2W7^)f G
ora.rac2.gsd   application    ONLINE    ONLINE    rac2       ITPUB个人空间}&G^jB#fG
ora.rac2.ons   application    ONLINE    ONLINE    rac2       
.| p^T"@,i1@w-Bc734503 ora.rac2.vip   application    ONLINE    ONLINE    rac2

问题得以最终解决。