Background Media Recovery terminated with ORA-1274 after adding a Datafile
(Doc ID 739618.1)
Last updated on JULY 27, 2024
Applies to:
Oracle Database Cloud Exadata Service - Version N/A and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
*** ***
Symptoms
Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual
environments, actual persons, living or dead, is purely coincidental and not intended in any manner.
For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:
Primary Database Name: PRIM
Standby Database Name: MYSTD
Directory Name: D:\ORADATA\ and all it's sub-directories
*************
Adding a Tablespace/Datafile in Primary Database causes the MRP on the Physical Standby Database to terminate with the Error below.
Note:- STANDBY_FILE_MANAGEMENT is set to MANUAL on the Standby Database.
ORA-01274: cannot add datafile '...dbf' - file could not be created
In Unix Environment you will get the below Message when try to restart the MRP
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 |
| Cause |
| Solution |
| For version < 12c and non CDB >12c |
| For 12c Database with PDBs |