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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【Oracle】How To Automate Cleanup Of Dead Connections And INACTIVEOracle
- How to re-create the ASMASM
- How to restore ASM based OCRRESTASM
- How to Clean Up After a Failed Oracle Clusterware (CRS) InstallationAIOracle
- ASM Installation Logs Location. [ID 1349705.1]ASM
- How To Change The Asm Rebalancing PowerASM
- How to Prepare Storage for ASM (Doc ID 452924.1)ASM
- ASM 11g New Features - How ASM Disk Resync WorksASM
- Oracle ASM How many allocation units per fileOracleASM
- Avast Cleanup PremiumASTREM
- How to Convert a Single-Instance ASM to Cluster ASM [ID 452758.1]ASM
- How to move ASM database files from one diskgroup to anotherASMDatabase
- How to use ASMCA in silent mode to configure ASMASM
- How To Clone An Existing RDBMS Installation Using OUI [ID 300062.1]UI
- How to copy a datafile from ASM to a file system not using RMANASM
- How To Upgrade ASM from 10.2 to 11.1 (RAC)ASM
- How to Copy ASM Files Across Nodes [ID 1147859.1]ASMROS
- ASM 11.2 Configuration KIT (ASM 11gR2 Installation & Configuration, Deinstallation, Upgrade, ASM JobASM
- svn報錯cleanup failed–previous operation has not finished; run cleanup if it was interrupte...AI
- How to free space from an ASM diskgroup? (Doc ID 1553744.1)ASM
- How to restore ASM based OCR after complete loss of the CRS diskgroupRESTASM
- How to move ASM spfile to a different disk group [ID 1082943.1]ASM
- How to Increase CSS Misscount in single instance ASM installations [ID 729878.1]CSSASM
- How to create user for oracle10g/11g asm instanceOracleASM
- Post Installation for Databases Created after Installation of 10.2.0.4.4Database
- How to Check ASM Login for Oracle Goldengate (OGG) ? [ID 1311784.1]ASMOracleGo
- Oracle FGA 的使用和cleanup audit trailsOracleAI
- How does ASM work with RAID where striping and mirroring are already built-in?ASMAIUI
- LDAP Server InstallationLDAServer
- Mysql MAC installationMySqlMac
- installation tips
- svn“Previous operation has not finished; run 'cleanup' if it was interrupted
- How To Setup ASM (11.2) On An Active/Passive Cluster (Non-RAC). [ID 1296124.1]ASM
- How to Download and Apply the Recommended WLS patch WDJ7 on WLS for 11g Grid Control Installation oAPP
- SVN操作報錯(亂碼浠vn cleanup鈥)
- 2.3.3.2 Application InstallationAPP
- .NET Core installation for DockerDocker
- How To Setup ASM (10.2 & 11.1) On An Active/Passive Cluster (Non-RAC). [ID 1319050.1]ASM