Re: Standby - two physical, one working , second is not
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: makbo@xxxxxxxxxxx
- Date: Tue, 13 Sep 2005 16:46:22 -0400
1. You need to have a fresh standby controlfile created from the primary db.
2. Yes.
when yr standbys are up and running prefer to change any parameter with the
help of Dataguard if you are running.
regards - Chirag
On 9/13/05, Mark Bole <makbo@xxxxxxxxxxx> wrote:
>
> Are your two standbys on the same server? Typically they would not be.
>
> Each standby is configured independently from the other -- however you
> set up the first one, the second should be handled essentially the same
> way. So the answers to questions 1 and 2 are "yes".
>
> Your standby controlfile should be created after you create the hot
> backup, as per the documentation.
>
> -Mark Bole
>
> kathy duret wrote:
> > Ok I have two physical standbys databases.
> > Linux RH3, 10.1.0.2 <http://10.1.0.2>
> >
> > I have one standby working just fine.
> >
> > The second is not. I try to bring it up and it asks
> > for archive from about two weeks ago.
> >
> > I have a good fresh hot backup that is current. I
> > made sure by wiping everything out including the
> > standby database files and redo files and re ftping
> > everything.
> >
> > Question 1 is do I need a separate standby controlfile
> > for this instance separate from the first standby?
> >
> > Question 2. I know I need 1 addition standby redo log
> > for the standby, should I have another one for the
> > additional standby database.
> >
> > I really coulnd't find anything in the docs.
> >
> > Thanks,
> >
> > Kathy
> >
> >
> >
> >
> > __________________________________
> > Yahoo! Mail - PC Magazine Editors' Choice 2005
> > http://mail.yahoo.com
> > --
> > //www.freelists.org/webpage/oracle-l
> >
>
> --
> Mark Bole
> http://www.bincomputing.com
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
Other related posts:
