Re: missing datafile on STANDBY DATABASE.

Hello Carel,

I have resolved the issue.
What I have done was, on primary database, I put the tablespace which was belonging to missing datafile, in backup mode, copied the datafile to standby location, restored all necessary archivelogs to the archive destination of standby and started the MRP process. This does the trick.

Thank you all for your valuable advice.

On 8/8/06, Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl> wrote:
>
> On Tue, 2006-08-08 at 22:56 +0800, Zhu,Chao wrote:
>
> either alter database create datafile 'xxx' (or 'xxx' as 'yyy') if path is
> different, and go on recovery.
> Or re-copy teh datafile from primary.
> he is talking about archifvelog so it is physical standby.
>
> Why implies archive log physical standby? Isn't logical standby based on
> redo logs as well?
>
> Best regards,
>
> Carel-Jan Engel
>
>
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> ===
>

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