How to remove an ASM instance and its corresponding database(s) on WINDOWS

 

1) Shutdown all datbases 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) Remove the service for the instances

      ORADIM -DELETE -SID <sid> and ORADIM -DELETE -ASMSID <asm sid>

       to delete the services for the database(s)/instances

        If using RAC ... remove the asm service with .... svrctl remove asm -n <nodename>

3) Remove the PFILEs / SPFILEs and password files (orapw<sid>) for the ASM and Databases

       Default location: <ORACLE_HOME>/DATABASE

4) Delete / Remove any non ASM supporting directories

       BACKGROUND_DUMP_DEST
       USER_DUMP_DEST
       CORE_DUMP_DEST
       etc

5) Format the ASM disks

 

 

 

 

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資料表空間和資料檔案的關係，否則拒絕申請