Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> missing datafile on STANDBY DATABASE.
Hello list,
We are maintaining the standby database to our one of important database.
On 5th August, a datafile has been added to primary database,
unfortunately, there was no sufficient space on standby server.
MRP background process has died and no archive logs were applied until now.
I try to rename the datafile, create datafile, but, couldn't succeeded.
Opened a TAR with oracle and they said that rebuild standby.
I couldn't find the 'UNNAMED00266' file at OS leve. But, the entry is
there in v$datafile.
I have even cheked all my backups from 5th August, finding a luck to
have the file in backup, if someone deleted the file. But, not luck.
Is there any way that we can resolve this issue?
I have all the archived log since that point.
Thanks,
-- Best Regards, Syed Jaffar Hussain 8i,9i & 10g OCP DBA Banque Saudi Fransi, Saudi Arabia I blog at :http://jaffardba.blogspot.com/ http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently." -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 08 2006 - 08:51:38 CDT