14 Haziran 2013 Cuma

ORA-01111: name for data file 350 is unknown - rename to correct file



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