Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 1243 invoked from network); 8 Aug 2006 09:57: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 09:57:45 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 10F963BD933; Tue, 8 Aug 2006 10:57:28 -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 01473-01-8; Tue, 8 Aug 2006 10:57:27 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D73BB3BD9D8; Tue, 8 Aug 2006 10:57:22 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 10:56:17 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CE6AB3BD95F for ; Tue, 8 Aug 2006 10:56:16 -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 01128-03-4 for ; Tue, 8 Aug 2006 10:56:16 -0400 (EDT) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.227]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 683643BD956 for ; Tue, 8 Aug 2006 10:56:15 -0400 (EDT) Received: by wr-out-0506.google.com with SMTP id i30so86546wra for ; Tue, 08 Aug 2006 07:56:30 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Ukv9TdpYIWSCqd7N3MeZ4/YiiMYu84eE1i4r/K8+4ZzNvFwgcSHB8iMdcyB7ijhPusglEzWkyzDgBjMP8KkiQGVupuLF2bwPlZ1aCJf/ulrN5mgqjh/ZqxzfjVBIMWnj1mPrko8MbVtMtAocPRJhnDxtYFkdqwbbUVLnRdXVWaw= Received: by 10.78.132.12 with SMTP id f12mr2804838hud; Tue, 08 Aug 2006 07:56:29 -0700 (PDT) Received: by 10.78.48.5 with HTTP; Tue, 8 Aug 2006 07:56:29 -0700 (PDT) Message-ID: <962cf44b0608080756p4e8dc584r1945bc9e195ae508@mail.gmail.com> Date: Tue, 8 Aug 2006 22:56:29 +0800 From: "Zhu,Chao" To: cjpengel.dbalert@xs4all.nl Subject: Re: missing datafile on STANDBY DATABASE. Cc: sjaffarhussain@gmail.com, oracle-l@freelists.org In-Reply-To: <14483.194.235.127.40.1155045769.squirrel@webmail.xs4all.nl> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7560_25213503.1155048989376" References: <97b7fd2f0608080651g5bc63eabp3fa38c3acbb4c1a8@mail.gmail.com> <14483.194.235.127.40.1155045769.squirrel@webmail.xs4all.nl> X-archive-position: 37877 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: zhuchao@gmail.com Precedence: normal Reply-to: zhuchao@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net ------=_Part_7560_25213503.1155048989376 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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. On 8/8/06, Carel-Jan Engel wrote: > > 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 > > > -- Regards Zhu Chao www.cnoug.org ------=_Part_7560_25213503.1155048989376 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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.


On 8/8/06, Carel-Jan Engel <cjpengel.dbalert@xs4all.nl> wrote:
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





--
Regards
Zhu Chao
www.cnoug.org
------=_Part_7560_25213503.1155048989376-- -- http://www.freelists.org/webpage/oracle-l