Skip to Main Content

Query in Read-Only Physical Stanby get ORA-01157 error

LinziJun 15 2020 — edited Sep 8 2020

So we are trying to use read-only physical standby (Primary database Oracle Enterprise edition 12.2 RAC, with single instance standby) for BI publisher reports. Some reports works and some run into the following error:

ORA-01157: cannot identify/lock data file 1039 - see DBWR trace file

ORA-01110: data file 1039: '/u02/c2mprd/c2mprd/tempfile/temp.339.1026736315'

01157. 00000 -  "cannot identify/lock data file %s - see DBWR trace file"

*Cause:    The background process was either unable to find one of the data

           files or failed to lock it because the file was already in use.

           The database will prohibit access to this file but other files will

           be unaffected. However the first instance to open the database will

           need to access all online data files. Accompanying error from the

           operating system describes why the file could not be identified.

*Action:   Have operating system make file available to database. Then either

           open the database or do ALTER SYSTEM CHECK DATAFILES.

Am I supposed to create those temporary files?

Also, it sounds like for physical standby (read-only) to use for BI-publisher, I should be doing:

Has anyone run into the same issue and how you resolved it? Thank you!

Post Details
Added on Jun 15 2020