ORA-01111: name for data file 110 is unknown - rename to correct file
787588May 6 2011 — edited May 6 2011Experts,
Suddenly my standby is stopped working from last two days, I saw few errors in alert log file as below.
Mon May 2 12:09:58 2011
Errors in file /oracle/app/oracle/admin/prod/bdump/prod_mrp0_55200.trc:
ORA-01111: name for data file 110 is unknown - rename to correct file
ORA-01110: data file 110: '/oracle/app/oracle/product/10.2.0/db_1/dbs/UNNAMED000110'
ORA-01157: cannot identify/lock data file 110 - see DBWR trace file
ORA-01111: name for data file 110 is unknown - rename to correct file
ORA-01110: data file 110: '/oracle/app/oracle/product/10.2.0/db_1/dbs/UNNAMED000110'
After checking i came to know, standby_file_management=manual, i changed it to AUTO, later all the archives are applied automatically after starting MRP.
My question is does i need to rename file ?
Does it will cause any problem while performing Fail-over?
Appriciated for right answers.