- 最后登录
- 2013-11-19
- 在线时间
- 11 小时
- 威望
- 24
- 金钱
- 236
- 注册时间
- 2012-5-5
- 阅读权限
- 10
- 帖子
- 26
- 精华
- 0
- 积分
- 24
- UID
- 413
|
1#
发表于 2012-6-14 15:54:12
|
查看: 7502 |
回复: 2
DB:10.2.0.1 _32
OS:redhat 5.4 _32
主:prod
备:proddg
完成broker后在备库添加了standby_redo日志文件,操作过程是先在sqlplus里面关闭redo应用,添加日志,重启应用。
prod 操作
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode
proddg drcprod.log 一直在重复报错
0 2 0 DMON: HEALTH CHECK ERROR: ORA-16766: Redo Apply unexpectedly offline
0 2 785792158 Operation CTL_GET_STATUS cancelled during phase 1, error = ORA-16766
prod drcprod.log 一直在重复报错
DG 2012-06-14-15:43:11 0 2 785792155 Operation CTL_GET_STATUS cancelled during phase 2, error = ORA-16778
DG 2012-06-14-15:43:11 0 2 785792155 Operation CTL_GET_STATUS cancelled during phase 2, error = ORA-16778
DG 2012-06-14-15:44:11 0 2 0 RSM detected log transport problem: log transport for database 'proddg' has the following error.
DG 2012-06-14-15:44:11 0 2 0 ORA-16143: RFS connections not allowed during or after terminal recovery
DG 2012-06-14-15:44:11 0 2 0 RSM0: HEALTH CHECK ERROR: ORA-16737: the redo transport service for standby database "proddg" has an error
proddg状态
DGMGRL> show database verbose proddg
Database
Name: proddg
Role: PHYSICAL STANDBY
Enabled: YES
Intended State: ONLINE
Instance(s):
prod
Properties:
InitialConnectIdentifier = 'proddg'
LogXptMode = 'ARCH'
Dependency = ''
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '2'
ReopenSecs = '300'
NetTimeout = '180'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '1800'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'ex0044'
SidName = 'prod'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=tcp)(HOST=ex0044)(PORT=1521))'
StandbyArchiveLocation = '/u01/app/oracle/archivelog/prod'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
LatestLog = '(monitor)'
TopWaitEvents = '(monitor)'
Current status for "proddg":
Error: ORA-16766: Redo Apply unexpectedly offline
LogXptStatus :
DGMGRL> show database prod LogXptStatus ;
LOG TRANSPORT STATUS
PRIMARY_INSTANCE_NAME STANDBY_DATABASE_NAME STATUS
prod proddg ORA-16143: RFS connections not allowed during or after terminal recovery
DGMGRL> show database proddg LogXptStatus;
Error: ORA-16757: resource guard could not get property
上面的信息都是在报redo apply offline了,这有点不太明白,莫非由于关闭redo应用是手工的和broker冲突了?请各位指点迷津,谢谢。
[ 本帖最后由 alicejapan 于 2012-6-14 16:16 编辑 ] |
|