We are getting this error,
File #33 added to control file as 'UNNAMED00033'.
Originally created as:
'/u01/app/oracle/oradata/SRCDB/datafile/o1_mf_sysaux_j8wxgdyp_.dbf'
Recovery was unable to create the file as a new OMF file.
PR00 (PID:18366): MRP0: Background Media Recovery terminated with error 1274
Non critical error ORA-48113 caught while writing to trace file "/u01/app/oracle/diag/rdbms/trcdb/TRCDB/trace/TRCDB_pr00_18366.trc"
Error message:
Writing to the above trace file is disabled for now...
2021-05-02T05:51:22.622641-04:00
Errors in file /u01/app/oracle/diag/rdbms/trcdb/TRCDB/trace/TRCDB_pr00_18366.trc:
ORA-01274: cannot add data file that was originally created as '/u01/app/oracle/oradata/SRCDB/datafile/o1_mf_sysaux_j8wxgdyp_.dbf'
PR00 (PID:18366): Managed Standby Recovery not using Real Time Apply
2021-05-02T05:51:35.464556-04:00
Recovery interrupted!
2021-05-02T05:51:37.129072-04:00
Non critical error ORA-48180 caught while writing to trace file "/u01/app/oracle/diag/rdbms/trcdb/TRCDB/trace/TRCDB_mz00_18939.trc"
Error message: Linux-x86_64 Error: 28: No space left on device
Additional information: 1
Writing to the above trace file is disabled for now...
2021-05-02T05:51:42.679478-04:00
IM on ADG: Start of Empty Journal
IM on ADG: End of Empty Journal
Recovered data files to a consistent state at change 4792358
stopping change tracking
2021-05-02T05:51:42.682605-04:00
Errors in file /u01/app/oracle/diag/rdbms/trcdb/TRCDB/trace/TRCDB_pr00_18366.trc:
ORA-01274: cannot add data file that was originally created as '/u01/app/oracle/oradata/SRCDB/datafile/o1_mf_sysaux_j8wxgdyp_.dbf'
2021-05-02T05:51:42.728424-04:00
Background Media Recovery process shutdown (TRCDB)
This error generally occurs when the standby do not has the required space to create the datafile.
Just add the space in the database mount point .
SQL> alter system set standby_file_management='MANUAL'; System altered. SQL> show parameter standby_file_management NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ standby_file_management string MANUAL SQL> alter database create datafile '/u01/app/oracle/product/version/db_1/dbs/UNNAMED00033' as new; Database altered. SQL> select TABLESPACE_NAME,FILE_NAME from dba_data_files where TABLESPACE_NAME='SYSAUX'; TABLESPACE_NAME FILE_NAME ----------------------------- ----------------------------------------------- SYSAUX /u01/app/oracle/oradata/TRCDB/datafile/o1_mf_sysaux_j1ypkmx8_.dbfStart managed recovery.
SQL> recover managed standby database disconnect from session; Media recovery complete. SQL> select TABLESPACE_NAME,FILE_NAME from dba_data_files where TABLESPACE_NAME='SYSAUX'; TABLESPACE_NAME FILE_NAME ----------------------------- ----------------------------------------------- SYSAUX /u01/app/oracle/oradata/TRCDB/datafile/o1_mf_sysaux_j1ypkmx8_.dbf SYSAUX /u01/app/oracle/oradata/TRCDB/datafile/o1_mf_sysaux_j8wybm5n_.dbf SQL> alter system set standby_file_management='AUTO'; System altered.