Show TOC

Managing Online Redo LogsLocate this document in the navigation structure

Context

You can use BR*Tools for Oracle to manage online redo log files as follows:

  • Create redolog group

  • Create redolog member

  • Drop redolog group

  • Drop redolog member

  • Resize redolog files

  • Rename to standard name

  • Move redolog files

  • Switch redolog files

  • Show redolog files

Note

This section describes how you manage online redo log files.

Managing online redo logs 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 Manage online redologs End of the navigation path.

        BRGUI or BRTOOLS displays the menu BRSPACE options for manage online redologs, 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

        Manage redolog action (action)

        -f moredo -a|-action

        Redolog thread number (thread)

        -f moredo -t|-thread

        Redolog group number (group)

        -f moredo -g|-group

        Redolog member number (member)

        -f moredo -m|-member

        Redolog file names (file)

        -f moredo -f|-file

        Confirmation mode (confirm)

        -c|-confirm

        Extended output (output)

        -o|-output

        Message language (language)

        -l|-language

        BRSPACE command line (command)

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

      You can enter more options, including the online redo log file name, group, member, and action, if required. For more information, see BRSPACE -f dbparam.

      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 redo log file name, group, sequence, or member. 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 redo log file name, group, member, and action, continue with step 6.

    BRSPACE displays the Manage online redolog main menu.

  3. Choose or confirm the required action:

    • Create redolog group

    • Create redolog member

    • Drop redolog group

    • Drop redolog member

    • Resize redolog files

    • Rename to standard name

    • Move redolog files

    • Switch redolog files

    • Show redolog files

  4. If you have already entered the redo log name, group, or member, continue with step 6 (quick mode).

    BRSPACE displays the online redo log list:

    List Entry

    Meaning

    Pos.

    List sequence number

    Status

    Status of redo log

    Thd.

    Thread of redo log

    Grp

    Group of redo log

    Mmb

    Member of redo log

    Sequence

    Sequence number of redo log

    Size[KB]

    Size in KB of redo log

    Type

    Type of redo log

    File

    File name of redo log

  5. Select an online redo log.

    BRSPACE displays the menu Options for managing online redolog.

  6. Set the required options:

    Menu Entry

    Meaning

    Current number of redolog groups (curr_groups)

    - display only

    Current number of redo log groups

    Lowest/highest/current group number (lhc_group)

    - display only

    Lowest/highest/current group number

    Current number of redolog members (curr_members)

    - display only

    Current number of redo log members

    Lowest/highest member number (lh_member)

    - display only

    Lowest/highest member number

    Current redolog file size / sequence (size_seq)

    - display only

    Current redo log file size / sequence number

    Manage redolog action (action)

    - display only

    Manage redo log action

    Redolog thread number (thread)

    Redo log thread number

    Redolog group number (group)

    Redo log group number

    Redolog member number (member)

    Redo log member number

    New redolog file size in MB (size)

    New redo log file size in MB

    Redolog directory (directory)

    Redo log directory

    SQL command (command)

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

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

Results

Check the results in the BRSPACE Logs.

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

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

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