Re: Data Guard Management Interfaces

  • From: Laimutis.Nedzinskas@xxxxxx
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 30 Jul 2010 09:56:03 +0300

I personnaly adhere to economical approach (tools, command set, etc must be
kept minimal)

Having said that I can acknowledge that dgmgrl works. We use dgmgrl in
production. Period.

Problems we encountered are in the area of fast_start failover. Which again
is not dgmgrl interface issue but broker issues. So far we follow one
simple rule: stop fast_start failover before doing any dgmgrl command
except of status reads.

Last but not least: out version is 10.2.0.4 plus year old patch bundles
applied for broker, dg, logical dg, server.

---------------------------------------------------------------------------------

Please consider the environment before printing this e-mail


                                                                           
             "Allen, Brandon"                                              
             <Brandon.Allen@On                                             
             eNeck.com>                                                 To 
             Sent by:                  "oracle-l@xxxxxxxxxxxxx"            
             oracle-l-bounce@f         <oracle-l@xxxxxxxxxxxxx>            
             reelists.org                                               cc 
                                                                           
                                                                   Subject 
             2010.07.29 20:28          Data Guard Management Interfaces    
                                                                           
                                                                           
             Please respond to                                             
             Brandon.Allen@One                                             
                 Neck.com                                                  
                                                                           
                                                                           




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.



--
//www.freelists.org/webpage/oracle-l


Other related posts: