10g R2 DGMGRL

显示全部楼层 · 2005-10-30 17:05:33

配置成功后
log_archive_dest_2变成了
service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.3.169)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=hisdb_dg_XPT.saptac.com)(INSTANCE_NAME=hisdb)(SERVER=dedicated)))",LGWR SYNC AFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="hisdb_dg" register net_timeout=180valid_for=(online_logfile,primary_role)
原来是
service="hisdb_dg LGWR SYNC AFFIRM'
谁说说为什么会成这样的？

千问 · 2005-10-30 17:05:33

也就是说data guard control 接管了这个操作，然后做一些相应的控制。

千问 · 2005-10-30 17:05:33

看来这些是根据缺省参数配置的。
不过 SERVICE_NAME=hisdb_dg_XPT.saptac.com是如何得到的就很奇怪了

DGMGRL> show database verbose hisdb
Database
Name:
hisdb
Role:
PRIMARY
Enabled: YES
Intended State:ONLINE
Instance(s):
hisdb
Properties:
InitialConnectIdentifier= 'system'
LogXptMode
= 'ASYNC'
Dependency
= ''
DelayMins
= '0'
Binding
= 'OPTIONAL'
MaxFailure
= '0'
MaxConnections
= '1'
ReopenSecs
= '300'
NetTimeout
= '180'
LogShipping
= 'ON'
PreferredApplyInstance
= ''
ApplyInstanceTimeout
= '0'
ApplyParallel
= 'AUTO'
StandbyFileManagement = 'MANUAL'
ArchiveLagTarget
= '1800'
LogArchiveMaxProcesses
= '2'
LogArchiveMinSucceedDest= '1'
DbFileNameConvert
= ''
LogFileNameConvert
= ''
FastStartFailoverTarget = ''
StatusReport
= '(monitor)'
InconsistentProperties
= '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries
= '(monitor)'
LogXptStatus
= '(monitor)'
RecvQEntries
= '(monitor)'
HostName
= 'HISDB1'
SidName
= 'hisdb'
LocalListenerAddress
= '(ADDRESS=(PROTOCOL=tcp)(HOST=HISDB1)(PORT=1521))'
StandbyArchiveLocation
= 'D:\oracle\product\10.2.0\oradata\hisdb\archive'
AlternateLocation
= ''
LogArchiveTrace
= '0'
LogArchiveFormat
= 'ARC%S_%R.%T'
LatestLog
= '(monitor)'
TopWaitEvents
= '(monitor)'
"hisdb" 的当前状态:
SUCCESS
DGMGRL> show instance verbose hisdb on database hisdb
Instance 'hisdb' of database 'hisdb'
Host Name: HISDB1
PFILE:
Properties:
HostName
= 'HISDB1'
SidName
= 'hisdb'
LocalListenerAddress
= '(ADDRESS=(PROTOCOL=tcp)(HOST=HISDB1)(PORT=1521))'
StandbyArchiveLocation
= 'D:\oracle\product\10.2.0\oradata\hisdb\archive'
AlternateLocation
= ''
LogArchiveTrace
= '0'
LogArchiveFormat
= 'ARC%S_%R.%T'
LatestLog
= '(monitor)'
TopWaitEvents
= '(monitor)'
"hisdb" 的当前状态:
SUCCESS