Re: Datafile recovery in datagaurd environment
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: david.barbour1@xxxxxxxxx
- Date: Mon, 3 Mar 2008 20:03:34 +0000 (GMT)
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@xxxxxxxxx> wrote:
> Uhhhh ..... no. Think about it for a minute.
>
> 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
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
>
__________________________________________________________
Sent from Yahoo! Mail.
A Smarter Inbox. http://uk.docs.yahoo.com/nowyoucan.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
