My Oracle Support Banner

After Creating a Physical Standby Using RMAN Restore Database From Service, REDO Apply Fails With ORA-01110, ORA-01157 (Doc ID 3063113.1)

Last updated on DECEMBER 12, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.

Symptoms

Creating a physical standby database using RMAN restore database from service (Doc ID 2283978.1) is succeeded.
However, REDO apply on physical standby database fails :

2024-12-11T11:37:30.126184+09:00
ALTER DATABASE RECOVER  managed standby database disconnect
2024-12-11T11:37:30.129702+09:00
Attempt to start background Managed Standby Recovery process (s1930)
Starting background process MRP0
2024-12-11T11:37:30.141208+09:00
MRP0 started with pid=36, OS id=22534
2024-12-11T11:37:30.142171+09:00
Background Managed Standby Recovery process started (s1930)
2024-12-11T11:37:35.159006+09:00
 Started logmerger process
2024-12-11T11:37:35.174224+09:00
PR00 (PID:22541): Managed Standby Recovery starting Real Time Apply
2024-12-11T11:37:35.195115+09:00
Errors in file <directory>/trace/<SID>_dbw0_22366.trc:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '<PATH>/users01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
PR00 (PID:22541): MRP0: Background Media Recovery terminated with error 1110
2024-12-11T11:37:35.356333+09:00
Errors in file <directory>/trace/<SID>_pr00_22541.trc:
ORA-01110: data file 7: '<PATH>/users01.dbf'
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '<PATH>/users01.dbf'
PR00 (PID:22541): Managed Standby Recovery not using Real Time Apply
stopping change tracking
2024-12-11T11:37:35.520057+09:00
Recovery Slave PR00 previously exited with exception 1110
2024-12-11T11:37:35.537117+09:00
Errors in file <directory>/trace/<SID>_mrp0_22534.trc:
ORA-01110: data file 7: '<PATH>/users01.dbf'
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '<PATH>/users01.dbf'
2024-12-11T11:37:35.537216+09:00
Background Media Recovery process shutdown (s1930)

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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