RE: Data Guard Management Interfaces
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <Brandon.Allen@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Jul 2010 13:37:49 -0400
Humm, Is it just my imagination or does it seem that we have a whole lot
of IT services company folks on the list lately??
OH Well, here's my preference having done quite a few DG setups and
maintenance over the last few years. I just use Sql*Plus. I've had a
few BAD experiences with DGMGRL and what it thinks is how the system
should be set up. In particular I've had it setup auto failover which
was dandy until the two DB's got separated by a wan problem that lasted
a day. When the WAN returned instant crash of both instances, OH
Bother!!
Biggest problem that I've found is checking if the standby is up-to-date
with the primary. The following does a dandy job of it:
SELECT max(decode(PROCESS, 'MRP0',
sequence#))-max(decode(process,'RFS',decode(CLIENT_PROCESS,'LGWR',
SEQUENCE#),NULL))current_log_gap
FROM V$MANAGED_STANDBY;
select process, client_process, sequence#, status from v$managed_standby
where sequence# is not null
and sequence# > 0
order by 3;
What you want to see is:
PROCESS CLIENT_P SEQUENCE# STATUS
--------- -------- ---------- ------------
RFS ARCH 0 IDLE
RFS ARCH 0 IDLE
ARCH ARCH 29252 CLOSING
ARCH ARCH 29254 CLOSING
RFS LGWR 29255 IDLE
MRP0 N/A 29255 APPLYING_LOG
So long as RFS and MRP0 are working on the same file, all is well.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon
Sent: Thursday, July 29, 2010 1:27 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Data Guard Management Interfaces
Hi List,
I'm just getting started with Data Guard and curious which management
interface those with extensive experience would recommend? I am very
comfortable with the command line and use SQL*Plus for 99% of my DBA
tasks. I'm not currently running Grid Control - I just start up DB
Control briefly when needed and then shut it back down. Am I better off
just using the SQL*Plus commands for DG, or should I use the
command-line version of DG Broker (DGMGRL), or is it worth setting up
Grid Control just for the convenience of the GUI for managing Data
Guard? Based on my previous experience testing Grid Control (more
trouble than it's worth in my opinion), and comfort level with the
command-line, I'm leaning towards one of the CLI options - either
SQL*Plus or DGMGRL. Eventually I'll probably take the time to learn
them both and decide for myself which one I like better, but I'm just
curious which one you Data Guard experts would recommend to start with
and any major pros or cons of any of them.
I'm running Oracle 10.2.0.4 on AIX6.1 and just setting up a simple
configuration with one physical standby.
Thanks,
Brandon
________________________________
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do
not consent to Internet email for messages of this kind. Opinions,
conclusions and other information in this message that do not relate to
the official business of this company shall be understood as neither
given nor endorsed by it.
Other related posts:
