Create Broker Configuration

1. Preparatory work

Create oracle11g primary and standby libraries, physical standby, maximum performance mode

Dg_broker_start set to True

2. Create Broker Configuration

dgmgrl> CREATE CONFIGURATION ' drtest ' as PRIMARY DATABASE is ' ora11gn1 ' CONNECT IDENTIFIER is ora11gn1;dgmgrl> ADD D Atabase ' ora11gn2 ' as CONNECT IDENTIFIER is ora11gn2;dgmgrl> ENABLE configuration;dgmgrl> SHOW CONFIGURATION; Configuration-drtest Protection mode:maxperformance databases:ora11gn1-primary Database ora11gn2-physical Standby Databasefast-start failover:disabledconfiguration status:successdgmgrl> SHOW DATABASE VERBOSE ora11gn1;d ATABASE-ORA11GN1 Role:primary intended state:transport-on Instance (s): Ora11gn Properties:dgcon Nectidentifier = ' ora11gn1 ' observerconnectidentifier = ' Logxptmode = ' Asyn                      C ' delaymins = ' 0 ' Binding = ' optional ' maxfailure                      = ' 0 ' maxconnections = ' 1 ' reopensecs = ' nettimeout '    = ' Redocompression '             = ' DISABLE ' logshipping = ' on ' preferredapplyinstance = ' Applyinstanc Etimeout = ' 0 ' applyparallel = ' auto ' standbyfilemanagement = ' auto ' Archi Velagtarget = ' 0 ' logarchivemaxprocesses = ' 4 ' logarchiveminsucceeddest = ' 1 ' dbfi Lenameconvert = '/u01/oradata/ora11gn/,/u01/oradata/ora11gn/' Logfilenameconvert = '/u01/or adata/ora11gn/,/u01/oradata/ora11gn/' faststartfailovertarget = ' inconsistentproperties = ' (Moni                    Tor) ' Inconsistentlogxptprops = ' (monitor) ' sendqentries = ' (monitor) ' Logxptstatus = ' (monitor) ' recvqentries = ' (monitor) ' Sidname = ' ora1 1gn ' Staticconnectidentifier = ' (description= (address= (protocol=tcp) (HOST=ORA11GDG) (port=1521)) (CONNECT_DATA= (S Ervice_name=ora11gn1_dgmGRL) (INSTANCE_NAME=ORA11GN) (server=dedicated))) ' Standbyarchivelocation = '/u01/app/oracle/11.2.0/db_1/dbs/arc H ' alternatelocation = ' Logarchivetrace = ' 0 ' Logarchiveformat = ' %t_%s_%r.dbf ' topwaitevents = ' (monitor) ' Database status:successdgmgrl> SHOW database Ora11gn2;dat       Abase-ora11gn2 role:physical STANDBY intended state:apply-on Transport lag:0 seconds APPLY Lag: 0 seconds Real Time Query:on Instance (s): Ora11gndatabase status:success

Report:

Listener.ora

# Listener.ora Network Configuration File:/u01/app/oracle/11.2.0/db_1/network/admin/listener.ora# Generated by Oracle configuration tools. Sid_list_listener=(Sid_list=(Sid_desc=(Global_name=ora11gn) (Global_dbname=ORA11GN1_DGMGRL) (Oracle_home=/u01/app/oracle/11.2.0/db_1) (Sid_name=ora11gn)) ) LISTENER=(Description_list=(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST =192.168.56.101) (PORT =1521)) (ADDRESS= (PROTOCOL = IPC) (KEY =EXTPROC1521)) )) Adr_base_listener=/u01/app/oracle

Tnsnames.ora

# Tnsnames.ora Network Configuration File:/u01/app/oracle/11.2.0/db_1/network/admin/tnsnames. Ora# Generated by Oracle configuration tools.  =  (DESCRIPTION = (    ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.101) (PORT = 1521))    (Connect_data =< c5/> (SERVER = dedicated)      (service_name = ora11gn1)    )  =  (DESCRIPTION = (    ADDRESS = ( PROTOCOL = TCP) (HOST = 192.168.56.102) (PORT = 1521))    (Connect_data =      (SERVER = dedicated)      (service_name = ORA11GN2)))  

　　

Create Broker Configuration