RE: EXTERNAL: Re: Primary -> Standby -> Standby

From: Grabowy, Chris <chris.grabowy_at_lmco.com>
Date: Mon, 10 Dec 2012 21:11:09 +0000
Message-ID: <5AF7D9F949ABC9479BC438A53649B53635FB0329_at_HDXDSP51.us.lmco.com>

Hmmm...interesting in the 11gr2 doc we have on the network drive (Part number E10700-01) Appendix E is for Standby Cascade...and it lists RAC as a restriction... But when I look on the net, the 11gr2 doc (Part number E25608-03) then Standby Cascade is not in Appendix E...and it does not list RAC as a restriction.

http://docs.oracle.com/cd/E11882_01/server.112/e25608/log_transport.htm#SBYDB5122

I apologize for the misinformation...

From: Job Miller [mailto:jobmiller_at_yahoo.com] Sent: Monday, December 10, 2012 2:56 PM
To: Grabowy, Chris
Subject: Re: EXTERNAL: Re: Primary -> Standby -> Standby

i'll i can say is stay tuned.. or reach out and ask your friendly Oracle pre-sales engineer and see what they will share.

Or, mark this thread and check back when the 12c docs are released for mention of these specific issues.

where do you see that it says "No RAC"?

Job

---

From: "Grabowy, Chris" <chris.grabowy_at_lmco.com<mailto:chris.grabowy_at_lmco.com>> To: "oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>" <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Sent: Monday, December 10, 2012 2:25 PM
Subject: RE: EXTERNAL: Re: Primary -> Standby -> Standby

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 - 22:11:09 CET