2010-11-18 10:13:50.879 DMON: >> Starting Data Guard Broker bootstrap << 2010-11-18 10:13:50.895 DMON: Broker Configuration File Locations: 2010-11-18 10:13:50.895 dg_broker_config_file1 = "C:\APP\PATILSA\PRODUCT\11.2.0\DBHOME_1\DATABASE\DR1PRIMARY.DAT" 2010-11-18 10:13:50.895 dg_broker_config_file2 = "C:\APP\PATILSA\PRODUCT\11.2.0\DBHOME_1\DATABASE\DR2PRIMARY.DAT" 2010-11-18 10:13:50.895 DMON: Attach state object 2010-11-18 10:13:50.973 DMON: rfafoGetLocks reinitializing dubious PMYSHUT lock value block contents: flags=0x0, spare1=0x0, spare2=0x0, cksm=0x0, rndm=0x0 2010-11-18 10:13:50.973 DMON: Entered rfm_get_chief_lock() for CTL_BOOTSTRAP, reason 2 2010-11-18 10:13:50.973 7fffffff 0 DMON: chief lock convert for bootstrap 2010-11-18 10:13:50.973 DMON: Boot configuration (0.0.0), loading from "C:\APP\PATILSA\PRODUCT\11.2.0\DBHOME_1\DATABASE\DR1PRIMARY.DAT" 2010-11-18 10:13:51.004 DMON Registering service primary_DGB with listener(s) 2010-11-18 10:13:51.004 Executing SQL [ALTER SYSTEM REGISTER] 2010-11-18 10:13:51.004 SQL [ALTER SYSTEM REGISTER] Executed successfully 2010-11-18 10:13:51.004 DMON: ...committing load to memory, Seq.MIV = 4.2 2010-11-18 10:13:51.020 DMON: Broker Configuration: "sample" 2010-11-18 10:13:51.020 Metadata Version: 3.0 / UID=0x9ebd80d2 / Seq.MIV=4.2 / blksz.grain=4096.8 2010-11-18 10:13:51.020 Protection Mode: Maximum Performance 2010-11-18 10:13:51.020 Fast-Start Failover (FSFO): Disabled, flags=0x0, version=0 2010-11-18 10:13:51.020 Primary Database: primary (0x01010000) 2010-11-18 10:13:51.020 Standby Database: secondary, Enabled Physical Standby (0x02010000) 2010-11-18 10:13:51.020 DMON: Instance ID 1 is the broker FSFP HOME instance 2010-11-18 10:13:51.020 DMON: Instance ID 1 is the broker health check master 2010-11-18 10:13:55.754 NSV1: Failed to connect to remote database secondary. Error is ORA-12514 2010-11-18 10:13:55.754 NSV1: Failed to send message to site secondary. Error code is ORA-12514. 2010-11-18 10:13:58.754 00001000 1753368367 DMON: Version Check Results 2010-11-18 10:13:58.754 00001000 1753368367 Database secondary returned ORA-12514 2010-11-18 10:13:58.769 DMON: FSFO ack received 2010-11-18 10:13:58.785 00001000 1753368367 DMON: messaging RSM to bootstrap locally 2010-11-18 10:13:58.801 DMON: Creating process RSM0 2010-11-18 10:14:01.816 RSM0: Process state object initialization complete 2010-11-18 10:14:02.800 00001000 1753368367 DMON: Entered rfm_release_chief_lock() for CTL_VC 2010-11-18 10:14:02.800 RSM0: Received Set State Request: rid=0x01010001, sid=9, phid=2, econd=7, sitehndl=0x01001000 2010-11-18 10:14:02.800 Database Resource[IAM=PRIMARY]: SetState READ-WRITE-XPTON, phase BUILD-UP, External Cond ENABLE, Target Site Handle 0x01001000 2010-11-18 10:14:02.832 Set log transport destination: SetState ONLINE, phase BUILD-UP, External Cond ENABLE 2010-11-18 10:14:03.519 NSV1: Failed to connect to remote database secondary. Error is ORA-12514 2010-11-18 10:14:03.519 NSV1: Failed to send message to site secondary. Error code is ORA-12514. 2010-11-18 10:14:03.519 00000000 1753368368 DMON: Database secondary returned ORA-12514 2010-11-18 10:14:03.519 00000000 1753368368 for opcode = HEALTH_CHECK, phase = BEGIN, req_id = 1.1.1753368368 2010-11-18 10:14:04.769 Executing SQL [ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH sid='primary'] 2010-11-18 10:14:04.925 SQL [ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH sid='primary'] Executed successfully 2010-11-18 10:14:04.925 Executing SQL [ALTER SYSTEM SET log_archive_format='ARC%S_%R.%T' SCOPE=SPFILE sid='primary'] 2010-11-18 10:14:06.613 SQL [ALTER SYSTEM SET log_archive_format='ARC%S_%R.%T' SCOPE=SPFILE sid='primary'] Executed successfully 2010-11-18 10:14:07.035 Executing SQL [ALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=BOTH sid='*'] 2010-11-18 10:14:07.113 SQL [ALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=BOTH sid='*'] Executed successfully 2010-11-18 10:14:07.441 Executing SQL [ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH sid='*'] 2010-11-18 10:14:07.550 SQL [ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH sid='*'] Executed successfully 2010-11-18 10:14:07.582 Executing SQL [ALTER SYSTEM SET log_archive_max_processes=30 SCOPE=BOTH sid='*'] 2010-11-18 10:14:07.707 SQL [ALTER SYSTEM SET log_archive_max_processes=30 SCOPE=BOTH sid='*'] Executed successfully 2010-11-18 10:14:07.878 Executing SQL [ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH sid='*'] 2010-11-18 10:14:08.050 SQL [ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH sid='*'] Executed successfully 2010-11-18 10:14:08.347 Database Resource SetState succeeded 2010-11-18 10:14:08.378 RSM0: HEALTH CHECK ERROR: ORA-16782: instance not open for read and write access 2010-11-18 10:14:09.503 00000000 1753368368 Operation HEALTH_CHECK canceled during phase 2, error = ORA-16782 2010-11-18 10:14:09.597 00000000 1753368368 Operation HEALTH_CHECK canceled during phase 2, error = ORA-16782 2010-11-18 10:14:48.237 Executing SQL [ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=MEMORY SID='*'] 2010-11-18 10:14:48.252 SQL [ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=MEMORY SID='*'] Executed successfully 2010-11-18 10:14:54.533 DRCX: DRCX_NS_GDVER returning: UID=0x9ebd80d2 / Seq.MIV=4.2 2010-11-18 10:14:54.643 Executing SQL [alter system set log_archive_dest_state_2 = 'ENABLE'] 2010-11-18 10:14:55.096 SQL [alter system set log_archive_dest_state_2 = 'ENABLE'] Executed successfully 2010-11-18 10:14:55.096 DMON: Messaged RSM0 to reset single destination 2010-11-18 10:15:13.783 00000000 1753368370 DMON: Database secondary is still working on the task.