ADRCI参数

adrci> help

 HELP [topic]
   Available Topics:
        CREATE REPORT
        ECHO
        EXIT
        HELP
        HOST
        IPS
        PURGE
        RUN
        SET BASE
        SET BROWSER
        SET CONTROL
        SET ECHO
        SET EDITOR
        SET HOMES | HOME | HOMEPATH
        SET TERMOUT
        SHOW ALERT
        SHOW BASE
        SHOW CONTROL
        SHOW HM_RUN
        SHOW HOMES | HOME | HOMEPATH
        SHOW INCDIR
        SHOW INCIDENT
        SHOW PROBLEM
        SHOW REPORT
        SHOW TRACEFILE
        SPOOL

 There are other commands intended to be used directly by Oracle, type
 "HELP EXTENDED" to see the list

adrci> help exit

  Usage: EXIT | QUIT

  Purpose: Exit the current ADRCI session.   --退出当前ADRCI会话

  Examples: 
    exit
    quit

adrci> help host

  Usage:  HOST ["host_command_string"]

  Purpose:  Execute operating system commands without leaving ADRCI.
            不退出ADRCI执行操作系统命令。
            Use HOST by itself to enter an operating system shell, which will allow user to enter multiple operating system commands.
            使用 HOST 自行输入一个操作系统shell，允许用户输入多个操作系统命令。
  Options:
    ["host_command_string"]: The host commands' string.操作系统命令字符串

  Notes:  The operating system commands have no impact on the current ADRCI session.操作系统命令不会影响当前ADRCI会话
      For example change path "cd" will not alter the current working directory of ADRCI.例如改变路径"cd"不会改变当前ADRCI工作目录。

  Examples: 
    host
    host "pwd"

adrci> help ips

 HELP IPS [topic]
   Available Topics:
        ADD
        ADD FILE
        ADD NEW INCIDENTS
        CHECK REMOTE KEYS
        COPY IN FILE
        COPY OUT FILE
        CREATE PACKAGE
        DELETE PACKAGE
        FINALIZE PACKAGE
        GENERATE PACKAGE
        GET MANIFEST
        GET METADATA
        GET REMOTE KEYS
        PACK
        REMOVE
        REMOVE FILE
        SET CONFIGURATION
        SHOW CONFIGURATION
        SHOW FILES
        SHOW INCIDENTS
        SHOW PACKAGE
        UNPACK FILE
        UNPACK PACKAGE
        USE REMOTE KEYS

adrci> help PURGE

  Usage: PURGE [[-i <id1> | <id1> <id2>] |
               [-age <mins> [-type ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP]]]:

  Purpose: Purge the diagnostic data in the current ADR home. 清除当前ADR home下的诊断数据
       If no option is specified, the default purging policy will be used.如果没有指定选项，将使用默认清除策略。

  Options:
    [-i id1 | id1 id2]: Users can input a single incident ID, or a range of incidents to purge.用户可以输入一个事件ID或清除一系列事件。

    [-age <mins>]: Users can specify the purging policy either to all the diagnostic data or the specified type.用户可以指定清除策略或指定类型清除所有诊断数据
            The data older than <mins> ago will be purged在<mins>以前的数据将被清除

    [-type ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP]: Users can specify what type of data to be purged.用户可以指定清除什么类型的数据

  Examples: 
    purge
    purge -i 123 456
    purge -age 60 -type incident

adrci> help RUN

  Usage:  <RUN | @ | @@> <script_name>

  Purpose: Run the specified ADRCI scripts.运行指定的ADRCI脚本
    RUN: Run the ADRCI commands in the specified script file.指定的脚本文件运行ADRCI命令
    @:   Synonym for RUN.  RUN的同义词
    @@:  Similar to @, except when used within a script, the path of the calling script is used to locate the called script.
    类似于@，在脚本中使用时除外，调用脚本的路径用于定位被调用的脚本
  Arguments:
    <script_file>: The file containing the ADRCI commands to execute.该文件包含执行的ADRCI命令
                   If the file name is specified without a file extension,the default extension ".adi"is used.如果指定了文件名没有文件扩展名,使用默认的扩展名 ".adi"。

  Examples: 
    run my_script
    @my_script

adrci> help SET BASE

  Usage:  SET BASE < base_str | -product <product_name> >

  Purpose: Set the ADR base to use in the current ADRCI session.在当前ADRCI会话中设置 ADR base。
           If there are valid ADR homes under the base, all homes will will be added to the current ADRCI session.
           如果在base下有有效地ADR homes，则所有的homes将被添加到当前的ADRCI会话中。

  Arguments:
    <base_str>: It is the ADR base directory, which is a system-dependent directory path string.这是ADR base目录，这是一个与系统相关的目录路径字符串
    -product <product_name>: This option allows users to set the given product's ADR Base location. 这个选项允许用户设置给定的产品的ADR Base位置。
                 The current registered products are "CLIENT" and "ADRCI".当前注册的产品是"CLIENT" and "ADRCI".

  Notes:
    On platforms that use "." to signify current working directory,it can be used as base_str.
  在平台使用"."表示当前工作目录，它可以被用作base_str。
  Example: 
    set base /net/sttttd1/scratch/someone/view_storage/someone_v1/log
    set base -product client
    set base .

adrci> help SET BROWSER

  Usage: SET BROWSER <browser_program>

  Purpose: Set the default browser for displaying reports.设置默认浏览器显示报告。

  Arguments:
    <browser_program>: The browser program name.浏览器程序名。

  Examples: 
    set browser mozilla

adrci> help SET CONTROL

  Usage: SET CONTROL (<purge_policy>=<value>, ...)

  Purpose: Set the purging policy.设置清除策略

  Arguments:
    <purge_policy>: The purging policy name.清除策略名称。
            The current valid values are "SHORTP_POLICY" and "LONGP_POLICY".当前的有效值是"SHORTP_POLICY" and "LONGP_POLICY"

    <value>: The purging time value in hours.按照时间小时清除

  Examples: 
    set control (SHORTP_POLICY = 1440)

adrci> help SET ECHO    

  Usage: SET ECHO <ON | OFF>

  Purpose: Turn the output of commands on or off. 打开或关闭输出命令
       The commands will only be output if ADRCI is currently executing a script or spooling.如果ADRCI目前正在执行一个脚本或假脱机，该命令将只输出。

  Examples: 
    set echo on
    set echo off 

adrci> help SET EDITOR

  Usage: SET EDITOR <editor_program>

  Purpose: Set the default editor for displaying trace and alert contents.设置默认编辑器来显示trace和alert的内容。

  Arguments:
    <editor_program>: The editor program name.

  Examples: 
    set editor xemacs

adrci> help SET HOMES

  Usage:  SET HOMES | HOME| HOMEPATH <homepath_str1 homepath_str2 ...>

  Purpose: Set the ADR homes to query in the current ADRCI session.在当前ADRCI会话中设置ADR homes。

  Arguments:
    <homepath_str1 homepath_str2 ...>: The paths of the home,relative to the ADR base.  home的路径，相当于ADR base

  Note:
    The "diag" directory name can be omitted from the homepath_str. "diag"目录名称可以忽略homepath_str。
    If the specified path contains multiple homes, for instance, it is set to the database ID which is running RAC.
    如果指定的路径包含多个homes，例如，设置运行的RAC的数据库ID。
    All of the ADR homes corresponding to the instances of the database will be added to the current ADRCI home settings.
  所有的ADR homes对应数据库的实例将被添加到当前数据库ADRCI home中。
  Example: 
    set homepath diag/rdbms/aime3/aime3 diag/rdbms/aime3/aime32
    set homepath rdbms/aime3

adrci> help SET TERMOUT

  Usage: SET TERMOUT <ON | OFF>

  Purpose: Turn output to the terminal on or off. 打开或关闭终端输出
       This setting is independent of spooling.这个设置是独立于假脱机的
       That is, the output can be directed to both terminal and a file at the same time.
      也就是说，在同一时间内输出既可以指向终端也可以指向一个文件。
  Examples: 
    set termout on
    set termout off 

adrci> help SHOW ALERT

  Usage: SHOW ALERT [-p <predicate_string>]  [-term]
                    [ [-tail [num] [-f]] | [-file <alert_file_name>] ]
  Purpose: Show alert messages.显示警告信息

  Options:
    [-p <predicate_string>]: The predicate string must be double-quoted.  predicate string一定在双引号中
    The fields in the predicate are the fields:
        ORIGINATING_TIMESTAMP         timestamp
        NORMALIZED_TIMESTAMP          timestamp
        ORGANIZATION_ID               text(65)
        COMPONENT_ID                  text(65)
        HOST_ID                       text(65)
        HOST_ADDRESS                  text(17)
        MESSAGE_TYPE                  number
        MESSAGE_LEVEL                 number
        MESSAGE_ID                    text(65)
        MESSAGE_GROUP                 text(65)
        CLIENT_ID                     text(65)
        MODULE_ID                     text(65)
        PROCESS_ID                    text(33)
        THREAD_ID                     text(65)
        USER_ID                       text(65)
        INSTANCE_ID                   text(65)
        DETAILED_LOCATION             text(161)
        UPSTREAM_COMP_ID              text(101)
        DOWNSTREAM_COMP_ID            text(101)
        EXECUTION_CONTEXT_ID          text(101)
        EXECUTION_CONTEXT_SEQUENCE    number
        ERROR_INSTANCE_ID             number
        ERROR_INSTANCE_SEQUENCE       number
        MESSAGE_TEXT                  text(2049)
        MESSAGE_ARGUMENTS             text(129)
        SUPPLEMENTAL_ATTRIBUTES       text(129)
        SUPPLEMENTAL_DETAILS          text(129)
        PROBLEM_KEY                   text(65)

    [-tail [num] [-f]]: Output last part of the alert messages and output latest messages as the alert log grows.
              随着alert日志的输出，输出最后一部分alert消息和最新消息
              If num is not specified,the last 10 messages are displayed. 如果没有指定num，按照最后10行显示信息。
              If "-f" is specified, new data will append at the end as new alert messages are generated.
            如果指定"-f"，新的数据将追加到新生成的alert消息中。
    [-term]: Direct results to terminal. 在终端显示直接的结果
         If this option is not specified,the results will be open in an editor.如果没有指定这个选项，结果将在编辑器中打开
         By default, it will open in emacs, but "set editor" can be used to set other editors.
      在默认情况下,它将打开编辑器，但是"set editor"可以设置其他编辑器。
    [-file <alert_file_name>]: Allow users to specify an alert file which may not be in ADR. 允许用户指定一个alert文件，这个文件可能不在ADR中。
                 <alert_file_name> must be specified with full path.必须指定完整路径
                  Note that this option cannot be used with the -tail option  注意,这个选项不能使用 -tail。

  Examples: 
    show alert
    show alert -p "message_text like '%incident%'"
    show alert -tail 20

adrci> help SHOW BASE

  Usage: SHOW BASE [-product <product_name>]

  Purpose: Show the current ADR base setting.显示当前的ADR base

  Options:
    [-product <product_name>]: This option allows users to show the given product's ADR Base location. 这个选项允许用户显示给定的产品的ADR Base位置。
                  The current registered products are "CLIENT" and "ADRCI".当前注册的产品"CLIENT" and "ADRCI"

  Examples: 
    show base -product client
    show base

adrci> help SHOW CONTROL

  Usage: SHOW CONTROL

  Purpose: Show the purging policy of the current ADR.显示当前ADR的清除策略

  Examples: 
    show control

adrci> help SHOW HM_RUN

  Usage: SHOW HM_RUN [-p <predicate_string>]

  Purpose: show HM run information.显示HM运行信息

  Options:
    [-p <predicate_string>]: The predicate string must be double-quoted. predicate string一定要在双引号中。
                 The field names that users can specify in the predicate are the fields defined in the hm_run relation.
                 这个字段名称，在hm_run中用户可以指定predicate的字段定义
                 Use command "describe hm_run" to find all the field definitions of the hm_run relation.
                 使用命令"describe hm_run"找到hm_run的所有字段定义
    The fields can appear in the predicate are:
           RUN_ID                        number
           RUN_NAME                      text(31)
           CHECK_NAME                    text(31)
           NAME_ID                       number
           MODE                          number
           START_TIME                    timestamp
           RESUME_TIME                   timestamp
           END_TIME                      timestamp
           MODIFIED_TIME                 timestamp
           TIMEOUT                       number
           FLAGS                         number
           STATUS                        number
           SRC_INCIDENT_ID               number
           NUM_INCIDENTS                 number
           ERR_NUMBER                    number
           REPORT_FILE                   bfile

  Examples: 
    show hm_run
    show hm_run -p "run_id=123"

adrci> help SHOW HOMES

  Usage: SHOW HOMES | HOME | HOMEPATH
          [-ALL | -base <base_str> | homepath_str1 ... ]

  Purpose: Show the ADR homes in the current ADRCI session.在当前ADRCI会话中显示 ADR homes

  Options:
    [-ALL]: If it is specified, the ADR homes under the current base setting will be displayed.
        如果是指定的，ADR homes在当前base设置中将显示出来
    [-base <base_str>]: It is for showing all the homes under <base_str>,where <base_str> is a system-dependent directory path string.
              这是在<base_str>下显示所有homes，<base_str>是一个于系统相关的目录路径字符串
    <homepath_str1 ...>: The paths of the home, relative to the ADR base.   home的的路径，相对于ADR base

  Examples: 
    show homes -all
    show homes -base /temp
    show homes rdbms
    show homes

adrci> help SHOW INCDIR

  Usage: SHOW INCDIR [id1 | id1 id2]:

  Purpose: List the trace files created for the specified incidents.列出 trace files创建指定的事件

  Options:
    [id1 | id1 id2]: Users can input a single incident ID, or a range of incidents.用户可以输入一个事件ID，或一系列事件
             If nothing is specified, all incident files will be listed.如果没有指定，将会显示所有事件的文件

  Examples: 
    show incdir
    show incdir 1 100

adrci> help SHOW INCIDENT

  Usage: SHOW INCIDENT [-p <predicate_string>]
                       [-mode BASIC|BRIEF|DETAIL]
                       [-last <num> | -all]
                       [-orderby (field1, field2, ...) [ASC|DSC]]

  Purpose: Show the incident information. By default, this command will only show the last 50 incidents which are not flood controlled.
     显示事件信息。在默认情况下,这个命令将只显示最后50事件。
  Options:
    [-p <predicate_string>]: The predicate string must be double-quoted.  predicate string必须在双引号中。

    [-mode BASIC|BRIEF|DETAIL]: The different modes of showing incidents. 在不同模式下显示事件
    BASIC will show the basic information of non-flooded controlled incidents, which is the default mode. BASIC将显示的基本信息在non-flooded控制事件中，这是默认模式
    In this mode, only the following fields can be used in the predicate clause: 在这种模式下,只有以下字段可用于predicate
        INCIDENT_ID                   number
        PROBLEM_KEY                   text(550)
        CREATE_TIME                   timestamp
    BRIEF will display incident information from the incident relation.
    In this mode, the fields can appear in the predicate are:
        INCIDENT_ID                   number
        PROBLEM_ID                    number
        CREATE_TIME                   timestamp
        CLOSE_TIME                    timestamp
        STATUS                        number
        FLAGS                         number
        FLOOD_CONTROLLED              number
        ERROR_FACILITY                text(10)
        ERROR_NUMBER                  number
        ERROR_ARG1                    text(64)
        ERROR_ARG2                    text(64)
        ERROR_ARG3                    text(64)
        ERROR_ARG4                    text(64)
        ERROR_ARG5                    text(64)
        ERROR_ARG6                    text(64)
        ERROR_ARG7                    text(64)
        ERROR_ARG8                    text(64)
        SIGNALLING_COMPONENT          text(64)
        SIGNALLING_SUBCOMPONENT       text(64)
        SUSPECT_COMPONENT             text(64)
        SUSPECT_SUBCOMPONENT          text(64)
        ECID                          text(64)
        IMPACT                        number

    DETAIL will display all incident-related information, such as incident files. DETAIL将显示所有incident-related信息，如事件文件
    The fields can appear in the predicate is the same as the ones in the brief mode.  字段可以出现在predicate相同的简单模式

    [-last <num> | -all]: This option allows users to either select the last <num> of qualified incidents to show or to show all the qualified incidents.
                          这个选项允许用户查询最后一个<num>显示合格的事件或显示所有合格的事件。
    If this option is not specified, this command will only show 50 incidents.如果没有指定这个选项,这个命令将只显示50个事件。

    [-orderby (field1, field2, ...) [ASC|DSC]]: If specified, the results will be ordered by the specified fields' values. 如果指定,结果将由指定的命令fields'
                          By default, it will be in the ascending order unless "DSC" is specified. 默认情况下,这将是升序,除非指定"DSC"
                          Note that the field names that can be specified here are from the "INCIDENT" relation.注意,字段名称,可以在这里指定"INCIDENT"关系

  Examples: 
    show incident
    show incident -mode detail
    show incident -mode detail -p "incident_id=123"

adrci> help SHOW REPORT

  Usage:  SHOW REPORT <report_type> <report_id>

  Purpose: Show a report for the specified report type and ID. 显示指定的报告的报告类型和ID
           Currently we only support report type of hm_run.目前我们只支持报告的hm_run类型

  Arguments:
    <report_type>: The type of the requested report.要求报告的类型。
    <report_id>  : The requested report ID.  报告ID

  Notes:
    If currently there is no browser set, the report contents will be displayed through ADRCI channels (terminal or spool file).
    如果目前没有浏览器设置，报告的内容将会显示通过ADRCI渠道(终端或spool文件)
    To get the report displayed through some browser, use command " set browser".通过一些浏览器显示的报告，使用“设置浏览器”命令
    For example: 
         "set browser mozilla"

  Example: 
    show report hm_run <hm_run_name>

adrci> help SHOW TRACEFILE

  Usage: SHOW TRACEFILE [file1 file2 ...] [-rt | -t]
                        [-i inc1 inc2 ...] [-path path1 path2 ...]

  Purpose: List the qualified trace filenames.合格的跟踪文件名列表
  Options:
    [file1 file2 ...]: The trace files users are interested in to search.
    If "-i" or/and "-path" is specified, the trace files are assumed
    to be under the specified incidents or paths. Otherwise, the files
    will be searched among the trace directory and all incident directories
    of the current ADR homes. Filenames allow SQL like condition syntax.
    I.e., allowing wildcard search on filenames by using "%". For example,
    "%mmon%" means all trace files with the "mmon" substring.

    [-rt | -t]: Order the trace filenames. "-t" means in the modified
    timestamps order; "-rt" means in the reversed modified timestamps
    order. Note that the ordering is only apply to a single directory.
    [-i inc1 inc2 ...]: The trace files produced for the listed incidents.
    If no files are listed, all trace files produced for the list
    incidents are considered.

    [-path path1 path2 ...]: The trace files under the given paths will be
    queried. If no files are listed, all trace files under these paths
    are considered.

  Examples: 
    1. Show all the trace files under the current home  显示所有跟踪文件在当前home
       "show tracefile"
    2. Show all the mmon trace files in time reverse order  显示所有时间倒序mmon跟踪文件
       "show tracefile %mmon% -rt"
    3. Show all trace files under incidents 123 456, and /home/someone/temp  显示所有跟踪文件事件123 456, and /home/someone/temp
       "show tracefile -i 123 456 -path  /home/someone/temp"

adrci> help SPOOL

  Usage: SPOOL [<filename> [APPEND] | OFF]

  Purpose:
    SPOOL <filename>: Direct the results to the file <filename>. If filename
                      does not have extension, the file will be ended with
                      the ".ado" extension.
    SPOOL OFF: Turn off the spooling.
    SPOOL: Check the current spooling status.

  Arguments:
    <filename>: The filename where the results will be output to.

  Options:
    [APPEND]: If the filename already exists, the following output will
    be appended to the file. Without this option, the existing file
    contents will be truncated.

  Examples: 
    spool myfile
    spool myfile.ado append
    spool off
    spool