This operation will DESTROY any databases that are currently running on the +ASM instance
1) Shutdown all databases that are running on the box using the +ASM instance for storage management
2) Use emca -x <sid> to remove the Database Console for each instance
3) Clear the existing raw disks
dd if=/dev/zero of=<raw device>bs=8192 count=1000
OR
drop the raw partition
4) Drop the old parameter file (init<sid>.ora or spfile<sid>.ora)
Default location: <ORACLE_HOME>/dbs
5) Delete / Remove any non ASM supporting directories
BACKGROUND_DUMP_DEST
USER_DUMP_DEST
CORE_DUMP_DEST
etc
6) Remove the ORATAB entry for the ASM instance
7) Remove the resource from cluster ready services (CRS)
if RAC: srvctl remove asm -n nodename
if Standalone: $ORACLE_HOME/bin/localconfing -delete
At this point ... if desired ...a new ASM instance should be able to be recreated (DBCA or manual) ... if necessary ... recreate the raw partitions
From Oracle
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
How to view and edit data on ASM using BBED
Database Initora parameters to support ASM ASM and database shutdown dependencies ASM and database deployment Best Practices Storage Management and Allocation Rebalance and Redistribution Files ...
Oracle RMAN Database Duplication is a deep dive into RMAN's duplication feature set, showing how RMAN can make it so much easier for you as a database administrator to satisfy the many requests from ...
when the data file on an ASM disk group gets corrupted C. when one of the disks in a disk group is accidentally unplugged D. when one or more file directory paths are accidentally deleted from an ASM...
主题:Bring Native to the Web: an introduction to Emscripten and asm.js 演讲人:张频,谋智网络(Mozilla)软件经理 演讲介绍:Emscripten 是 Mozilla 推出的一个开源编译工具,它能将 C/C++ 程序编译为 ...
This volume of the ASM Handbook series, Fatigue and Fracture, marks the first separate Handbook on an important engineering topic of long-standing and continuing interest for both materials and ...
Moving your SAP database to Oracle 11gR2 ASM A “Best Practices” Guide
查看ASM实例和SCAN监听日志文件 查看本地监听日志文件 Database日志文件
ASM is an Android Debug Bridge (adb) client, When it starts monitoring screen, ASM connects to adb on port 5037 and receives frame buffer continuously on the device or emulator and transfer image to ...
// further transformed by the JarJar task to depend on org.springframework.asm; this // avoids including two different copies of asm unnecessarily. If however future cglib // versions drift from the ...
storage management and provisioning for the database has been greatly simplified using Automatic Storage Management (ASM). ASM provides filesystem and volume manager capabilities built into the Oracle...
asm-1.3.3.jar, asm-1.3.4.jar, asm-1.3.5.jar, asm-1.4.1.jar, asm-1.4.2.jar, asm-1.4.3.jar, asm-1.4.jar, asm-1.5.1.jar, asm-1.5.2.jar, asm-1.5.3.jar, asm-2.0.jar, asm-2.1.jar, asm-2.2.1-sources.jar, asm...
文档描述了在ASM算法在JAVA和MATLAB上的实现,并且有代码。
Oracle 11gR2 RAC ASM on RHEL6.4安装流程
汇编工具ASM汇编工具ASM汇编工具ASM汇编工具ASM汇编工具ASM
我学习spring程序,测试程序时.老出bug, 后来从网上找原因说asm.jar版本太低 现把好不容易找来的jar包共享给大家
examples of how to read arm asm code
Oracle 11gR2 RAC + ASM on AIX-6.1安装指导手册
包含如下oracleasm包: kmod-oracleasm-2.0.6.rh1-3.el6.x86_64.rpm oracleasm-2.0.8-4.el6_6.src.rpm oracleasm-2.0.8-6.el6_7.src.rpm oracleasm-2.0.8-8.el7.src.rpm oracleasm-2.0.8-15.el7.centos.src.rpm ...
3 Creating an Oracle Database Using DBCA 4 Managing the Database instance 5 Managing the ASM Instance 6 Configuring the Oracle Network Environment 7 Managing Database Storage Structures 8 ...