Re: Datafile recovery in datagaurd environment

hrishy

you suggest this to a forum user and you come here and ask if this is feasible....?!

--
LSC



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