Home » Server Options » Data Guard » DG Broker .Warning: ORA-16607: one or more databases have failed (Oracle10g R2 , RHEL 4)
DG Broker .Warning: ORA-16607: one or more databases have failed [message #501684] Wed, 30 March 2011 12:23 Go to next message
farnaw4u
Messages: 22
Registered: October 2006
Location: pakistan
Junior Member
Dear all

I have one primary database server and one physical standby database serve. but i am unable to fix "ORA-16607" while enabling configuration. during log switch redo data is being applied to the phy standby side but some thing wrong happens in BROKER


here are details........about my configuration


Primary database name PRIM
Physical Database Name STAN

net service PRIM
net service STAN


DGMGRL> show configuration

Configuration
Name: test
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
prim - Primary database
stan - Physical standby database

Current status for "test":
Warning: ORA-16607: one or more databases have failed

======================================================
Alert log file First para show no problem for for redo to be transmitted to stndby
======================================================

LNS1 started with pid=48, OS id=5408
Thu Sep 21 21:32:03 2006
Thread 1 advanced to log sequence 59
Current log# 1 seq# 59 mem# 0: /u01/app/oracle/oradata/PRIM/redo01.log
Thu Sep 21 21:32:03 2006
ARC8: Standby redo logfile selected for thread 1 sequence 58 for destination LOG_ARCHIVE_DEST_2
Thu Sep 21 21:32:04 2006
LNS: Standby redo logfile selected for thread 1 sequence 59 for destination LOG_ARCHIVE_DEST_2
Thu Sep 21 21:32:18 2006
Thread 1 advanced to log sequence 60
Current log# 2 seq# 60 mem# 0: /u01/app/oracle/oradata/PRIM/redo02.log
Thu Sep 21 21:32:19 2006
LNS: Standby redo logfile selected for thread 1 sequence 60 for destination LOG_ARCHIVE_DEST_2
Thu Sep 21 21:39:09 2006
Thread 1 advanced to log sequence 61
Current log# 3 seq# 61 mem# 0: /u01/app/oracle/oradata/PRIM/redo03.log
Thu Sep 21 21:39:10 2006
LNS: Standby redo logfile selected for thread 1 sequence 61 for destination LOG_ARCHIVE_DEST_2




INSV started with pid=51, OS id=5492
NSV1 started with pid=52, OS id=5511
RSM0 started with pid=53, OS id=5513
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET log_archive_dest_2='service=" (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=STAND)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=stan_XPT)(INSTANCE_NAME=STAN)( SERVER=dedicated))) "',' LGWR ASYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="stan" register net_timeout=180 valid_for=(online_logfile,primary_role)' SCOPE=BOTH;
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='PRIM';
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET log_archive_format='%t_%s_%r.arc' SCOPE=SPFILE SID='PRIM';
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET standby_archive_dest='' SCOPE=BOTH SID='PRIM';
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET log_archive_dest_1='location="/u01/app/oracle/flash_recovery_area/PRIM/archivelog/"','valid_for=(ONLINE_LOGFILE,ALL_ROLES)' SCOPE=BOTH SID='PRIM';
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET log_archive_dest_state_1='ENABLE' SCOPE=BOTH SID='PRIM';
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET log_archive_max_processes=30 SCOPE=BOTH SID='*';
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET db_file_name_convert='/u01/app/oracle/oradata/STAN','/u01/app/oracle/oradata/PRIM' SCOPE=SPFILE;
Thu Sep 21 21:44:54 2006
ALTER SYSTEM SET log_file_name_convert='/u01/app/oracle/oradata/STAN','/u01/app/oracleoradata/PRIM' SCOPE=SPFILE;
LNS1 started with pid=48, OS id=5515
Thu Sep 21 21:45:01 2006
Thread 1 advanced to log sequence 62
Current log# 1 seq# 62 mem# 0: /u01/app/oracle/oradata/PRIM/redo01.log
Thu Sep 21 21:45:01 2006
Error 12545 received logging on to the standby
Thu Sep 21 21:45:01 2006
Errors in file /u01/app/oracle/admin/PRIM/bdump/prim_arcf_5305.trc:
ORA-12545: Connect failed because target host or object does not exist
Thu Sep 21 21:45:01 2006
ALTER SYSTEM SET log_archive_dest_2='service=" (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=STAND)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=stan_XPT)(INSTANCE_NAME=STAN)( SERVER=dedicated))) "',' LGWR ASYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="stan" register net_timeout=180 valid_for=(online_logfile,primary_role)' SCOPE=BOTH;
Thu Sep 21 21:45:02 2006
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
FAL[server, ARCf]: Error 12545 creating remote archivelog file '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=STAND)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=stan_XPT)(INSTANCE_NAME=STAN) (SERVER=dedicated)))'
Thu Sep 21 21:45:02 2006
Thread 1 advanced to log sequence 63
Current log# 2 seq# 63 mem# 0: /u01/app/oracle/oradata/PRIM/redo02.log
Thu Sep 21 21:45:02 2006
FAL[server, ARCf]: FAL archive failed, see trace file.
Thu Sep 21 21:45:02 2006
Errors in file /u01/app/oracle/admin/PRIM/bdump/prim_arcf_5305.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Thu Sep 21 21:45:02 2006
ORACLE Instance PRIM - Archival Error. Archiver continuing.
Thu Sep 21 21:50:51 2006
Error 12545 received logging on to the standby
Thu Sep 21 21:50:51 2006
Errors in file /u01/app/oracle/admin/PRIM/bdump/prim_arc6_5287.trc:
ORA-12545: Connect failed because target host or object does not exist
PING[ARC6]: Heartbeat failed to connect to standby '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=STAND)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=stan_XPT)(INSTANCE_NAME=STAN) (SERVER=dedicated)))'. Error is 12545.


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
here is parameter file on Primary DB server
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

PRIM.__db_cache_size=184549376
PRIM.__java_pool_size=4194304
PRIM.__large_pool_size=4194304
PRIM.__shared_pool_size=83886080
PRIM.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/PRIM/adump'
*.background_dump_dest='/u01/app/oracle/admin/PRIM/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/PRIM/control01.ctl','/u01/app/oracle/oradata/PRIM/control02.ctl','/u01/app/oracle/oradata/PR IM/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/PRIM/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='PRIM'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRIMXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=283115520
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/PRIM/udump'


db_name=PRIM
db_unique_name=PRIM


LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIM,STAN)'

LOG_ARCHIVE_DEST_1=
'LOCATION=/u01/app/oracle/flash_recovery_area/PRIM/archivelog/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=PRIM'


LOG_ARCHIVE_DEST_2=
'SERVICE=STAN LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=STAN'


LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30

remote_login_passwordfile='EXCLUSIVE'


FAL_SERVER=STAN
FAL_CLIENT=PRIM


STANDBY_FILE_MANAGEMENT=AUTO


DB_FILE_NAME_CONVERT='/u01/app/oracle/STAN','/u01/app/oracle/oradata/PRIM'

LOG_FILE_NAME_CONVERT='/u01/app/oracle/STAN','/u01/app/oracle/oradata/PRIM'



Please help me where is problem.

Thanks




[Updated on: Wed, 30 March 2011 12:26]

Report message to a moderator

Re: DG Broker .Warning: ORA-16607: one or more databases have failed [message #501686 is a reply to message #501684] Wed, 30 March 2011 12:30 Go to previous messageGo to next message
John Watson
Messages: 8321
Registered: January 2010
Location: Global Village
Senior Member
What was the result of the broker commands

show database verbose prim
show database verbose stan

Re: DG Broker .Warning: ORA-16607: one or more databases have failed [message #501689 is a reply to message #501686] Wed, 30 March 2011 13:00 Go to previous message
farnaw4u
Messages: 22
Registered: October 2006
Location: pakistan
Junior Member
Thanks John

here is out put



DGMGRL> show database verbose prim

Database
Name: prim
Role: PRIMARY
Enabled: YES
Intended State: ONLINE
Instance(s):
PRIM

Properties:
InitialConnectIdentifier = 'prim'
LogXptMode = 'ASYNC'
Dependency = ''
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '180'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '30'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '/u01/app/oracle/oradata/STAN, /u01/app/oracle/oradata/PRIM'
LogFileNameConvert = '/u01/app/oracle/oradata/STAN, /u01/app/oracleoradata/PRIM'
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'PRIM'
SidName = 'PRIM'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=TCP)(HOST=PRIM)(PORT=1522))'
StandbyArchiveLocation = '/u01/app/oracle/flash_recovery_area/PRIM/archivelog/'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.arc'
LatestLog = '(monitor)'
TopWaitEvents = '(monitor)'

Current status for "prim":
Error: ORA-16810: multiple errors or warnings detected for the database


DGMGRL> show database verbose stan

Database
Name: stan
Role: PHYSICAL STANDBY
Enabled: YES
Intended State: ONLINE
Instance(s):
STAN

Properties:
InitialConnectIdentifier = 'stan'
LogXptMode = 'ASYNC'
Dependency = ''
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '180'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '30'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '/u01/app/oracle/oradata/PRIM, /u01/app/oracle/oradata/STAN'
LogFileNameConvert = '/u01/app/oracle/oradata/PRIM, /u01/app/oracle/oradata/STAN'
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'STAND'
SidName = 'STAN'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=TCP)(HOST=STAND)(PORT=1523))'
StandbyArchiveLocation = '/u01/app/oracle/flash_recovery_area/STAN/archivelog/'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.arc'
LatestLog = '(monitor)'
TopWaitEvents = '(monitor)'

Current status for "stan":
Error: ORA-12545: Connect failed because target host or object does not exist


Previous Topic: DATA FILES IN Storage Area Network(SAN)
Next Topic: Oracle data guard standby database recovery
Goto Forum:
  


Current Time: Thu Aug 13 01:39:43 CDT 2020