FreeLists / oracle-l / Datafile recovery in datagaurd environment

[hrishy <hrishys@xxxxxxxxxxx>]

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