一.RAC 删除数据库
This sectionexplains how to delete a RAC database with the DBCA. This process deletes adatabase and removes a database's initialization parameter files, instances,OFA structure, andOracle network configuration. However, this process does notremove datafiles if you placed the files on raw devices or on raw partitions.
使用DBCA删除数据库实例
To delete a database with the DBCA: 1. Start the DBCA on one of the nodes:
The DBCA Welcome page appears.
2. Select Oracle Real Application Clusters and click Next.
After you click Next, the DBCA displays theOperations page.
3. Select Delete a database, click Next, and the DBCAdisplays the List of Cluster Databases page.
4. If your user ID and password are not operating-systemauthenticated, then the List of Cluster Databases page displays the user nameand password fields. If these fields appear, then enter a user ID and passwordthat has SYSDBA privileges.
5. Select the database to delete and click Finish.
After you click Finish, the DBCA displays adialog to confirm the database and instances that the DBCA is going to delete.
6. Click OK to begin thedeletion of the database and its associated files, services, and environmentsettings, or click Cancel to stop the operation.
When you click OK, the DBCA continues theoperation and deletes all of the associated instances for this database. TheDBCA also removes the parameter files, password files, and oratab entries.
At this point, you have accomplished thefollowing:
· Deleted the selecteddatabase from the cluster
· Deleted highavailability services that were assigned to the database
· Deleted the OracleNet configuration for the database
· Deleted the OFAdirectory structure from the cluster
· Deleted the datafilesif the datafiles were not on raw devices
二.ASM 实例卸载
How to drop the ASM instance installed in aseperate Oracle Home for both RAC and non-RAC installations.
Solution
The outline of the steps involved are :
a) Backupall 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) Removethe ASM pfile/spfile.
f)Removing ASM entry in the file oratab
g) Wipeout 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 respectivedatabases.
3) Backup all the datafiles, logfiles, controlfiles, archivelogs, etc. that are currently using ASM storage, to tape or to filesystem (usingRMAN). This needs to be done for every database (ASM client) using ASM.
** NOTE: Please make sure you have the data secure before continuing to thenext step.
4) Find all the diskgroups: 'select * from v$asm_diskgroup;'
5) For each diskgroup listed above:' drop diskgroup including contents'
这里要注意的，要先在一个节点上将diskgroup dismount后， 再在另一个节点进行drop。不然会报：
ORA-15073: diskgroup DATA is mounted by another ASM instance
alter diskgroup dismount;
6) Shutdown all (RAC nodes) ASM instances.
7) On RAC install verify that all asm instances are stopped
$ORA_CRS_HOME/bin/crs_stat–t
look for ASM resources and make sure thetarget=offline
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.
srvctlremove asm -n <- Peform for all nodes of a RAC cluster
crs_stat|more <-make sure no asm resources exists
如：srvctl remove asm –n rac1, 如果删除不掉，就加上–f 参数。
11) If using asmlib (on Linux only), then
a. oracleasm listdisks
相关推荐