Upon Primary Creation Of Tablespace/Add datafile, Standby MRP(Media Recovery) failing with ORA-01110,ORA-01565 and ORA-27037
(Doc ID 2811172.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
Standby Alert log,
Recovery was unable to create the file as a new OMF file.
MRP0 (PID:6306): MRP0: Background Media Recovery terminated with error 1274
Errors in file /refresh/home/app/oracle/diag/rdbms/<SID>/<SID>/trace/<SID>_mrp0_6306.trc:
ORA-01274: cannot add data file that was originally created as '/refresh/home/app/oracle/oradata/<SID>/users02.dbf'
MRP0 (PID:6306): Managed Standby Recovery not using Real Time Apply
Errors in file /refresh/home/app/oracle/diag/rdbms/<SID>/<SID>/trace/<SID>_mz00_16532.trc:
ORA-01110: data file 8: '/refresh/home/app/oracle/product/19.3.0/dbs/UNNAMED00008'
ORA-01565: error in identifying file '/refresh/home/app/oracle/product/19.3.0/dbs/UNNAMED00008'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
Checker run found 1 new persistent data failures
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