Re: Datafile recovery in datagaurd environment

Hi David

why shouldn't it work assuming that the corruption hasn't propgated to the standby database ?

any ideas

regards
Hrishy
--- David Barbour <david.barbour1_at_gmail.com> wrote:

> Uhhhh ..... no. Think about it for a minute.
>
> 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