ORA-01111: name for data file 129 is unknown
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