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>
Sent from Yahoo! Mail.
A Smarter Inbox. http://uk.docs.yahoo.com/nowyoucan.html
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-lReceived on Mon Mar 03 2008 - 08:18:57 CST