Error in alert.log
ORA-01111: name for data file 350 is unknown - rename to correct file
ORA-01110: data file 350: '/u01/app/oracle/product/11.2.0.3/dbs/UNNAMED00350'
ORA-01157: cannot identify/lock data file 350 - see DBWR trace file
ORA-01111: name for data file 350 is unknown - rename to correct file
ORA-01110: data file 350: '/u01/app/oracle/product/11.2.0.3/dbs/UNNAMED00350'
Recovery Slave PR00 previously exited with exception 1111
MRP0: Background Media Recovery process shutdown (ORCL)
--check broken filename on standby
SQL> select name from v$datafile where file#=350;
NAME
-------------------------------------------------------
/u01/app/oracle/product/11.2.0.3/dbs/UNNAMED00350
--modify parameter
alter system set standby_file_management=manual;
--create datafile with correct filename
alter database create datafile '/u01/app/oracle/product/11.2.0.3/dbs/UNNAMED00350' as '/dev/ORCL/datadf130';
--modify parameter again to auto
alter system set standby_file_management=auto;
--start recovery
alter database recover managed standby database disconnect from session;
--check mrp
select process, status , sequence# from v$managed_standby;
Hiç yorum yok:
Yorum Gönder