DGMGRL> connect sys/sys123@scada
已连接。
DGMGRL> show configuration verbose
Configuration
Name: YHTEST
Enabled: YES
Protection Mode: MaxAvailability
Fast-Start Failover: DISABLED
Databases:
scada - Primary database
scadabak - Physical standby database
"YHTEST" 的当前状态:
SUCCESS
DGMGRL> show database verbose 'scada'
Database
Name: scada
Role: PRIMARY
Enabled: YES
Intended State: ONLINE
Instance(s):
scada
Properties:
InitialConnectIdentifier = 'scada'
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 = 'scadabak, scada'
LogFileNameConvert = ''
FastStartFailoverTarget = 'scadabak'
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'IBM01'
SidName = 'scada'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=tcp)(HOST=IBM01)(PORT=
1521))'
StandbyArchiveLocation = 'dgsby_scada'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.arc'
LatestLog = '(monitor)'
TopWaitEvents = '(monitor)'
"scada" 的当前状态:
SUCCESS
DGMGRL> show database verbose 'scadabak'
Database
Name: scadabak
Role: PHYSICAL STANDBY
Enabled: YES
Intended State: ONLINE
Instance(s):
scada
Properties:
InitialConnectIdentifier = 'scadabak'
LogXptMode = 'SYNC'
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 = 'scadabak, scada'
LogFileNameConvert = ''
FastStartFailoverTarget = 'scada'
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'IBM02'
SidName = 'scada'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=tcp)(HOST=IBM02)(PORT=
1521))'
StandbyArchiveLocation = '/rdbm/orasrv/oradata/scada/archivelog/'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.arc'
LatestLog = '(monitor)'
TopWaitEvents = '(monitor)'
"scadabak" 的当前状态:
SUCCESS
上面是DGMGRL中的信息,做switchover已经没有问题,但是
DGMGRL> enable fast_start failover
错误: ORA-16651: 不能满足启用快速启动故障转移的要求
失败。
已经按文档上检查了,不知道还有什么地方没满足。
附上文档中的要求:
■ Ensure the broker configuration is running in maximum availability mode.
■ Enable Flashback Database and set up a flash recovery area on both the primary database and the target standby database.
■ Install the DGMGRL command-line interface on the observer computer as described in Section 2.1.
■ Configure the TNSNAMES.ORA file on the observer system so that the observer is able to connect to the primary database and the pre-selected target standby database.