data guard problem
455224Jul 16 2008 — edited Jul 18 2008Hi,
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