Standby Database Fails to Start with Error ORA-39510 / CRS-2800 / (Linux-x86_64 Error: 28: No space left on device) After All Disk Group in Intermediate Status
(Doc ID 2385264.1)
Last updated on JULY 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Single instance Grid Infrastructure Restart Environment.
- Grid Infrastructure home is seen with more than 97000+ aud files.
- File system which has Grid Home is not 100% used in space.
- SQL> startup mount;
ORA-39510: CRS error performing start on instance 'instancename' on 'dbname'
CRS-2800: Cannot start resource 'ora.ARCH.dg' as it is already in the INTERMEDIATE state on server 'hostname'
CRS-0223: Resource 'ora.dbname.db' has placement error.
clsr_start_resource:260 status:223
clsrapi_start_db:start_asmdbs status:223
CRS-2800: Cannot start resource 'ora.ARCH.dg' as it is already in the INTERMEDIATE state on server 'hostname'
CRS-0223: Resource 'ora.dbname.db' has placement error.
clsr_start_resource:260 status:223
clsrapi_start_db:start_asmdbs status:223
- All ASM disk group is in Intermediate status.
- ASM alert log does not have any new entries after shutdown.
Changes
Standby database instance was shutdown during maintenance.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |