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..... --- Ric Van Dyke <Ric.Van.Dyke@xxxxxxxxxx> wrote: > 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@xxxxxxxxxx > ------------------------------- > 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@xxxxxxxxxxxxx > 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 > -- > //www.freelists.org/webpage/oracle-l > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l