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:

Symptoms

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
2021-09-30T09:52:36.615649+00:00
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
Recovery interrupted!
...............

2021-09-30T09:52:37.237943+00:00
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

Cause

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