Procedure documentationShowing Instance Status with BR*Tools

 

You can use BR*Tools for Oracle to show information about the database instance status.

Prerequisites

Some steps in this procedure only apply if your database is an Oracle Real Application Cluster (RAC). These are marked “RAC only”.

Procedure

  1. Start the procedure using BRGUI or BRTOOLS, or from the command line:

    • BRGUI or BRTOOLS:

      1. Choose Start of the navigation path Instance Management Next navigation step Additional instance functions Next navigation step Show instance status End of the navigation path.

        BRGUI or BRTOOLS displays the menu BRSPACE main options for showing database information, where you specify the options with which you call BRSPACE.

      2. Set the required options:

        Menu Entry

        Equivalent BRSPACE Command Option

        BRSPACE profile (profile)

        -p|-profile

        Database user/password (user)

        -u|-user

        Database instance (instance)

        -f dbshow -n|-instance

        Create log file (log)

        -f dbshow -l|-log

        Confirmation mode (confirm)

        -c|-confirm

        Scrolling line count (scroll)

        -s|-scroll

        Message language (language)

        -l|-language

        BRSPACE command line (command)

        This shows you the BRSPACE -f dbshow -c dbstate command that is to be executed using the current settings.

      3. Choose Continue.

        BRGUI or BRTOOLS prompts you to start BRSPACE.

      4. Choose Continue to start BRSPACE.

    • Command line:

      Enter at least the following command:

      brspace -f dbshow -c dbstate

      You can enter more parameters if required. For more information, see BRSPACE -f dbshow.

      Note Note

      Whichever way you start the procedure – with BRGUI or BRTOOLS, or from the command line – you can use quick mode if you know the object name, in this case the instance name. For more information, see How to Use BR*Tools.

      End of the note.

    BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes adetail log if you set the option Create log file (parameter -l|-log).

    Note Note

    If you started BRSPACE from the command line without the information class name (-c|-class) – that is, with brspace -f dbshow – BRSPACE displays the Show database information main menu.

    Choose Start of the navigation path Show database instance information Next navigation step Show instance status End of the navigation path.

    End of the note.

  2. RAC only: if you have already entered the name of the database instance, continue with step 4.

    RAC only: BRSPACE displays the List of database instances:

    List Entry

    Meaning

    Pos.

    List sequence number

    Name

    Instance name

    Number / Thread

    Instance number and thread

    Status

    Instance status

    Start time

    Time the instance was started

    RedoSeq

    Log redo sequence number

    SapConn

    Number of SAP connections

  3. RAC only: to see more information, select one or more database instances.

    Example Example

    These examples apply only to input in character mode.

    To select the first three entries in the list, enter 1-3.

    To select the first and third entries, enter 1,3.

    To select the first three entries and the fifth, enter 1-3,5.

    To select all entries, enter 0.

    End of the example.

    Note Note

    In normal (that is, non-RAC) systems, BRSPACE automatically selects the name of the single instance for you.

    End of the note.

    BRSPACE displays Information about the status of database instance:

    List Entry

    Meaning

    Instance number (number)

    Instance number

    Instance thread (thread)

    Instance thread number

    Instance status (status)

    Instance status

    Instance start time (start)

    Time the instance was started

    Oracle version (version)

    Oracle database version

    Database creation time (create)

    Date and time of database creation

    Last resetlogs time (resetlogs)

    Date and time that logs were reset

    Archivelog mode (archmode)

    Archivelog mode

    Archiver status (archiver)

    Status of the archiver

    Current redo log sequence (redoseq)

    Current redo log sequence number

    Current redo log SCN (redoscn)

    Current redo log system change number

    Flashback status (flashback)

    Flashback status

    Number of SAP connections (sapcon)

    Number of SAP connections

  4. RAC only: if you specified multiple instances, choose Continue to scroll through.

Result

If you set the option Create log file (parameter -l|-log), check the results in the BRSPACE logs.

  • The summary log space<DBSID>.log displays the return code.

  • The detail log s<encoded timestamp>.dbw displays the details.

For more information on how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.