Re: Datafile recovery in datagaurd environment

Hi

My version of database is 9.2.0.7 
and i was wundering if this is feasible instead of
restoring it from a backup etc..

LS Cheng
After asking this question here i went home from work
and started searching on metalink and then i got a hit
on two notes after some effort which says this is
possible and that  
372656.1
453153.1

and that was when i responded in forum.

regards
Hrishy


--- LS Cheng <exriscer@xxxxxxxxx> wrote:

> 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@xxxxxxxxxxx> 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
> >
> >
> >
> 



      __________________________________________________________
Sent from Yahoo! Mail.
A Smarter Inbox. http://uk.docs.yahoo.com/nowyoucan.html
--
http://www.freelists.org/webpage/oracle-l

Other related posts: