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 MARCH 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 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/mymsdwk/MYMSDWK1/trace/MYMSDWK1_dbw0_115655.trc:
ORA-01157: cannot identify/lock data file 8003 - see DBWR trace file
ORA-01110: data file 8003: '+DATA/mymsdwk/tempfile/mig_temp02.1191.922354837'
ORA-17503: ksfdopn:2 Failed to open file +DATA/mymsdwk/tempfile/mig_temp02.1191.922354837
ORA-15012: ASM file '+DATA/mymsdwk/tempfile/mig_temp02.1191.922354837' does not exist
Errors in file /ora_dump/diag/rdbms/mymsdwk/MYMSDWK1/trace/MYMSDWK1_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/mymsdwk/tempfile/mig_temp02.1191.922354837'
File 8003 not verified due to error ORA-01157

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms