Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

data guard problem

455224Jul 16 2008 — edited Jul 18 2008
Hi,

I got an error when I enable data guard configuration.
Can anyone help me to find where the problem is?

Thanks in Advance
Best Regards,

production:
 DB version: 9.2.0.1
 Platfrom: windows 2000 sp4
standby:
 DB version: 9.2.0.1
 Platfrom: windows 2000 sp1

Steps:
 on production:
  1. C:\> dgmgrl
  2. DGMGRL> CREATE CONFIGURATION 'PX_Recall' AS
   > PRIMARY SITE IS 'helios_site'
   > RESOURCE IS 'helios_site_tracker'
   > HOSTNAME IS 'helios'
   > INSTANCE NAME IS 'tracker'
   > SERVICE NAME IS '(DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=helios)(PORT=1521)))(CONNECT_DATA=(SID=TRACKER)(ORACLE_HOME=d:\oracle\ora92)(SERVER=DEDICATED)))'
   > SITE IS MAINTAINED AS PHYSICAL;
   Configuration "PX_Recall" added with primary site "helios_site"
   Database resource "helios_site_tracker" added.
  3. DGMGRL> CREATE SITE 'telescopium_site'
   > RESOURCE IS 'telescopium_site_tracker'
   > HOSTNAME IS 'telescopium'
   > INSTANCE NAME IS 'tracker'
   > SERVICE NAME IS '(DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=telescopium)(PORT=1521)))(CONNECT_DATA=(SID=TRACKER)(ORACLE_HOME=d:\oracle\ora92)(SERVER=DEDICATED)))'
   > SITE IS MAINTAINED AS PHYSICAL;
   Site "telescopium_site" added to configuration.
   Error:
   ORA-16525: the Data Guard broker is not yet available
   ORA-06512: at "SYS.DBMS_DRS", line 48
   ORA-06512: at line 2
   
   Error:
   ORA-16525: the Data Guard broker is not yet available
   ORA-06512: at "SYS.DBMS_DRS", line 48
   ORA-06512: at line 2

   Site "telescopium_site" was not found
  4. part of broker log
   DG 2008-07-16-12:02:51 0 2 660162664 DMON: ADD_DRC: success
   DG 2008-07-16-12:02:51 0 2 660162665 Add site helios_site succeeded.
   DG 2008-07-16-12:02:51 0 2 660162665 DMON: ADD_SITE: success
   DG 2008-07-16-12:02:51 1000000 3 660162666 DMON: GET_ID: success. (len = 99)
   DG 2008-07-16-12:02:51 1000000 3 660162667 DMON: GET_SITE: success. (len = 388)
   DG 2008-07-16-12:02:51 1000000 3 660162668 Adding internal resource helios_site_tracker pid 1000001 parent_state ONLINE (1) vinst 0
   DG 2008-07-16-12:02:51 1000000 3 660162668 -- default_state OFFLINE (0)
   DG 2008-07-16-12:02:51 1000000 3 660162668 Adding internal resource helios_site_tracker pid 1000001 parent_state PRIMARY (5) vinst 1
   DG 2008-07-16-12:02:51 1000000 3 660162668 -- default_state READ-WRITE-XPTON (11)
   DG 2008-07-16-12:02:51 1000000 3 660162668 Adding internal resource helios_site_tracker pid 1000001 parent_state STANDBY (6) vinst 2
   DG 2008-07-16-12:02:51 1000000 3 660162668 -- default_state PHYSICAL-APPLY-ON (6)
   DG 2008-07-16-12:02:51 0 2 0 RSM: error in accessing metadata.
   DG 2008-07-16-12:02:51 0 2 0 Log Apply: Harvesting property LsbyMaxSga, row name MAX_SGA
   DG 2008-07-16-12:02:51 0 2 0 RSM: error in accessing metadata.
   DG 2008-07-16-12:02:51 0 2 0 Log Apply: Harvesting property LsbyMaxServers, row name MAX_SERVERS
   DG 2008-07-16-12:02:51 0 2 0 RSM: error in accessing metadata.
   DG 2008-07-16-12:02:51 0 2 0 Log Apply: Harvesting property LsbyMaxEventsRecorded, row name MAX_EVENTS_RECORDED
   DG 2008-07-16-12:02:51 0 2 0 RSM: error in accessing metadata.
   DG 2008-07-16-12:02:51 0 2 0 Log Apply: Harvesting property LsbyTxnConsistency, row name TRANSACTION_CONSISTENCY
   DG 2008-07-16-12:02:51 0 2 0 RSM: error in accessing metadata.
   DG 2008-07-16-12:02:51 0 2 0 Log Apply: Harvesting property LsbyRecordSkipErrors, row name RECORD_SKIP_ERRORS
   DG 2008-07-16-12:02:51 0 2 0 RSM: error in accessing metadata.
   DG 2008-07-16-12:02:51 0 2 0 Log Apply: Harvesting property LsbyRecordSkipDdl, row name RECORD_SKIP_DDL
   DG 2008-07-16-12:02:51 0 2 0 RSM: error in accessing metadata.
   DG 2008-07-16-12:02:51 0 2 0 Log Apply: Harvesting property LsbyRecordAppliedDdl, row name RECORD_APPLIED_DDL
   DG 2008-07-16-12:02:51 1000100 4 660162668 Add resource helios_site_tracker succeeded.
   DG 2008-07-16-12:02:51 1000100 4 660162668 DMON: ADD_RES: success
   DG 2008-07-16-12:02:58 0 2 660162669 Add site telescopium_site succeeded.
   DG 2008-07-16-12:02:58 0 2 660162669 DMON: ADD_SITE: success
   DG 2008-07-16-12:02:58 2000000 3 660162670 DMON: GET_ID: success. (len = 99)
   DG 2008-07-16-12:02:58 2000000 3 660162671 DMON: GET_SITE: success. (len = 403)
   DG 2008-07-16-12:02:58 2000000 3 660162672 Adding internal resource telescopium_site_tracker pid 2000001 parent_state ONLINE (1) vinst 0
   DG 2008-07-16-12:02:58 2000000 3 660162672 -- default_state OFFLINE (0)
   DG 2008-07-16-12:02:58 2000000 3 660162672 Adding internal resource telescopium_site_tracker pid 2000001 parent_state PRIMARY (5) vinst 1
   DG 2008-07-16-12:02:58 2000000 3 660162672 -- default_state READ-WRITE-XPTON (11)
   DG 2008-07-16-12:02:58 2000000 3 660162672 Adding internal resource telescopium_site_tracker pid 2000001 parent_state STANDBY (6) vinst 2
   DG 2008-07-16-12:02:58 2000000 3 660162672 -- default_state PHYSICAL-APPLY-ON (6)
   DG 2008-07-16-12:03:10 0 2 0 PMON: DMON terminated abnormally, beginning cleanup
   DG 2008-07-16-12:03:10 0 2 0 PMON: Zeroing metadata root pointer
   DG 2008-07-16-12:03:10 0 2 0 PMON: Terminating RSM processes
   DG 2008-07-16-12:03:10 0 2 0 PMON: Terminating NetSlave processes
   DG 2008-07-16-12:03:10 0 2 0 PMON: Freeing Broker SGA heap
   DG 2008-07-16-12:03:10 0 2 0 PMON: Zeroing DMON's PGA heap pointer
   DG 2008-07-16-12:03:10 0 2 0 PMON: Removing DMON's state object
   DG 2008-07-16-12:03:10 0 2 0 PMON: Setting dg_broker_start to FALSE
   DG 2008-07-16-12:03:10 0 2 0 PMON: Resetting DMON context structure
   DG 2008-07-16-12:03:10 0 2 0 PMON: >> Broker cleanup complete <<
   
  5. part of alert file
   Wed Jul 16 12:01:30 2008
   ALTER SYSTEM SET dg_broker_start=TRUE SCOPE=BOTH;
   DMON started with pid=40
   Starting Data Guard Broker (DMON)
   Wed Jul 16 12:03:10 2008
   Completed: Data Guard Broker shutdown
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 15 2008
Added on Jul 16 2008
6 comments
2,164 views