Showing Redo Log Files with BR*Tools

Use

You can use BR*Tools  for Oracle to show information about online redo log files.

Procedure

...

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

Ў        BRGUI or BRTOOLS:

                                                  i.       Choose Space management ® Additional space functions  ® Show redolog files.

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

                                                ii.       Set the required options:

Menu Entry

Equivalent BRSPACE

Command Option

BRSPACE profile (profile)

-p|-profile

Database user/password (user)

-u|-user

Database file (file)

-f dbshow -f|-file

                                               iii.       Choose Continue.

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

Menu Entry

Equivalent BRSPACE

Command Option

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 rfinfo command that is to be executed using the current settings.

                                               iv.       Choose Continue

BRGUI or BRTOOLS prompts you to start BRSPACE.

                                                 v.       Choose Continue to start BRSPACE.

Ў        Command line:

...

Enter at least the following command:

brspace –f dbshow –c rfinfo

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

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

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 Show database space information ® Show redolog files.

       2.      If you have already entered the redo log file name, continue with step 4.

BRSPACE displays the List of database online redolog files:

List Entry

Meaning

Pos.

List sequence number

Status

Redo log file status

Group

Redo log group number

Thrd

Redo log thread number

Size[KB]

Redo log file size

Device

Disk device ID for the redo log file

Type

Redo log file type: raw device or file system

File

Redo log file name

       3.      To see more information, select one or more redo log files.

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 Information about online redolog file:

List Entry

Meaning

Redolog group number (group)

Redo log group number

Redolog thread number (thread)

Redo log thread number

Redolog file status (status)

Redo log file status

Redolog file type (type)

Redo log file type: raw device or file system

Disk device Id (device)

Disk device ID for the redo log file

Redolog file size in KB (size)

Redo log file size

       4.      If you specified multiple redo log files, choose Continue to scroll through.

Results

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

·        The summary log space<DBSID>.logdisplays 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 Logs and Profiles with BR*Tools