Datafile recovery in datagaurd environment

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Mon, 3 Mar 2008 14:18:57 +0000 (GMT)
Message-ID: <154303.3457.qm@web27803.mail.ukl.yahoo.com>


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
Received on Mon Mar 03 2008 - 08:18:57 CST

Original text of this message