[20180806]ORA-16606 unable to find property.txt

[20180806]ORA-16606 unable to find property.txt

--//生產系統遇到的問題,修改引數log_archive_dest_state_2=defer,忘記修改回來,做一個記錄.

1.環境:
SYS@xxxxxx> select * from v$version where rownum=1;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

SYS@xxxxxx> alter system set log_archive_dest_state_2=defer scope=memory;
System altered.

DGMGRL> show configuration verbose xinghu
Error: ORA-16606: unable to find property "xinghu"

DGMGRL> show configuration verbose xinghu
Error: ORA-16606: unable to find property "xinghu"

DGMGRL> show configuration verbose

Configuration - xinghu

  Protection Mode: MaxPerformance
  Databases:
    xxxxxx   - Primary database
      Error: ORA-16764: redo transport service to a standby database is not running

    xxxxxxdg - Physical standby database

  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'

Fast-Start Failover: DISABLED

Configuration Status:
ERROR

--//實際上我不輸入配置名,就顯示了正確錯誤.自己有點畫蛇添足了.^_^.
DGMGRL> help SHOW CONFIGURATION
Displays information about a configuration, database, or instance
Syntax:
  SHOW CONFIGURATION [VERBOSE];
  SHOW DATABASE [VERBOSE] <database name> [<property name>];
  SHOW INSTANCE [VERBOSE] <instance name> [<property name>]
    [ON DATABASE <database name>];
  SHOW FAST_START FAILOVER;

--//SHOW CONFIGURATION僅僅支援VERBOSE,根本無需要輸入Configuration name.

3.修正錯誤,看看:
SYS@xxxxxx> alter system set log_archive_dest_state_2=enable scope=memory;
System altered.

DGMGRL> show configuration verbose
Configuration - xinghu
  Protection Mode: MaxPerformance
  Databases:
    xxxxxx   - Primary database
    xxxxxxdg - Physical standby database
  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

DGMGRL> show configuration verbose xinghu
Error: ORA-16606: unable to find property "xinghu"

--//再次強調做維護還是有頭有尾,還是認真細心很重要,注意檢查一些細節.實際上不應該執行
--//alter system set log_archive_dest_state_2=defer scope=memory;這個命令.
--//使用dg broker,應該最佳方式在DGMGRL下修改引數.

DGMGRL> edit database xxxxxx set state="TRANSPORT-OFF";

--//參考:http://blog.itpub.net/267265/viewspace-1825886/=>[20151109]使用dgmgrl管理dataguard(15).txt
--//注意:實際上檢視alert可以發現執行的是,並不能馬上阻止日誌傳輸,實際上要等切換時才停止傳輸!!
ALTER SYSTEM SET log_archive_dest_state_2='RESET' SCOPE=BOTH;