[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;