Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 23367 invoked from network); 3 Mar 2008 08:54:49 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 3 Mar 2008 08:54:49 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 51150816915; Mon, 3 Mar 2008 09:54:49 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09666-10; Mon, 3 Mar 2008 09:54:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C6B1C8168FA; Mon, 3 Mar 2008 09:54:48 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 03 Mar 2008 09:19:03 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7803981692C for ; Mon, 3 Mar 2008 09:19:03 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04988-02 for ; Mon, 3 Mar 2008 09:19:03 -0500 (EST) Received: from web27803.mail.ukl.yahoo.com (web27803.mail.ukl.yahoo.com [217.146.182.8]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 09CE28163E7 for ; Mon, 3 Mar 2008 09:19:02 -0500 (EST) Received: (qmail 4096 invoked by uid 60001); 3 Mar 2008 14:18:57 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=dRKVpr6pTkKco10159LCXuQRYCUHQMBAT3gdIuivoL1Mc5+JwJy6RPKCScmvCaTArgWjiTiH3YYyTuRQ9ICoTxO68WbsEhYm1U8AAXtbfSDU3YTAnAcfRSNnFTi8ZyVJR3aOs27rXLlRGMNytkSaqFF/52NC7bE+KJTlswlxOAQ=; X-YMail-OSG: XhbuTiEVM1mpPV32_X_CQTUGghDEyd6_hiLsc9GVmoJVkaoc72Zt4I7BKlOGOO5DGN0FllDUqmuA4alO7ZQoN_r0oSQ3baVKFeBil5HKBuXQ6yOAfXnLDQrUm30- Received: from [158.234.50.18] by web27803.mail.ukl.yahoo.com via HTTP; Mon, 03 Mar 2008 14:18:57 GMT Date: Mon, 3 Mar 2008 14:18:57 +0000 (GMT) From: hrishy Subject: Datafile recovery in datagaurd environment To: oracle-l@freelists.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Message-ID: <154303.3457.qm@web27803.mail.ukl.yahoo.com> X-archive-position: 5946 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: hrishys@yahoo.co.uk Precedence: normal Reply-to: hrishys@yahoo.co.uk List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Hi All Lets assume that one of my datafile on the primary database has been corrupted in a datagaurd environment. Can i do these steps to recover the primary db. 1)On primary do RMAN>sql 'alter database datafile 5 offline' 2)on Standby do RMAN>copy datafile '/db/ARON/fs1/test_d01_0.dbf_copy' to '/db/tmp/test_d01_0.dbf_copy' 3)Copy the datafile in step 2 to primary server 4)On the primary catalog the copy RMAN>catalog datafilecopy '/db/ARON/fs1/test_d01_0.dbf_copy' 5)RMAN>switch datafile 5 to COPY 6)RMAN>recover datafile 5 ; 7)RMAN> sql 'alter database datafile 5 online'; will this work regards Hrishy __________________________________________________________ Sent from Yahoo! Mail. A Smarter Inbox. http://uk.docs.yahoo.com/nowyoucan.html -- http://www.freelists.org/webpage/oracle-l