error in Standby dataabse
edited Jul 23, 2010 3:23AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
Hi Folks, I found an error on Recovery managed on may Standby database.
I created a new datafile 'F:\ORACLE\DBA2\DBA2_STIF_IDX_07.DBF' on my primary database, but may standby database stop working.
When I restarted the standby database, I found the error below:
SQL> recover standby database;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 38 is unknown - rename to correct file
ORA-01110: data file 38: 'E:\ORACLE\ORA10G\DATABASE\UNNAMED00038'
ORA-01157: cannot identify/lock data file 38 - see DBWR trace file
ORA-01111: name for data file 38 is unknown - rename to correct file
0