`
qjoycn
  • 浏览: 1217704 次
文章分类
社区版块
存档分类
最新评论

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表空间和数据文件的关系,否则拒绝申请

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics