ENMOEDU 主库 ORA11GR2 备库
[root@ora2 ~]# su - oracle
[oracle@ora2 ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/oracle@ ENMOEDU
Connected.
DGMGRL> SHOW CONFIGURATION VERBOSE;
Configuration - sdf
Protection Mode: MaxAvailability
Databases:
enmoedu - Primary database
Warning: ORA-16792: configurable property value is inconsistent with database setting
ora11gr2 - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
DGMGRL> SHOW DATABASE VERBOSE ENMOEDU;
Database - enmoedu
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
ENMOEDU
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting
Properties:
DGConnectIdentifier = 'enmoedu'
ObserverConnectIdentifier = ''
LogXptMode = 'SYNC'
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 = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = 'ORA11GR2, ENMOEDU'
LogFileNameConvert = 'ORA11GR2, ENMOEDU'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'ENMOEDU'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ENMOEDU_DGMGRL)(INSTANCE_NAME=ENMOEDU)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u01/app/oracle/fast_recovery_area/ENMOEDU'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.arc'
TopWaitEvents = '(monitor)'
Database Status:
WARNING
DGMGRL> HELP EDIT;
Edits a configuration, database, or instance
Syntax
EDIT CONFIGURATION SET PROTECTION MODE AS
{MaxProtection|MaxAvailability|MaxPerformance};
EDIT CONFGURATION SET PROPERTY = ;
EDIT DATABASE SET PROPERTY = ;
EDIT DATABASE RENAME TO ;
EDIT DATABASE SET STATE =
[WITH APPLY INSTANCE = ];
EDIT INSTANCE [ON DATABASE ]
SET AUTO PFILE [ = {|OFF} ];
EDIT INSTANCE [ON DATABASE ]
SET PROPERTY = ;
EDIT INSTANCE * ON DATABASE
SET PROPERTY = ;
DGMGRL> EDIT DATABASE ENMOEDU SET PROPERTY ArchiveLagTarget=0;
Property "archivelagtarget" updated
DGMGRL> EDIT DATABASE ENMOEDU SET PROPERTY LogArchiveMaxProcesses=4;
Property "logarchivemaxprocesses" updated
DGMGRL> EDIT DATABASE ENMOEDU SET PROPERTYLogArchiveMinSucceedDest=1;
DGMGRL> EDIT DATABASE ENMOEDU SET PROPERTY LogArchiveMinSucceedDest=1;
Property "logarchiveminsucceeddest" updated
DGMGRL> SHOW DATABASE VERBOSE enmoedu;
Database - enmoedu
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
ENMOEDU
Properties:
DGConnectIdentifier = 'enmoedu'
ObserverConnectIdentifier = ''
LogXptMode = 'SYNC'
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 = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = 'ORA11GR2, ENMOEDU'
LogFileNameConvert = 'ORA11GR2, ENMOEDU'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'ENMOEDU'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ENMOEDU_DGMGRL)(INSTANCE_NAME=ENMOEDU)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u01/app/oracle/fast_recovery_area/ENMOEDU'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.arc'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
[root@ora2 ~]# su - oracle
[oracle@ora2 ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/oracle@ ENMOEDU
Connected.
DGMGRL> SHOW CONFIGURATION VERBOSE;
Configuration - sdf
Protection Mode: MaxAvailability
Databases:
enmoedu - Primary database
Warning: ORA-16792: configurable property value is inconsistent with database setting
ora11gr2 - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
DGMGRL> SHOW DATABASE VERBOSE ENMOEDU;
Database - enmoedu
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
ENMOEDU
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting
Properties:
DGConnectIdentifier = 'enmoedu'
ObserverConnectIdentifier = ''
LogXptMode = 'SYNC'
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 = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = 'ORA11GR2, ENMOEDU'
LogFileNameConvert = 'ORA11GR2, ENMOEDU'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'ENMOEDU'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ENMOEDU_DGMGRL)(INSTANCE_NAME=ENMOEDU)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u01/app/oracle/fast_recovery_area/ENMOEDU'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.arc'
TopWaitEvents = '(monitor)'
Database Status:
WARNING
DGMGRL> HELP EDIT;
Edits a configuration, database, or instance
Syntax
EDIT CONFIGURATION SET PROTECTION MODE AS
{MaxProtection|MaxAvailability|MaxPerformance};
EDIT CONFGURATION SET PROPERTY = ;
EDIT DATABASE SET PROPERTY = ;
EDIT DATABASE RENAME TO ;
EDIT DATABASE SET STATE =
[WITH APPLY INSTANCE = ];
EDIT INSTANCE [ON DATABASE ]
SET AUTO PFILE [ = {|OFF} ];
EDIT INSTANCE [ON DATABASE ]
SET PROPERTY = ;
EDIT INSTANCE * ON DATABASE
SET PROPERTY = ;
DGMGRL> EDIT DATABASE ENMOEDU SET PROPERTY ArchiveLagTarget=0;
Property "archivelagtarget" updated
DGMGRL> EDIT DATABASE ENMOEDU SET PROPERTY LogArchiveMaxProcesses=4;
Property "logarchivemaxprocesses" updated
DGMGRL> EDIT DATABASE ENMOEDU SET PROPERTYLogArchiveMinSucceedDest=1;
DGMGRL> EDIT DATABASE ENMOEDU SET PROPERTY LogArchiveMinSucceedDest=1;
Property "logarchiveminsucceeddest" updated
DGMGRL> SHOW DATABASE VERBOSE enmoedu;
Database - enmoedu
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
ENMOEDU
Properties:
DGConnectIdentifier = 'enmoedu'
ObserverConnectIdentifier = ''
LogXptMode = 'SYNC'
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 = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = 'ORA11GR2, ENMOEDU'
LogFileNameConvert = 'ORA11GR2, ENMOEDU'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'ENMOEDU'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ENMOEDU_DGMGRL)(INSTANCE_NAME=ENMOEDU)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u01/app/oracle/fast_recovery_area/ENMOEDU'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.arc'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30176559/viewspace-1697040/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30176559/viewspace-1697040/