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.
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
--------------------------------------------------------------------------------
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.
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
--------------------------------------------------------------------------------
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
Post a Comment