ORA-01274: cannot add datafile on standby database



File #17 added to control file as 'UNNAMED00017' because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
MRP0: Background Media Recovery terminated with error 1274
Errors in file /u01/app/oracle/diag/rdbms/test/test2/trace/test2_pr00_261555.trc:
ORA-01274: cannot add datafile '+DATA01/test02/datafile/fct_ir_ic_rated_201710_data.15961.957834065' - file could not be created
Fri Oct 20 01:01:57 2017
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Fri Oct 20 01:04:54 2017
Recovery stopped due to failure in applying recovery marker (opcode 17.30).
Datafiles are recovered to a consistent state at change 8889714250266 but controlfile could be ahead of datafiles.


SQL> show parameter standby_file_management

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
standby_file_management              string      MANUAL


SQL> select file#, name from v$datafile where file#=17;
     FILE# NAME
--------------------------------------------------------------------------------
        17 /u01/app/oracle/product/11.2.0.4/dbhome_2/dbs/UNNAMED00017


SQL> alter database create datafile '/u01/app/oracle/product/11.2.0.4/dbhome_2/dbs/UNNAMED00017' as '+DATA01/test02/datafile/fct_ir_ic_rated_201710_data.15961.957834065';
alter database create datafile '/u01/app/oracle/product/11.2.0.4/dbhome_2/dbs/UNNAMED00017' as '+DATA01/test02/datafile/fct_ir_ic_rated_201710_data.15961.957834065'
*
ERROR at line 1:
ORA-01276: Cannot add file
+DATA01/test02/datafile/fct_ir_ic_rated_201710_data.15961.957834065.  File has
an Oracle Managed Files file name.

SQL> alter database create datafile '/u01/app/oracle/product/11.2.0.4/dbhome_2/dbs/UNNAMED00017' as '+DATA01';
Database altered.

SQL> select file#, name from v$datafile where file#=17;
     FILE# NAME
--------------------------------------------------------------------------------
        17 +DATA01/test/datafile/fct_ir_ic_rated_201710_data.7440.958128309

SQL>  ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO scope=both sid='*';
System altered.

SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.

SQL> select process, status , sequence# from v$managed_standby;


MOS: Doc ID 739618.1



Comments