| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Standby - two physical, one working , second is not
Ok I got this working. I will look it again..
Yes I have a set of standby redo + one extra mirroring the redo for each database and a standby control file for each.
I had to stop the second standby after I got it all working. the archs from sydney to idaho caused network issues.... We do alot of other images transfers and this becamne problematic so now I have to figure out how to work this.
Our eventual goal is RAC with standby to another location. I will look for the Data Guard Admin guide..
I was looking throught the standby docs and the 10g HA book I have... let me tell you lots of mistakes in both.
Thanks to everyone.....
> Your questions:
>
> Question 1 is do I need a separate standby
> controlfile for this instance separate from the
> first standby?
>
> YES! Each standby is a separate database. Each
> must have it's own control files, and everything
> else.
>
> Question 2. I know I need 1 addition standby redo
> log for the standby, should I have another one for
> the additional standby database.
>
> This question seems to be missing something. I hope
> you have a SET of standby redo logs, not just ONE
> standby redo log. The Standby redo logs (SRL's) are
> used ON THE STANDBY, not the primary. Each database
> in the configuration must have it's own set of
> SRL's. The Primary should have SRL's defined on
> them as this makes for easier swithovers.
>
> I'm pretty sure this is in the doc (Data Guard Admin
> Guide), I did help write it. Follow chapter 3 which
> outlines how to create a physical standby. For each
> physical standby follow this chapter, working as if
> there are no other standbys created. Each standby
> should be on it's own machine. You can have
> multiple standbys on the same box, but it really
> isn't a good idea.
>
>
> Ric Van Dyke
> Ric.van.Dyke_at_hotsos.com
> -------------------------------
> Hotsos Symposium 2006, March 5-9
> Be there...
>
>
> ----- Original Message -----
> From: kathy duret
> Sent: Tue Sep 13 13:18:21 EDT 2005
> To: oracle-l_at_freelists.org
> Subject: Standby - two physical, one working ,
> second is not
>
>
> Ok I have two physical standbys databases.
> Linux RH3, 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
> --
> http://www.freelists.org/webpage/oracle-l
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 14 2005 - 10:07:00 CDT
 |
 |