Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to deal with Oracle 10g RAC failure". In daily operation, I believe many people have doubts about how to deal with Oracle 10g RAC failure. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt of "how to deal with Oracle 10g RAC failure"! Next, please follow the editor to study!

OS:AIX 6.1

DB:Oracle 10g RAC

Question:

An instance of the node is down, and the parameter file lv_spfile cannot be found when starting the database.

Problem analysis:

Check the alert alarm log, and there is no database shutdown process or error message recently. It is suspected that a failure at the host or storage level has caused the database instance to go down.

When prompted to enter the parameter file directory, ls can see the parameter file, size, permissions, etc., but not recognized by the database.

It is suspected that the vg is not mounted.

Solution:

Lsvg view current disk group

Lsvg lv_oradata prompts you to report an error. Compared with another node, you can output the normal status and mount the lv_oradata manually.

Varyonvg lv_oradata

After the mount is successful, execute startup nomount to open the instance normally.

The alter database mount; instance was interrupted and the alarm log indicated that the control file could not be found.

The database is ready for open after trying to mount another vg.

At this point, the study on "how to deal with Oracle 10g RAC failure" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.