ORA-1157,ORA-1110, ORA-17503, ORA-01186 happened for Orphan tempfile In Standby Environment Of ADG whenever adding new datafiles into DB in primary environment
(Doc ID 2240623.1)
Last updated on NOVEMBER 02, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
The following type of error messages appear in standby side of ADG whenever customer tries to create new tablespaces or add new datafiles to pre-existing tablespaces
| Mon Nov 28 18:31:13 2016 Errors in file /ora_dump/diag/rdbms/<DB_UNIQUE_NAME>/<SID>/trace/<SID>_dbw0_115655.trc: ORA-01157: cannot identify/lock data file 8003 - see DBWR trace file ORA-01110: data file 8003: '+DATA/<DB_UNIQUE_NAME>/tempfile/mig_temp02.1191.922354837' ORA-17503: ksfdopn:2 Failed to open file +DATA/<DB_UNIQUE_NAME>/tempfile/mig_temp02.1191.922354837 ORA-15012: ASM file '+DATA/<DB_UNIQUE_NAME>/tempfile/mig_temp02.1191.922354837' does not exist Errors in file /ora_dump/diag/rdbms/<DB_UNIQUE_NAME>/<SID>/trace/<SID>_dbw0_115655.trc: ORA-01186: file 8003 failed verification tests ORA-01157: cannot identify/lock data file 8003 - see DBWR trace file ORA-01110: data file 8003: '+DATA/<DB_UNIQUE_NAME>/tempfile/mig_temp02.1191.922354837' File 8003 not verified due to error ORA-01157 |
Changes
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 |