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_at_gmail.com> 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_at_yahoo.co.uk> 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
> >
> >
> >
> >

>

--
http://www.freelists.org/webpage/oracle-l