删除Linux非rac环境下的ASM实例 |
您所在的位置:网站首页 › 删除oracle实例sid › 删除Linux非rac环境下的ASM实例 |
环境说明: 操作系统:CentOS 5 x86数据库:Oracle 10.2.0.1 非RAC环境ASM实例名:+ASM 参考:metalink node:311350.1 1、检查ASM实例进程 ora_test@oracle[/home/oracle]> ps -ef|grep asm|grep -v greporacle 4263 1 0 Jan20 ? 00:00:02 asm_pmon_+ASMoracle 4265 1 0 Jan20 ? 00:00:00 asm_psp0_+ASMoracle 4267 1 0 Jan20 ? 00:00:00 asm_mman_+ASMoracle 4269 1 0 Jan20 ? 00:00:00 asm_dbw0_+ASMoracle 4271 1 0 Jan20 ? 00:00:00 asm_lgwr_+ASMoracle 4273 1 0 Jan20 ? 00:00:00 asm_ckpt_+ASMoracle 4275 1 0 Jan20 ? 00:00:00 asm_smon_+ASMoracle 4277 1 0 Jan20 ? 00:00:00 asm_rbal_+ASMoracle 4279 1 0 Jan20 ? 00:00:06 asm_gmon_+ASM2、设置ASM实例名 ora_test@oracle[/home/oracle]> export ORACLE_SID=+ASM3、检查是否有实例在使用ASM ora_test@oracle[/home/oracle]> sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 21 08:44:03 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsidle> select instance_name from v$asm_client;no rows selected如果有实例在使用ASM,需要首先停止这些相关的实例,并备份相关的datafile、controlfile等 4、检查ASM实例上的diskgroup idle> select name from v$asm_diskgroup;NAME------------------------------DATA5、删除检查到ASM实例上的diskgroup idle> drop diskgroup data including contents;Diskgroup dropped.6、关闭ASM实例 idle> shutdownORA-15100: invalid or missing diskgroup nameASM instance shutdownidle> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options7、从css中删除ASM实例信息 ora_test@oracle[/home/oracle]> oradism -delete -asmsid +ASM8、删除ASM实例相关的spfile、pfile等文件 ora_test@oracle[/home/oracle]> cd $ORACLE_HOME/dbsora_test@oracle[/oracle/app/10.1/dbs]> rm -f *+ASM*ora_test@oracle[/oracle/app/10.1/dbs]> cd $ORACLE_BASE/adminora_test@oracle[/oracle/admin]> rm -rf +ASM9、删除/etc/oratab文件中的ASM实例相关行 删除/etc/oratab文件中的如下行 其实删除oracle 实例同样要查出该文件的内容 +ASM:/oracle/app/10.1:Y10、用root用户删除cssd服务 ora_test@root[/oracle/app/10.1/bin]> ./localconfig deleteStopping CSSD.Shutting down CSS daemon.Shutdown request successfully issued.Shutdown has begun. The daemons should exit soon.11、清除ASM使用的设备的文件头信息 ora_test@oracle[/home/oracle]> cd /dev/raw/ora_test@oracle[/dev/raw]> ls -l *crw------- 1 oracle oinstall 162, 1 Jan 21 08:45 raw1crw------- 1 oracle oinstall 162, 2 Jan 21 08:45 raw2crw------- 1 oracle oinstall 162, 3 Jan 21 08:45 raw3ora_test@oracle[/dev/raw]> dd if=/dev/zero of=/dev/raw/raw1 bs=1024 count=1010+0 records in10+0 records out10240 bytes (10 kB) copied, 0.00396028 seconds, 2.6 MB/sora_test@oracle[/dev/raw]> dd if=/dev/zero of=/dev/raw/raw2 bs=1024 count=1010+0 records in10+0 records out10240 bytes (10 kB) copied, 0.00485093 seconds, 2.1 MB/sora_test@oracle[/dev/raw]> dd if=/dev/zero of=/dev/raw/raw3 bs=1024 count=1010+0 records in10+0 records out10240 bytes (10 kB) copied, 0.00532261 seconds, 1.9 MB/s--end-- |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |