Re: Datafile recovery in datagaurd environment
- From: "David Barbour" <david.barbour1@xxxxxxxxx>
- To: exriscer@xxxxxxxxx
- Date: Mon, 3 Mar 2008 16:37:42 -0500
Hrishy - you need to review the documentation available on database
recovery.
Depending on your version of Oracle, whether or not you have backups,
whether or not you're using RMAN, whether or not you have a flashback
recovery area, check out tahiti.oracle.com and get the appropriate
manual(s). Metalink will also address your situation.
When you've found the right scenario, put togehter a list of actions based
on sound principals. If you want to review your plan of action with the
list, it would be helpful to include the information I outlined above, along
with your plan and a reference from the material you've used for assistance.
I realize this is probably a critical issue for you right now, but if it's
that bad, you might just have to activate your standby if time is the
defining constraint. It's probably beyond the ability of folks here to
assist you given the information you've provided.
On 3/3/08, 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
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
>
Other related posts:
