Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 1245 invoked from network); 8 Aug 2006 13:46:50 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2006 13:46:50 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BD14F3BE52E; Tue, 8 Aug 2006 14:46:33 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18844-07; Tue, 8 Aug 2006 14:46:33 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 481F33BE517; Tue, 8 Aug 2006 14:46:33 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 14:45:44 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7EB7D3BE36B for ; Tue, 8 Aug 2006 14:45:44 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18642-06 for ; Tue, 8 Aug 2006 14:45:44 -0400 (EDT) Received: from smtp-vbr12.xs4all.nl (smtp-vbr12.xs4all.nl [194.109.24.32]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E0FBE3BDE0F for ; Tue, 8 Aug 2006 14:45:43 -0400 (EDT) Received: from [10.2.192.199] (dbalert.xs4all.nl [213.84.185.230]) (authenticated bits=0) by smtp-vbr12.xs4all.nl (8.13.6/8.13.6) with ESMTP id k78Ijw8K064093; Tue, 8 Aug 2006 20:45:58 +0200 (CEST) (envelope-from cjpengel.dbalert@xs4all.nl) Subject: Re: missing datafile on STANDBY DATABASE. From: Carel-Jan Engel To: zhuchao@gmail.com Cc: sjaffarhussain@gmail.com, oracle-l@freelists.org In-Reply-To: <962cf44b0608080756p4e8dc584r1945bc9e195ae508@mail.gmail.com> References: <97b7fd2f0608080651g5bc63eabp3fa38c3acbb4c1a8@mail.gmail.com> <14483.194.235.127.40.1155045769.squirrel@webmail.xs4all.nl> <962cf44b0608080756p4e8dc584r1945bc9e195ae508@mail.gmail.com> Content-Type: multipart/alternative; boundary="=-DFiWQagT+6us3Yj2iw28" Organization: DBA!ert Date: Tue, 08 Aug 2006 20:45:57 +0200 Message-Id: <1155062757.8667.0.camel@dbalert199.dbalert.nl> Mime-Version: 1.0 X-archive-position: 37902 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: cjpengel.dbalert@xs4all.nl Precedence: normal Reply-to: cjpengel.dbalert@xs4all.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net --=-DFiWQagT+6us3Yj2iw28 Content-Type: text/plain Content-Transfer-Encoding: 7bit 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) === --=-DFiWQagT+6us3Yj2iw28 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit 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)
===
--=-DFiWQagT+6us3Yj2iw28-- -- http://www.freelists.org/webpage/oracle-l