Re: missing datafile on STANDBY DATABASE.

Syed,

First of all:

OS, Oracle Version?

I need to verify this later this evening at home at my testlab to be sure. What I'd suggest is this:

Shutdown the standby.
Create a new standby controlfile from the primary. Copy that to the standby, overwrite the existing standby controlfile(s). Put the tablespace in backup mode (on the primary) and recopy the missing datafile to the standby. Don't forget the 'end backup' Start the standby in managed recovery mode. It should catch up where needed.

If you want me to check this tonight (4 hours from now, 8PM CET I have some time to perform the checks) let me know.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l