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 laterOracle 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)
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 |