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 AUGUST 04, 2018

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

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.