Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Sep 18, 2012 8:58 PM by
data guard: created file using standby_file_management=manual
Sep 18, 2012 8:15 PM
My Db version !0.2.0.4 3 node cluster database configured using physical standby with DATA GUARD.
currently my primary and standby standby_file_managemnt=manual.
some on call people created a datafile on primary db on standby datafile got created in oracle_home/dbs/unknownname
now MRP is not running on standby and am seeing in alertlogfile error
error in alert logfile:
name of datafile 11 is unknow and rename to correct file.
datafile 11 /op/oracle/produnct/db/10.20.4/dbs/unknowname'
cannot identify /lock datafile --
MRP0: backuground media receovery process shutdown
Please help how to fix this issue.
Edited by: user636357 on Sep 18, 2012 6:11 PM
Edited by: user636357 on Sep 18, 2012 6:15 PM
This content has been marked as final.
Show 1 reply
Re: data guard: created file using standby_file_management=manual
Sep 18, 2012 8:58 PM
in response to
alter databas create datafile 'opt/oracle/product/102.0.4/dbs/unnamed0001' as '+DATA01' SIZE 5M;
alter system set standby_file_management=auto scope=both;
alter database recover managed standby database disconnect;
select process,status ,sequence# from v$managed_standby;
should see MRP applying_log ... good