Datafile recovery in datagaurd environment
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 3 Mar 2008 14:18:57 +0000 (GMT)
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:
