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

This article mainly explains "asm disk group dependence leads to database self-startup error report how to do", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "asm disk group dependence caused by the database self-startup error report how to do" it!

Restart os found that the database did not start automatically, everything else started normally, and manual startup also reported an error.

[oracle@hca1] $srvctl start database-d orcl

PRCR-1079: Failed to start resource ora.orcl.db

CRS-5017: The resource action "ora.HCA1_CACHE.dg start" encountered the following error:

ORA-15032: not all alterations performed

ORA-15017: diskgroup "HCA1_CACHE" cannot be mounted

All the files on this disk group, including redo,spfile,datafile,tempfile,controlfile, have been migrated before, and there is no problem to restart the instance through srvctl, but instead of restarting the cluster, OS is restarted directly. It is found that the instance does not start automatically, but the database can be started manually through sqlplus.

[grid@hca1] $crs_stat-t

Name Type Target State Host

-

Ora... . _ 10G.dg ora... .up.type ONLINE ONLINE hca1

Ora... .ACHE.dg ora... .up.type ONLINE OFFLINE

Ora... .500G.dg ora... .up.type ONLINE ONLINE hca1

Ora... .ACHE.dg ora... .up.type ONLINE OFFLINE

Ora... .500G.dg ora... .up.type ONLINE ONLINE hca1

Ora... .ACHE.dg ora... .up.type ONLINE ONLINE hca1

Ora... .ER.lsnr ora... .er.type ONLINE ONLINE hca1

Ora... .N1.lsnr ora... .er.type ONLINE ONLINE hca1

Ora.OCR.dg ora... .up.type ONLINE ONLINE hca1

Ora.asm ora.asm.type ONLINE ONLINE hca1

Ora.cvu ora.cvu.type ONLINE ONLINE hca1

Ora.gsd ora.gsd.type OFFLINE OFFLINE

Ora... .SM1.asm application ONLINE ONLINE hca1

Ora... .A1.lsnr application ONLINE ONLINE hca1

Ora.hca1.gsd application OFFLINE OFFLINE

Ora.hca1.ons application ONLINE ONLINE hca1

Ora.hca1.vip ora... .t1.type ONLINE ONLINE hca1

Ora... .SM2.asm application ONLINE ONLINE hca2

Ora... .A2.lsnr application ONLINE ONLINE hca2

Ora.hca2.gsd application OFFLINE OFFLINE

Ora.hca2.ons application ONLINE ONLINE hca2

Ora.hca2.vip ora... .t1.type ONLINE ONLINE hca2

Ora... .network ora... .rk.type ONLINE ONLINE hca1

Ora.oc4j ora.oc4j.type ONLINE ONLINE hca1

Ora.ons ora.ons.type ONLINE ONLINE hca1

Ora.orcl.db ora... .se.type ONLINE OFFLINE

Ora... .est.svc ora... .ce.type ONLINE OFFLINE

Ora... .ry.acfs ora... .fs.type ONLINE ONLINE hca1

Ora.scan1.vip ora... .ip.type ONLINE ONLINE hca1

These two disk groups that show offline have been deleted successfully through drop diskgroup before. They do not seem to have been deleted clean. They are deleted manually.

[grid@hca1] $srvctl remove diskgroup-g hca1_cache

PRCA-1002: Failed to remove CRS resource ora.HCA1_CACHE.dg for ASM Disk Group hca1_cache

PRCR-1028: Failed to remove resource ora.HCA1_CACHE.dg

PRCR-1072: Failed to unregister resource ora.HCA1_CACHE.dg

CRS-0222: Resource 'ora.HCA1_CACHE.dg' has dependency error.

[oracle@hca1] $srvctl remove diskgroup-g hca2_cache

PRCA-1002: Failed to remove CRS resource ora.HCA2_CACHE.dg for ASM Disk Group hca2_cache

PRCR-1028: Failed to remove resource ora.HCA2_CACHE.dg

PRCR-1072: Failed to unregister resource ora.HCA2_CACHE.dg

CRS-0222: Resource 'ora.HCA2_CACHE.dg' has dependency error.

Prompt for dependency, force deletion

[oracle@hca1] $srvctl remove diskgroup-g hca1_cache-f

[oracle@hca1] $srvctl remove diskgroup-g hca2_cache-f

[grid@hca1] $crs_stat-t

Name Type Target State Host

-

Ora... . _ 10G.dg ora... .up.type ONLINE ONLINE hca1

Ora... .500G.dg ora... .up.type ONLINE ONLINE hca1

Ora... .500G.dg ora... .up.type ONLINE ONLINE hca1

Ora... .ACHE.dg ora... .up.type ONLINE ONLINE hca1

Ora... .ER.lsnr ora... .er.type ONLINE ONLINE hca1

Ora... .N1.lsnr ora... .er.type ONLINE ONLINE hca1

Ora.OCR.dg ora... .up.type ONLINE ONLINE hca1

Ora.asm ora.asm.type ONLINE ONLINE hca1

Ora.cvu ora.cvu.type ONLINE ONLINE hca1

Ora.gsd ora.gsd.type OFFLINE OFFLINE

Ora... .SM1.asm application ONLINE ONLINE hca1

Ora... .A1.lsnr application ONLINE ONLINE hca1

Ora.hca1.gsd application OFFLINE OFFLINE

Ora.hca1.ons application ONLINE ONLINE hca1

Ora.hca1.vip ora... .t1.type ONLINE ONLINE hca1

Ora... .SM2.asm application ONLINE ONLINE hca2

Ora... .A2.lsnr application ONLINE ONLINE hca2

Ora.hca2.gsd application OFFLINE OFFLINE

Ora.hca2.ons application ONLINE ONLINE hca2

Ora.hca2.vip ora... .t1.type ONLINE ONLINE hca2

Ora... .network ora... .rk.type ONLINE ONLINE hca1

Ora.oc4j ora.oc4j.type ONLINE ONLINE hca1

Ora.ons ora.ons.type ONLINE ONLINE hca1

Ora.orcl.db ora... .se.type ONLINE ONLINE hca1

Ora... .est.svc ora... .ce.type ONLINE ONLINE hca2

Ora... .ry.acfs ora... .fs.type ONLINE ONLINE hca1

Ora.scan1.vip ora... .ip.type ONLINE ONLINE hca1

The disk group of offline has disappeared, but boot still indicates that the old disk group cannot mount

[grid@hca1] $srvctl start database-d orcl

Check database properties

[grid@hca1] $srvctl config database-d orcl-a

Database unique name: orcl

Database name:

Oracle home: / oracle/app/oracle/product/11.2.0/db_1

Oracle user: oracle

Spfile: + HCA1_SDD1_500G/orcl/spfileorcl.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: orcl

Database instances: orcl1,orcl2

PRCD-1012: Failed to retrieve disk group list for database orcl.

PRCR-1035: Failed to look up CRS resource ora.HCA1_CACHE.dg for orcl

PRCA-1000: ASM Disk Group HCA1_CACHE does not exist

PRCR-1001: Resource ora.HCA1_CACHE.dg does not exist

Check a normal 11grac, and through srvctl config db-d orcl-a, you can see a line Disk Groups: DATA. It seems that this dependency option has not been changed.

[grid@hca1] $srvctl modify db-d orcl-a hca1_sdd1_500g

PRCD-1163: Failed to modify database orcl

PRCR-1071: Failed to register or update resource ora.orcl.db

CRS-0245: User doesn't have enough privilege to perform the operation

[root@hca1] # / oracle/app/11.2.0/grid/bin/srvctl modify db-d orcl-a hca1_sdd1_500g

[root@hca1] # / oracle/app/11.2.0/grid/bin/srvctl config db-d orcl-a

Database unique name: orcl

Database name:

Oracle home: / oracle/app/oracle/product/11.2.0/db_1

Oracle user: oracle

Spfile: + HCA1_SDD1_500G/orcl/spfileorcl.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: orcl

Database instances: orcl1,orcl2

Disk Groups: HCA1_SDD1_500G

Mount point paths:

Services: test

Type: RAC

Database is enabled

Database is administrator managed

Start again successfully

[grid@hca1] $srvctl start database-d orcl

If you delete the disk group that originally created the instance after deleting the migrated database to a new disk group, not only will srvctl modify the spfile, but also modify the dependent disk group property

At this point, I believe you have a deeper understanding of "asm disk group dependence leads to database self-startup error report how to do", might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.