STANDBY Alert Log Shows errors For Pdbseed Tempfile ORA-1110 ORA-1157 ORA-17503 ORA-15173

(Doc ID 2303577.1)

Last updated on SEPTEMBER 30, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Observing ORA-15173 error in Standby db alert log file for seed pdb:

ORA-01157: cannot identify/lock data file 2002 - see DBWR trace file
ORA-01110: data file 2002: '+DATA/SUSC1PRD_STBY/fdb039e555681306e04400163e5bea5f/datafile/pdbseed_temp012016-03-16_03-16-49-pm.dbf'
ORA-17503: ksfdopn:2 Failed to open file +DATA/SUSC1PRD_STBY/fdb039e555681306e04400163e5bea5f/datafile/pdbseed_temp012016-03-16_03-16-49-pm.dbf
ORA-15173: entry 'fdb039e555681306e04400163e5bea5f' does not exist in directory 'SUSC1PRD_STBY'

Changes

 Checking ASM we can see there is a link to the pdb seed tempfile:

ASMCMD [+DATA/SUSC1DEV/FDB039E555681306E04400163E5BEA5F/DATAFILE] > ls -l
Type Redund Striped Time Sys Name
DATAFILE UNPROT COARSE JUN 03 19:00:00 Y SYSAUX.266.902846341
DATAFILE UNPROT COARSE JUN 03 19:00:00 Y SYSTEM.267.902846341
TEMPFILE UNPROT COARSE MAY 30 00:00:00 N pdbseed_temp012016-02-03_02-39-42-PM.dbf => +DATA/SUSC1DEV/2AE3C4AD52776FA5E05400144FF82894/TEMPFILE/TEMP.268.902846385
ASMCMD [+DATA/SUSC1DEV/FDB039E555681306E04400163E5BEA5F/DATAFILE] >   << shows ASM link name

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