Showing Redo Log Files with BR*Tools

Context

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

Procedure

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

BRGUI or BRTOOLS:

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.

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

Choose Continue

BRGUI or BRTOOLS prompts you to start BRSPACE.
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).

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 space information Next navigation step Show redolog files End of the navigation path .

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
Thd	Redo log thread number
Grp	Redo log group number
Mmb	Redo log member
Sequence	Redo log sequence
Size[KB]	Redo log file size
Device	Disk device ID for the redo log file
Type	Redo log file type: file system, raw device, or ASM file
File	Redo log file name

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

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

List Entry	Meaning
Redolog thread number (thread)	Redo log thread number
Redolog group number (group)	Redo log group number
Redolog group member (member)	Redo log group member
Redolog sequence number (sequence)	Redo log sequence number
Redolog file status (status)	Redo log file status
Redolog file type (type)	Redo log file type: file system, raw device, or ASM file
Disk device Id (device)	Disk device ID for the redo log file
Redolog file size in KB (size)	Redo log file size

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