Show TOC

Altering the Database Instance with BR*ToolsLocate this document in the navigation structure

Prerequisites

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

Context

You can use BR*Tools for Oracle to alter the database instance as follows:

  • Switch the redo log file

  • Force a database checkpoint

  • Set archivelog mode

  • Set noarchivelog mode

    Note

    This section describes how you alter the database instance.

    Altering the database instance is part of Instance Management with BR*Tools.

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

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  Alter database End of the navigation path

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

        Alter database action (action)

        -f dbalter -a|-action

        Database instance (instance)

        -f dbalter -i|-instance

        Confirmation mode (confirm)

        -c|-confirm

        Message language (language)

        -l|-language

        BRSPACE command line (command)

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

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

      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.

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

  2. You can use quick mode as follows:

    • If you have already entered the action, continue with step 4.

    • If you have already entered the instance name and action, continue with step 5.

    BRSPACE displays the Alter database instance main menu.

  3. Choose or confirm the required action:

    • Switch redo log file

    • Force database checkpoint

    • Set archivelog mode

    • Set noarchivelog mode

    If you already chose an action in step 1, this action is set to the default.

    RAC only: BRSPACE displays the List of database instances for alter, unless you have already entered the instance name.

    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.

    Note

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

    BRSPACE displays the menu Options for alter of database instance.

  5. Set the required options:

    Menu Entry

    Meaning

    Current archivelog mode (mode)

    - display only

    -f dbalter -m|-mode

    Alter database action (action)

    - display only

    -f dbalter -a|-action

    Force instance shutdown (force)

    -f dbalter -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.

Results

Check the results in the BRSPACE logs BRSPACE Logs.

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