Dataguard Broker的配置

SQL> alter system set dg_broker_start=true;
System altered.

SQL> show parameter dg_
NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1       string  /home/oracle/app/oracle/produc
       t/11.2.0/dbhome_1/dbs/dr1orcld
       g.dat
dg_broker_config_file2       string  /home/oracle/app/oracle/produc
       t/11.2.0/dbhome_1/dbs/dr2orcld
       g.dat
dg_broker_start        boolean  TRUE

[oracle@primary ~]$  cat  /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.83.？)(PORT = 1521))
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (SID_NAME = orcl)
      (ORACLE_HOME =/home/oracle/app/oracle/product/11.2.0/dbhome_1)
    )
    (
     SID_DESC=(SID_NAME=orcl)
     (GLOBAL_DBNAME=orcl_DGMGRL)
     (ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1)
     (ENVS="TNS_ADMIN=/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin")
    )
  )

[oracle@standby ~]$ cat  /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.83.235)(PORT = 1521))
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (SID_NAME = orcl)
      (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
    )
    (
     SID_DESC=(SID_NAME=orcl)
     (GLOBAL_DBNAME=orcldg_DGMGRL)
     (ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1)
     (ENVS="TNS_ADMIN=/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin")
    )
  )

[oracle@primary ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.1.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys
Password:
Connected.

DGMGRL> help create;
Creates a broker configuration
Syntax:
  CREATE CONFIGURATION <configuration name> AS
    PRIMARY DATABASE IS <database name>
    CONNECT IDENTIFIER IS <connect identifier>;

DGMGRL> create configuration dg as primary database is orcl connect identifier is orcl;
Configuration "dg" created with primary database "orcl"

DGMGRL> show configuration
Configuration - dg
  Protection Mode: MaxAvailability
  Databases:
    orcl - Primary database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED

DGMGRL> add database orcldg as connect identifier is orcldg;
Database "orcldg" added
DGMGRL> show configuration
Configuration - dg
  Protection Mode: MaxAvailability
  Databases:
    orcl   - Primary database
    orcldg - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED

DGMGRL> show database verbose orcl
Database - orcl
  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    orcl
  Database Warning(s):
    ORA-16629: database reports a different protection level from the protection mode
  Properties:
    DGConnectIdentifier             = 'orcl'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'SYNC'
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'auto'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = ''
    LogFileNameConvert              = ''
    FastStartFailoverTarget         = ''
    StatusReport                    = '(monitor)'
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    HostName                        = 'primary'
    SidName                         = 'orcl'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=primary)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/home/oracle/app/oradata/orcl/archive'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'
Database Status:
WARNING
DGMGRL>