前几天枯荣长老给我提醒了一个很重要的命令:ASMCMD。后来,我解决了一个困扰很久的问题。看来上帝关闭了所有的门,给我们留了一扇窗户。
我目前环境情况:以前安装过ORACLE的RAC,目前需要重建ORACLE数据库,但是空间不够,需要将以前安装的内容给删除掉。我尝试过使用IF DD=ZER0 /DEV/SDC1,从裸设备层面删除,结果失败了。所以,ASMCMD就可以。
具体做法:
rac1-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.devdb.db application OFFLINE OFFLINE
ora....b1.inst application OFFLINE OFFLINE
ora....b2.inst application ONLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
目前可以看到,当前的实例是不可用的。但是安装文件没有完全删除。
rac1-> asmcmd
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory (DBD ERROR: OCISessionBegin)
说明一个问题:ASM没有启动。解决办法,按照如下步骤:
rac1-> export ORACLE_SID=+ASM1
rac1-> sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Mar 8 09:46:32 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/oracle as sysdba
Connected.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
rac1-> asmcmd
ASMCMD> ls
DATA/
FLASH/
ASMCMD> cd data
ASMCMD> ls
DEVDB/
ASMCMD> cd devdb
ASMCMD> ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
TEMPFILE/
control01.ctl
control02.ctl
control03.ctl
redo01.log
redo02.log
ASMCMD> cd ..
ASMCMD> ls
DEVDB/
ASMCMD> rm devdb
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)
ASMCMD> ls
DEVDB/
ASMCMD> rm devdb
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)
ASMCMD> rm -r devdb
You may delete multiple files and/or directories.
Are you sure? (y/n) y
这样就OK了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8334342/viewspace-563236/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8334342/viewspace-563236/