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

Last updated on APRIL 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.2.2 to 11.2.0.3 [Release 7.3.2 to 11.2]
Information in this document applies to any platform.
The solution applies to all version of physical standby databases on all platforms.


Goal

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

Thu Feb 09 20:21:11 EAT 2012
Errors in file /u01/app/oracle/admin/MMUGPROD/bdump/mmugprod_mrp0_27482.trc:
ORA-01111: name for data file 97 is unknown - rename to correct file
ORA-01110: data file 97: '/u01/app/oracle/product/10.2.0.5/db_1/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: '/u01/app/oracle/product/10.2.0.5/db_1/dbs/UNNAMED00097'
Thu Feb 09 20:21:11 EAT 2012
Errors in file /u01/app/oracle/admin/MMUGPROD/bdump/mmugprod_mrp0_27482.trc:
ORA-01111: name for data file 97 is unknown - rename to correct file
ORA-01110: data file 97: '/u01/app/oracle/product/10.2.0.5/db_1/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: '/u01/app/oracle/product/10.2.0.5/db_1/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: '/redo01/redo/MMUGPROD/redo8a.rdo'
'/u01/app/oracle/product/10.2.0.5/db_1/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

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