[20140422]使用dgmgrl管理dataguard(14)

[20140422]使用dgmgrl管理dataguard(14).txt

-- 我的测试环境：primary的tnsnames别名test，standby主机的tnsnames别名testdg。数据库版本：11GR2.
-- 基本学习完成,再补充一些不常用命令:

DGMGRL> help

The following commands are available:

add            Adds a standby database to the broker configuration
connect        Connects to an Oracle database instance
convert        Converts a database from one type to another
create         Creates a broker configuration
disable        Disables a configuration, a database, or fast-start failover
edit           Edits a configuration, database, or instance
enable         Enables a configuration, a database, or fast-start failover
exit           Exits the program
failover       Changes a standby database to be the primary database
help           Displays description and syntax for a command
quit           Exits the program
reinstate      Changes a database marked for reinstatement into a viable standby
rem            Comment to be ignored by DGMGRL
remove         Removes a configuration, database, or instance
show           Displays information about a configuration, database, or instance
shutdown       Shuts down a currently running Oracle database instance
sql            Executes a SQL statement
start          Starts the fast-start failover observer
startup        Starts an Oracle database instance
stop           Stops the fast-start failover observer
switchover     Switches roles between a primary and standby database

Use "help " to see syntax for individual commands

-- 还可以在dgmgrl执行startup以及shutdown数据库.使用一些sql可以执行一些管理命令.
DGMGRL> connect sys/btbtms@test
Connected.
DGMGRL> sql 'alter system checkpoint ';
Succeeded.

DGMGRL> show database verbose test
Database - test
Role:            PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
    test
Properties:
    DGConnectIdentifier             = 'test'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'enable'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'auto'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = '/u01/app/oracle11g/oradata/test, /u01/app/oracle11g/oradata/test'
    LogFileNameConvert              = '/u01/app/oracle11g/oradata/test, /u01/app/oracle11g/oradata/test'
    FastStartFailoverTarget         = 'testdg'
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'test'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hisdg)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=test_DGMGRL.com)(INSTANCE_NAME=test)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle11g/archivelog'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'
Database Status:
SUCCESS

--查看属性等于monitor的属性.

DGMGRL> show database verbose test InconsistentProperties
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE

SYS@test> alter system set standby_file_management=manual scope=memory ;
System altered.

DGMGRL> show database verbose test InconsistentProperties
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
test StandbyFileManagement MANUAL auto auto

--可以发现不一致的参数.

DGMGRL> show database verbose test InconsistentLogXptProps
INCONSISTENT LOG TRANSPORT PROPERTIES
INSTANCE_NAME STANDBY_NAME PROPERTY_NAME MEMORY_VALUE BROKER_VALUE

DGMGRL> show database verbose test SendQEntries
PRIMARY_SEND_QUEUE
STANDBY_NAME STATUS RESETLOGS_ID THREAD LOG_SEQ TIME_GENERATED TIME_COMPLETED FIRST_CHANGE# NEXT_CHANGE# SIZE (KBs)
CURRENT 845630271 1 17 04/23/2014 09:53:07 3269797926 3491

DGMGRL> show database verbose test LogXptStatus
LOG TRANSPORT STATUS
PRIMARY_INSTANCE_NAME STANDBY_DATABASE_NAME STATUS
test testdg

DGMGRL> show database verbose test RecvQEntries
Error: ORA-16757: unable to get this property's value

DGMGRL> show database verbose testdg RecvQEntries
STANDBY_RECEIVE_QUEUE
STATUS RESETLOGS_ID THREAD LOG_SEQ TIME_GENERATED TIME_COMPLETED FIRST_CHANGE# NEXT_CHANGE# SIZE (KBs)

DGMGRL> show database verbose test TopWaitEvents
TOP SYSTEM WAIT EVENTS
               Event            Wait Time
   rdbms ipc message              8966802
SQL*Net message from client               880001
      DIAG idle wait               848939
Space Manager: slave idle wait               544626
     jobq slave wait               426084

--显示格式不好.结果于SELECT event, total_waits, time_waited, total_timeouts FROM v$system_event ORDER BY time_waited DESC;相似.

时间： 2024-09-20 23:26:40

[20140422]使用dgmgrl管理dataguard(14)

[20140422]使用dgmgrl管理dataguard(14)的相关文章

[20140422]使用dgmgrl管理dataguard(12)

[20140422]使用dgmgrl管理dataguard(11)

[20140422]使用dgmgrl管理dataguard(13)

[20140420]使用dgmgrl管理dataguard(10)

[20140418]使用dgmgrl管理dataguard(6).txt

[20140420]使用dgmgrl管理dataguard(9).txt

[20151109]使用dgmgrl管理dataguard(15)

[20140416]使用dgmgrl管理dataguard(5).txt

[20140420]使用dgmgrl管理dataguard(8).txt