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
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.
Start the procedure using BRGUI or BRTOOLS, or from the command line:
BRGUI or BRTOOLS:
Choose
.BRGUI or BRTOOLS displays the menu BRSPACE options for manage online redologs, where you specify the options with which you call BRSPACE.
Set the required options:
Menu Entry |
Equivalent BRSPACE Command Option |
---|---|
BRSPACE profile (profile) |
|
Database user/password (user) |
|
Manage redolog action (action) |
|
Redolog thread number (thread) |
|
Redolog group number (group) |
|
Redolog member number (member) |
|
Redolog file names (file) |
|
Confirmation mode (confirm) |
|
Extended output (output) |
|
Message language (language) |
|
BRSPACE command line (command) |
This shows you the BRSPACE -f moredo 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 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.
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.
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.
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
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 |
Select an online redo log.
BRSPACE displays the menu Options for managing online redolog.
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. |
To start processing with the selected options, choose Continue.
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.