Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> missing datafile on STANDBY DATABASE.

missing datafile on STANDBY DATABASE.

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Tue, 8 Aug 2006 16:51:38 +0300
Message-ID: <97b7fd2f0608080651g5bc63eabp3fa38c3acbb4c1a8@mail.gmail.com>


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-l
Received on Tue Aug 08 2006 - 08:51:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US