Show TOC

Procedure documentationShutting Down the Database with BR*Tools Locate this document in the navigation structure

 

You can use BR*Tools for Oracle to shut down the database.

Note Note

This section describes how you shut down the database.

Shutting down the database is part of Instance Management with BR*Tools.

For more information on the approach to database instance management, see Instance Management.

End of the note.

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   Instance Management   Shut down database  .

        BRGUI or BRTOOLS displays the menu BRSPACE options for database instance shutdown, 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 dbshut -i|-instance

        Confirmation mode (confirm)

        -c|-confirm

        Message language (language)

        -l|-language

        BRSPACE command line (command)

        This shows you the BRSPACE -f dbstart 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

      You need to enter at least the following command:

      brspace -f dbshut

      You can enter more parameters, including the instance name, if required. For more information, see BRSPACE -f dbshut.

      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.

      RAC only: to stop all database instances that are currently up and running, enter all_up in Database instance (instance) or -i all_up on the command line.

      End of the note.

    BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes a detail log.

  2. If you have already entered the instance name, continue with step 5 (quick mode).

    Otherwise, BRSPACE displays the Database instance shutdown main menu.

  3. Choose Shut down database, the default selection.

    RAC only: BRSPACE displays the List of database instances for shutdown.

    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

  4. RAC only: select a database instance or multiple 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.

    BRSPACE displays the menu Options for shutting down database instance.

    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.

  5. Set the required options:

    Menu Entry

    Meaning

    Database close mode (mode)

    -f dbshut -m|-mode

    Force instant shutdown (force)

    -f dbshut -f|-force

    SQLPLUS command (command)

    The SQL command that is to be executed using the current settings. For more information, see your Oracle SQL documentation.

  6. To start processing with the selected options, choose Continue.

Result

Check the results in the BRSPACE logs.

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

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

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