UNNAMED data file in standby after adding new data file in primary – ORA-01111, ORA-01110, ORA-01157 , ORA-01274

Dear Folks,

We came across missing data file in standby after adding new data file in primary which causes MRP job terminate. This could be due to following reasons.

**Either we don't have sufficient  disk space/ASM available at standby host.
**standby_file_management parameter set to MANUAL.

i.e, if standby_file_management parameter is MANUAL on standby, MRP processes couldn't apply archives due to this wrong parameter settings, a UNNAMED data file being created at $ORACLE_HOME/dbs location.

From alert log
==========

File #59 added to control file as 'UNNAMED00059' because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
Errors with log +JDUAUA_FRA/xcmrc_stby/archivelog/2019_02_13/thread_1_seq_9619.319.1000088461
MRP0: Background Media Recovery terminated with error 1274
Errors in file /
ORA-01274: cannot add datafile '+JDUAUA_DATA/xcmrc/datafile/apps_ts_tx_data.299.1000076027' - file could not be created
Managed Standby Recovery not using Real Time Apply

Recovery stopped due to failure in applying recovery marker (opcode 17.30).

So from above log, we clearly identified missing data file=59

SQL> select file#,name from v$datafile where file#=59;

     FILE#

----------

NAME

--------------------------------------------------------------------------------

        59

+JDUAUA_DATA_DATA/xcmrc/datafile/apps_ts_tx_data.299.1000076027

Identify the missing datafile from standby

     FILE#

----------

NAME

--------------------------------------------------------------------------------

        59

/u01/app/oraxx/JDUAUA_DATA/db/tech_st/11.2.0/dbs/UNNAMED00059

Hence created missing data file in Standby.

SQL > alter database create datafile '/u01/app/oraxx/JDUAUA_DATAdb/tech_st/11.2.0/dbs/UNNAMED00059' as '+JDUAUA_DATA_DATA' size 5576m

Database altered.

Enabled standby_file_management to AUTO

SQL> alter system set standby_file_management=AUTO sid='*';

System altered.

Start MRP process.

===========

SQL> recover managed standby database disconnect from session;

Media recovery complete.

Thanks.

Sreeharsha