6 Replies Latest reply: Mar 26, 2013 11:28 PM by rp0428 RSS

    ORA-01111: name for data file 129 is unknown

    bobonacus
      I have a 10.2.0.1 database and a standby database on another server that has the redo logs applied every 15 mins.

      I added a new file to the primary db but the standby server's disk was full so when it tried to automatically it failed.

      I've sorted the space issue out but now I get the following error :

      ORA-00283: recovery session canceled due to errors
      ORA-01111: name for data file 129 is unknown - rename to correct file
      ORA-01110: data file 129: 'C:\ORACLE\ORA10G\DATABASE\UNNAMED00129'
      ORA-01157: cannot identify/lock data file 129 - see DBWR trace file
      ORA-01111: name for data file 129 is unknown - rename to correct file
      ORA-01110: data file 129: 'C:\ORACLE\ORA10G\DATABASE\UNNAMED00129'

      I've tried manually copying the files from the live db and I've tried an alter database rename file command but that tells me renaming is not allowed if standby management is set to automatic. I've had a search but can't see a solution, any ideas?

      Thanks
      Robert