RE: EXTERNAL: Re: Primary -> Standby -> Standby
Date: Mon, 10 Dec 2012 19:47:36 +0000
Message-ID: <5AF7D9F949ABC9479BC438A53649B53635FB02E0_at_HDXDSP51.us.lmco.com>
We have a local standby within the datacenter, and then we have another standby at a remote location. We can switch to whichever one solves the problem with the least amount of effort or politics.
From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com]
Sent: Monday, December 10, 2012 2:35 PM
To: Grabowy, Chris
Cc: ORACLE-L
Subject: RE: EXTERNAL: Re: Primary -> Standby -> Standby
So I'll bite, mostly because Larry Carpenter knowing he was being kind to a nervous presenter, pointed out cascade standby in my 'you probably don't need dataguard' presentation way back when. The point I was making - you have log_archive_dest_n where n is at least 9 - how many standbys do you actually need. I've seen cases for as many as 5. Not great cases but still. On Dec 10, 2012 7:28 PM, "Grabowy, Chris" <chris.grabowy_at_lmco.com<mailto:chris.grabowy_at_lmco.com>> wrote: Ugh. If I am reading this correctly then the restrictions are killing it for me. No RAC. No Broker. Oh well. Thanks anyway. I learned something new today. Which I'll forget and then relearn...
From: Grabowy, Chris
Sent: Monday, December 10, 2012 2:18 PM
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>
Subject: RE: EXTERNAL: Re: Primary -> Standby -> Standby
Cascade Standbys...got it.....Appendix E of the 11.2 Dataguard doc.
Thanks Craig, Job, Adam!!!
From: craigihagan_at_gmail.com<mailto:craigihagan_at_gmail.com><mailto:craigihagan_at_gmail.com<mailto:craigihagan_at_gmail.com>> [mailto:craigihagan_at_gmail.com<mailto:craigihagan_at_gmail.com>] On Behalf Of Craig Hagan
Sent: Monday, December 10, 2012 2:11 PM
To: Grabowy, Chris
Subject: EXTERNAL: Re: Primary -> Standby -> Standby
I believe it is called cascaded redo
if you have foodb with a primary and a "regular" standby for production use, and an additional standby for other use, e.g. reporting, etc, you could have the production standby transmit logs to the reporting standby via a config roughly like:
alter system set log_archive_config='DG_CONFIG=(foodb_b,foodb_a,foodb_c)';
alter system set log_archive_dest_3 = 'db_unique_name=foodb_c SERVICE="foodb_c.amazon" NET_TIMEOUT valid_for=(standby_logfile, standby_role) REOPEN` OPTIONAL'; alter system set log_archive_dest_state_3='enable';
(nb: i'm not checking for typos or exact syntax, verify! the key is the role standby_role vs. primary_role)
- craig
On Mon, Dec 10, 2012 at 2:00 PM, Grabowy, Chris <chris.grabowy_at_lmco.com<mailto:chris.grabowy_at_lmco.com><mailto:chris.grabowy_at_lmco.com<mailto:chris.grabowy_at_lmco.com>>> wrote: I thought I had read somewhere that a Primary database could feed its logs to a Standby database and then that Standby database could then feed those logs to another Standby.
Is that true?? If so then is it a matter of setting another LOG_ARCHIVE_DEST on the standby? Looking for a clue, since I have none.
Or I was dreaming about a new feature??
--
http://www.freelists.org/webpage/oracle-l
--
.- ... . -.-. .-. . - -- . ... ... .- --. .
Craig I. Hagan
hagan(at)cih.com<http://cih.com><http://cih.com>
nemo dat quod non habet - you cannot give what you do not have
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 10 2012 - 20:47:36 CET