Re: Datafile recovery in datagaurd environment
- From: "David Barbour" <david.barbour1@xxxxxxxxx>
- To: hrishys@xxxxxxxxxxx
- Date: Mon, 3 Mar 2008 13:43:28 -0500
Uhhhh ..... no. Think about it for a minute.
On 3/3/08, hrishy <hrishys@xxxxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
