How to cleanup ASM installation
How to cleanup ASM installation (RAC and Non-RAC) [ID 311350.1]
The outline of the steps involved are :
a) Backup all the ASM client database files stored on the diskgroups.
b) Dropping all the diskgroups.
c) Removing ASM resource from CRS (* RAC specific)
d) Removing ASM disk signature (In case of asmlib)
e) Remove the ASM pfile/spfile.
f) Removing ASM entry in the file oratab
g) Wipe out the disks header using dd
Following are the steps to be followed:
1) Log into the ASM instance and do 'select * from v$asm_client;'
2) For each instance listed above, stop the respective databases.
3) Backup all the datafiles, logfiles, controlfiles, archive logs, etc. that are currently using ASM storage, to tape or to filesystem (using RMAN). This needs to
be done for every database (ASM client) using ASM.
** NOTE: Please make sure you have the data secure before continuing to the next step.
4) Find all the diskgroups: 'select * from v$asm_diskgroup'
5) For each diskgroup listed above:
' drop diskgroup including contents'
6) Shutdown all(RAC nodes) ASM instances.
7) On RAC install verify that all asm instances are stopped
$ORA_CRS_HOME/bin/crst_stat |more
8) For single instance install run the following script.:
$ORACLE_HOME/bin/localconfig delete
* This cleans up the CSSD configuration.
9) Invoke OUI, and now de-install the ASM Oracle home.
10) For RAC install, remove the asm related resource.
srvctl remove asm -n
crs_stat |more
11) If using asmlib (on Linux only), then
a. oracleasm listdisks
b. oracleasm deletedisks (do this for every disk listed above)
c. oracleasm listdisks (to verify they have been deleted)
d. on other RAC nodes: oracleasm listdisks (to verify they have been deleted too)
e. On all nodes(RAC) :
As root run:
# /etc/init.d/oracleasm stop
# /etc/init.d/oracleasm disable
12) delete the ASM pfile or spfile
13) in the file oratab, remove the line relative to the ASM instance
14) clean out the disks headers using the dd command:
for example: dd if=/dev/zero f=/dev/ bs=1024k count=50
15) Finally clean out the possible remaining socket files as explained in the following note:
Listener Fails To Start With IPC Permission Errors (TNS-12546 TNS-12555 TNS-00516 TNS-00525) (Doc ID 434062.1)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24867586/viewspace-713955/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to Increase CSS Misscount in single instance ASM installations [ID 729878.1]CSSASM
- Avast Cleanup PremiumASTREM
- IOMESH Installation
- 2.3.3.2 Application InstallationAPP
- A Tomcat 8.0 installation is expectedTomcat
- 07-Plugin ‘scala’ is incompatible with this installationPlugin
- Include manifest for over-the-air installationAI
- Adding Drivers into VMWare ESXi Installation Image
- SVN操作報錯(亂碼浠vn cleanup鈥)
- How to ssh
- TortoiseSVN 執行清理( cleanUp )失敗的解決方案
- Windows Server 2019 Installation 安裝.net 3.5WindowsServer
- How to find dependency
- 【ASM】Oracle asm刪除磁碟組注意事項ASMOracle
- 【ASM】ASM磁碟頭被重寫,如何修復ASM
- After mysql installation, we need to change the password of root as belowMySql
- goldengate + asm + racGoASM
- gnu inline asminlineASM
- 【ASM】ASM啟動無法找到spfile問題原因ASM
- 從定位資料塊所在ASM磁碟到ASM strippingASM
- [譯] WebAssembly: How and whyWeb
- How OpenStack integrates with Ceph?
- How to Build a Cybersecurity CareerUI
- CISO之What & How
- How to Restart Qt ApplicationRESTQTAPP
- How Python list works?Python
- How to Install psql on MacSQLMac
- How to Install LibreOffice on UbuntuUbuntu
- Installation failed with message INSTALL_FAILED_USER_RESTRICTED錯誤AIREST
- 安裝Docker Desktop報錯WSL 2 installation is incompleteDocker
- ASM叢集檔案系統ACFS(ASM Cluster File System)ASM
- ASM Metadata Dump UtilityASM
- ASM磁碟組限制ASM
- 4.5.1.1 srvctl add asmASM
- Android Transform + ASM 初探AndroidORMASM
- RAC+ASM+DATAGUARDASM
- ASM Fast Mirror ResyncASMAST
- ASM(Automatic Storage Management)ASM
- svn“Previous operation has not finished; run ‘cleanup‘ if it was interrupted“報錯的解決方法