-
ORA-01111: name for data file 129 is unknown - rename to correct file
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
-
Rebuild it?
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!
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|