My Oracle Support Banner

How to resolve ORA-01111 ORA-01110 ORA-01157 in a physical standby database (Doc ID 1416554.1)

Last updated on OCTOBER 27, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.2.2 to 11.2.0.3 [Release 7.3.2 to 11.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
The solution applies to all version of physical standby databases on all platforms.


Goal

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Database Name: MMUGPROD

********

The physical standby recovery process was terminated with the error below:

Thu Feb 09 20:21:11 EAT 2012
Errors in file /<path>/MMUGPROD/bdump/mmugprod_mrp0_27482.trc:
ORA-01111: name for data file 97 is unknown - rename to correct file
ORA-01110: data file 97: '/<oracle_home path>/dbs/UNNAMED00097'
ORA-01157: cannot identify/lock data file 97 - see DBWR trace file
ORA-01111: name for data file 97 is unknown - rename to correct file
ORA-01110: data file 97: '/<oracle_home path>/dbs/UNNAMED00097'
Thu Feb 09 20:21:11 EAT 2012
Errors in file /<path>/MMUGPROD/bdump/mmugprod_mrp0_27482.trc:
ORA-01111: name for data file 97 is unknown - rename to correct file
ORA-01110: data file 97: '/<oracle_home path>/dbs/UNNAMED00097'
ORA-01157: cannot identify/lock data file 97 - see DBWR trace file
ORA-01111: name for data file 97 is unknown - rename to correct file
ORA-01110: data file 97: '/<oracle_home path>/dbs/UNNAMED00097'
Thu Feb 09 20:21:11 EAT 2012
MRP0: Background Media Recovery process shutdown (MMUGPROD)
Thu Feb 09 20:21:11 EAT 2012
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
Thu Feb 09 20:23:25 EAT 2012
Primary database is in MAXIMUM PERFORMANCE mode
RFS[13]: Successfully opened standby log 8: '/<path>/MMUGPROD/redo8a.rdo'
'/<oracle_home path>/dbs/UNNAMED00097
Thu Feb 09 20:21:11 EAT 2012

How to resolve the errors so that the recovery process could proceed so that the physical standby could be in sync with the primary database?

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.