Database Software

2 NODES RAC (Primary) ==> Single instance (Standby) (archived logs transfer is working well)

i checked: dg_broker_start parameter is TRUE for standby and primary;
it says "redo transport service to a standby database is not running" but when i run "alter system switch logfile" on primary; , i can see applied logs on stanby side, it s working well. but broker says me, redo transport service to a standby database is not running,


Question) Error: ORA-16764: redo transport service to a standby database is not running; logs as shown below; how can i check and debug status of redu transport service?

After solve this problem. i want to run "switchover to 'kkguard'" command,


Primary side (Node 1)
==
DGMGRL> CREATE CONFIGURATION 'kkracconfig' AS PRIMARY DATABASE IS 'kkrac' CONNECT IDENTIFIER IS kkrac;
DGMGRL> ADD DATABASE 'kkguard' AS CONNECT IDENTIFIER IS kkguard MAINTAINED AS PHYSICAL;
DGMGRL> enable configuration;
DGMGRL> show configuration;

Configuration - kkracconfig

Protection Mode: MaxPerformance
Databases:
kkrac - Primary database
Error: ORA-16764: redo transport service to a standby database is not running

kkguard - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
ERROR


DGMGRL> show database verbose kkrac;

Database - kkrac

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
kkrac1
kkrac2

Properties:
DGConnectIdentifier = 'kkrac'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '30'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '+DATA/kkguard, +DATA/kkrac'
LogFileNameConvert = '+DATA/kkguard, +DATA/kkrac'
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName(*)
SidName(*)
StaticConnectIdentifier(*)
StandbyArchiveLocation(*)
AlternateLocation(*)
LogArchiveTrace(*)
LogArchiveFormat(*)
TopWaitEvents(*)
(*) - Please check specific instance for the property value

Database Status:
SUCCESS


DGMGRL> show database verbose kkguard;

Database - kkguard

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
kkguard

Properties:
DGConnectIdentifier = 'kkguard'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '30'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '+DATA/kkrac, +DATA/kkguard'
LogFileNameConvert = '+DATA/kkrac, +DATA/kkguard'
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'kkguard.mydomain.com.tr'
SidName = 'kkguard'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kkguard.mydomain.com.tr)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=KKGUARD_DGMGRL)(INSTANCE_NAME=kkguard)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'

Database Status:
SUCCESS


anyfeedback
makes me happy,

best regards

==
Ali Okan YÜKSEL

Edited by: user13498255 on 17.Ara.2010 05:43