ORA-01111: name for data file 129 is unknown - rename to correct file

[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

[LKBrwn_DBA]

Don't know if it would work, but I would try the following:

1) Shutdown standby
2) At primary:
- alter tablespace (with newfile) begin backup
- copy datafiles to standby
- alter tablespace (with newfile) end backup
- alter database create standby controlfile as '/tmp/control01.ctl';
- copy controlfile to standby
3) At standby
- copy controlfile to other standby locations
- recover database

If it does not work, maybe you need to re-build the standby.
Good luck!

[hrishy]

Hi

Did you stop the managed recovery process and try

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL';

then do the renaming again

and then try

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';

and restart the MRP

regards
Hrishy

[bobonacus]

Thanks for your replies, got it working using the following ...

STEP1:- Check the name of the datafile on standby database

select name from v$datafile; ---- This command should show the datafile name as UNNAMEDxxxxx

STEP2:- ON STANDBY DATABASE
alter system set standby_file_management='manual';

STEP3:- Rename the datafile
alter database create datafile 'C:\ORACLE\ORA10G\DATABASE\UNNAMED00129' as 'C:\ORACLE\ORA10G\DATABASE\actual_dbfile_name.dbf'


STEP4:- On the standby database
alter system set standby_file_management='auto';

STEP5:- On the standby database
recover managed standby database disconnect;

shutdown and then reopen the standby database and continue applying the redo logs