Though the question should be asked, what's the reason for having two EM
repositories in the first place? There are valid reasons for doing that, but
more often than not the reasons people have it set up that way is often a
misunderstanding of EM capabilities. See
http://dbasushi.com/one-em-to-rule-them-all for a good coverage of that.
Pete
Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
Phone: +61262924095 | | Fax: +61262925183 | | Mobile: +61414443449
Email: pete.sharman@xxxxxxxxxx Twitter: @SharmanPete LinkedIn:
au.linkedin.com/in/petesharman
Website: petewhodidnottweet.com
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not, it's much harder than that!"
Bruce Pihlamae, long term Oracle DBA
-----Original Message-----
From: Courtney Llamas
Sent: Tuesday, June 2, 2015 3:03 AM
To: HerringD@xxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: EM DG switchover across EM repositories?
Both targets would need to be in the same EM repository for EM to handle this
switchover.
-----Original Message-----
From: Herring, David [mailto:HerringD@xxxxxxx]
Sent: Monday, June 01, 2015 11:33 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: EM DG switchover across EM repositories?
Folks,
Does anyone know if it's possible to perform a Data Guard switchover (from
within EM) from primary to physical standby where each is registered in a
different EM repository? We have DG configured so that the primary dbs are in
the UK and the physical standbys are in the US. The UK targets are registered
with a UK repository and the US targets are registered with a US repository.
Ideally we'd use EM for the switchover but I haven't been able to confirm if
this is possible or not using separate EM repositories.
Obviously actually performing the test will show me but I've been asked to draw
up all the steps and tests ahead of time, get everything ready and meet various
project plan deadlines with all this BEFORE doing anything, which is why it's
critical for me to know ahead of time if it's even possible. I didn't see any
references to doing this with separate EM repositories in the doc and while I
have an SR open with Oracle for confirmation, I'm struggling in getting them to
understand my question.
The configuration consistents of multiple 2 to 4-node RACs on each side (UK and
US), database ver is 11.2.0.4. The complexity for now is that the US dbs are
registered in a 12c repository whereas the UK dbs are registered in a 11g
repository. Once FW rules are pushed tomorrow night I should be able to move
those 11g-registered dbs to a 12c repository in the UK.
Thx.
Dave
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
