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