ORA-01111: name for data file 59 is unknown - rename to correct file
Hi,
We are using physical dataguard of oracle 10g in linux env.
Please guide me this is in production env:
My primary database is working fine but how to synch it again with problematic standby database?
I am facing the problem with standby database as defined below:
1:
-------
Archive Path on Production: /d01/silprod/SILP/db/apps_st/data
Archive Path on Standby: /d01/silprod/SILP/db/apps_st/data
Today morning I have added the datafile (3 GB)(Path: '/d01/silprod/SILP/db/apps_st/data/a_txn_data19.dbf') in primary database, at the same time the mount point space of standby database home 100% filled and
the following error received in standby alertlog file:
------------------------------------------------------------------------------------
MRP0: Background Media Recovery terminated with error 1111
Wed Feb 2 10:50:22 2011
Errors in file /d01/silprod/SILP/db/tech_st/10.2.0/admin/SILP_appsdg/bdump/silp_mrp0_3666.trc:
ORA-01111: name for data file 59 is unknown - rename to correct file
ORA-01110: data file 59: '/d01/silprod/SILP/db/tech_st/10.2.0/dbs/UNNAMED00059'
ORA-01157: cannot identify/lock data file 59 - see DBWR trace file
ORA-01111: name for data file 59 is unknown - rename to correct file
ORA-01110: data file 59: '/d01/silprod/SILP/db/tech_st/10.2.0/dbs/UNNAMED00059'
Wed Feb 2 10:50:22 2011
Errors in file /d01/silprod/SILP/db/tech_st/10.2.0/admin/SILP_appsdg/bdump/silp_mrp0_3666.trc:
ORA-01111: name for data file 59 is unknown - rename to correct file
ORA-01110: data file 59: '/d01/silprod/SILP/db/tech_st/10.2.0/dbs/UNNAMED00059'
ORA-01157: cannot identify/lock data file 59 - see DBWR trace file
ORA-01111: name for data file 59 is unknown - rename to correct file
ORA-01110: data file 59: '/d01/silprod/SILP/db/tech_st/10.2.0/dbs/UNNAMED00059'
Wed Feb 2 10:50:22 2011
------------------------------------------------------------------------------------
2:
------
After this my archivelogs of primary database not moving and applying to standby database.
Then I have move all archives manually to standby database and then recover database as:
SQL> startup mount;
SQL> Recover automatic standby database;
and getting following error:
SQL> recover automatic standby database;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 59 is unknown - rename to correct file
ORA-01110: data file 59: '/d01/silprod/SILP/db/tech_st/10.2.0/dbs/UNNAMED00059'
ORA-01157: cannot identify/lock data file 59 - see DBWR trace file
ORA-01111: name for data file 59 is unknown - rename to correct file
ORA-01110: data file 59: '/d01/silprod/SILP/db/tech_st/10.2.0/dbs/UNNAMED00059'
---------------------------------------------------
thx
Edited by: user12007410 on Feb 1, 2011 11:44 PM