ORA-01274: cannot add datafile '/oracle/SID/sapdata2/dat_19/dat.data19' - file could not be created Recovery interrupted!

If the Parameter STANDBY_FILE_MANAGEMENT is set to MANUAL , we will get below error in Standby Databae (DR) while adding a datafile in Primary Database. And this will bring the DR out of sync. " ORA-01274: cannot add datafile '/oracle/SID/sapdata2/dat_19/dat.data19' - file could not be created Recovery interrupted!" Solution : On standby(DR) database: SQL> select name from v$datafile where name like '%UNNAMED00039%'; NAME -------------------------------------------------------------------------------- /oracle/SID/112_64/dbs/UNNAMED00039 On production database: SQL> select name from v$datafile where file# = 39; NAME -------------------------------------------------------------------------------- /oracle/SID/sapdata2/dat_19/dat.data19 And finally on standby database alter the database using below command: SQL> alter database create datafile '/oracle/SID/112_64/dbs/UNNAMED00039' as '/oracle/SID/sapdata2/dat_19/dat.data19'; Recomendation :: Permanently set  STANDBY_FILE_MANAGEMENT to AUTO in Standby Database.