Amazing Tips to Fix Broken Oracle ASM Instance!!

 Author: Alex Burnham

 Page: 1 2

Automatic Storage Management is a great feature offered in Oracle Database 10g that simplifies the task of managing database systems and storage environments. The ASM disk group allows database administrators to easily and dynamically add or remove disks for a particular disk group without interrupting the database operation.

Increasing the size of the disk is a common task accomplished by most database administrators however sometimes it happens that the disk gets broken and we have to recreate it. In this article we will discuss some great tips that will help you fix the problem of broken Oracle ASM instance and will discuss how we can re-configure the ASM disk. Article Continues below...

Solution – I:

Following below steps will prevent ORA-00600 error. In this procedure you will have to stop ASM on all the nodes.

Stop ASM:

First of all you will have to stop ASM on every nodes.

Start ASM:

Now start the ASM.

Solution – II:

Below solution can help you get the backup back up and running. The difference between this solution and the Solution-I is that here you will have to stop ASM on all the nodes that have thrown Oracle ORA-00600 error.

Stop ASM:

First of all you will have to shutdown ASM on those nodes that have thrown Oracle ORA-00600 error.

Shutdown Database Instance:

Now you will need to shutdown your database instance on another node

Kill ASM Instance:

Now you will have to kill the ASM instance on the working node. You can kill it by using kill -9 <process_id> on the PMON process. Now the ASM instance you killed will be automatically restarted and the recovery session will be performed.

Start ASM:

Now you will have to start the ASM instance that has thrown Oracle ORA-00600 error. Make sure that all diskgroups are mounted.

Solution – III:

This solution will help you deal with the situation where you have to re-configure the ASM disk due to loss of ASM disk and all the db files were on there.

Create Disk Partition:

First of all you will have to create a disk partition for /DEV/SDC/

Re-configure ASM:

In this step you will have to re-configure ASM again such as creating ASM disks etc.

When you un-install ASM software installation then it must be ensured that you have removed all references. If ASM database folder BDUMP/UDUMP/.. is left in the ORA_BASE then it should be removed, inventory should be cleaned and the entries from ORATAB file should be removed. I went through this mess with Oracle support. It didn't work.

Re-install Database:

If you have lost the binaries then you will have to do full installation of Oracle 10g Database software otherwise you need not to re-install the software to add or replace the disk group or disk.

Re-create RAC Database:

Finally you will have to re-create the RAC database. Continued...

 Page: 1 2

 More Oracle Articles, Database Articles and DBA Tips
   Database Security: Step by step guideline
   Step by Step Guide to Oracle Parsing
   Explore the Secrets of Oracle Parallel Query!!
   Important Oracle Issues and Solutions: A Must Read!!
   SQL Injection Attacks - Are you safe?