Re: Datafile recovery in datagaurd environment

From: David Barbour <david.barbour1_at_gmail.com>
Date: Mon, 3 Mar 2008 13:43:28 -0500
Message-ID: <69eafc3f0803031043w1090dcc8m1631ff5ada04cdce@mail.gmail.com>


Uhhhh ..... no. Think about it for a minute.

On 3/3/08, hrishy <hrishys_at_yahoo.co.uk> wrote:
>
> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 03 2008 - 12:43:28 CST

Original text of this message