Hybriddb for MySQL creates a database because of the bad ASM disk block of the Virtual Machine RAC.

Source: Internet
Author: User

2011.11.23 the ASM disk block of the Virtual Machine RAC results in DB Reconstruction
We just built a 10gr2 rac environment on a company's PC machine with vmware workstation8 and built it with bare equipment + ASM. After the installation is successful, I accidentally restarted the host directly. As a result, when I started the VM again, I was prompted that the disk was damaged. However, a problem occurred when starting RAC. At the beginning, the following resources cannot be started with other resources:
Ora. node1.LISTENER _ NODE1.lsnr
Ora. node2.LISTENER _ NODE2.lsnr
Ora. RAC. RAC1.inst
Ora. RAC. RAC2.inst
Ora. RAC. db
See the specific startup process:
[Oracle @ node1 bin] $ crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora... C1.inst application OFFLINE
Ora... C2.inst application OFFLINE
Ora. RAC. db application OFFLINE
Ora... SM1.asm application OFFLINE
Ora... E1.lsnr application OFFLINE
Ora. node1.gsd application OFFLINE
Ora. node1.ons application OFFLINE
Ora. node1.vip application OFFLINE
Ora... SM2.asm application OFFLINE
Ora... E2.lsnr application OFFLINE
Ora. node2.gsd application OFFLINE
Ora. node2.ons application OFFLINE
Ora. node2.vip application OFFLINE
[Oracle @ node1 bin] $ crs_start-all
Attempting to start 'ora. node1.vip 'on member 'node1'
Attempting to start 'ora. node2.vip 'on member 'node2'
Start of 'ora. node1.vip 'on member 'node1' succeeded.
Start of 'ora. node2.vip 'on member 'node2' succeeded.
Attempting to start 'ora. node1.ASM1. asm 'on member 'node1'
Attempting to start 'ora. node2.ASM2. asm 'on member 'node2'
Start of 'ora. node2.ASM2. asm 'on member 'node2' succeeded.
Attempting to start 'ora. RAC. RAC2.inst 'on member 'node2'
Start of 'ora. RAC. RAC2.inst 'on member 'node2' failed.
Node1: CRS-1018: Resource ora. node2.vip (application) is already running on node2

 


Node1: CRS-1018: Resource ora. node2.vip (application) is already running on node2

 


Start of 'ora. node1.ASM1. asm 'on member 'node1' succeeded.
Attempting to start 'ora. RAC. RAC1.inst 'on member 'node1'
Start of 'ora. RAC. RAC1.inst 'on member 'node1' failed.
Node2: CRS-1018: Resource ora. node1.vip (application) is already running on node1

 


Node2: CRS-1018: Resource ora. node1.vip (application) is already running on node1

 


CRS-1002: Resource 'ora. node1.ons 'is already running on member 'node1'


CRS-1002: Resource 'ora. node2.ons 'is already running on member 'node2'


Attempting to start 'ora. node1.gsd' on member 'node1'
Attempting to start 'ora. RAC. db' on member 'node1'
Attempting to start 'ora. node2.gsd' on member 'node2'
Start of 'ora. node1.gsd' on member 'node1' succeeded.
Start of 'ora. node2.gsd' on member 'node2' succeeded.
Start of 'ora. RAC. db' on member 'node1' failed.
Attempting to start 'ora. RAC. db' on member 'node2'
Start of 'ora. RAC. db' on member 'node2' failed.
CRS-1006: No more members to consider


CRS-0215: cocould not start resource 'ora. RAC. RAC1.inst '.


CRS-0215: cocould not start resource 'ora. RAC. RAC2.inst '.


CRS-0215: cocould not start resource 'ora. RAC. db '.


CRS-0223: Resource 'ora. node1.LISTENER _ NODE1.lsnr 'has placement error.


CRS-0223: Resource 'ora. node1.ons 'has placement error.


CRS-0223: Resource 'ora. node2.LISTENER _ NODE2.lsnr 'has placement error.


CRS-0223: Resource 'ora. node2.ons 'has placement error.


[Oracle @ node1 bin] $ crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora... C1.inst application ONLINE OFFLINE
Ora... C2.inst application ONLINE OFFLINE
Ora. RAC. db application ONLINE OFFLINE
Ora... SM1.asm application ONLINE node1
Ora... E1.lsnr application OFFLINE
Ora. node1.gsd application ONLINE node1
Ora. node1.ons application ONLINE node1
Ora. node1.vip application ONLINE node1
Ora... SM2.asm application ONLINE node2
Ora... E2.lsnr application OFFLINE
Ora. node2.gsd application ONLINE node2
Ora. node2.ons application ONLINE node2
Ora. node2.vip application ONLINE node2
Try to increase lsnr first:
[Oracle @ node1 bin] $ crs_start ora. node1.LISTENER _ NODE1.lsnr
Attempting to start 'ora. node1.LISTENER _ NODE1.lsnr 'on member 'node1'
Start of 'ora. node1.LISTENER _ NODE1.lsnr 'on member 'node1' succeeded.
[Oracle @ node1 bin] $ crs_start ora. node2.LISTENER _ NODE2.lsnr
Attempting to start 'ora. node2.LISTENER _ NODE2.lsnr 'on member 'node2'
Start of 'ora. node2.LISTENER _ NODE2.lsnr 'on member 'node2' succeeded.
Start two inst instances, and then there is a problem. inst is not Farah:
[Oracle @ node1 bin] $ crs_start ora. RAC. RAC1.inst
Attempting to start 'ora. RAC. RAC1.inst 'on member 'node1'
Start of 'ora. RAC. RAC1.inst 'on member 'node1' failed.
Node2: CRS-1018: Resource ora. node1.vip (application) is already running on node1

  • 1
  • 2
  • Next Page

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.