RE: EXTERNAL: Re: Primary -> Standby -> Standby
- From: "Grabowy, Chris" <chris.grabowy@xxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 Dec 2012 19:18:09 +0000
Cascade Standbys...got it.....Appendix E of the 11.2 Dataguard doc.
Thanks Craig, Job, Adam!!!
From: craigihagan@xxxxxxxxx [mailto:craigihagan@xxxxxxxxx] 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@xxxxxxxx<mailto:chris.grabowy@xxxxxxxx>> 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??
--
//www.freelists.org/webpage/oracle-l
--
.- ... . -.-. .-. . - -- . ... ... .- --. .
Craig I. Hagan
hagan(at)cih.com<http://cih.com>
nemo dat quod non habet - you cannot give what you do not have
--
//www.freelists.org/webpage/oracle-l
Other related posts:
