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

Bytes -------------------------------------------------------------------------------------------------------

Blog: http://blog.csdn.net/tianlesoftware

Email: dvd.dba@gmail.com

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Chat group: 40132017 chat 2 group: 69087192

-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.