Some steps in this procedure only apply if your database is an Oracle Real Application Cluster (RAC). These are marked “RAC only”.
You can use BR*Tools for Oracle to show information about the database instance status.
BRGUI or BRTOOLS:
Choose Instance Management Additional instance functions Show instance status .
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) |
|
Database user/password (user) |
|
Database instance (instance) |
|
Create log file (log) |
|
Confirmation mode (confirm) |
|
Scrolling line count (scroll) |
|
Message language (language) |
|
BRSPACE command line (command) |
This shows you the BRSPACE -f dbshow -c dbstate 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 dbstate
You can enter more parameters if required. For more information, see BRSPACE -f dbshow.
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 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 instance information Show instance status .
RAC only: BRSPACE displays the List of database instances:
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 |
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.
In normal (that is, non-RAC) systems, BRSPACE automatically selects the name of the single instance for you.
BRSPACE displays Information about the status of database instance:
List Entry |
Meaning |
---|---|
Instance number (number) |
Instance number |
Instance thread (thread) |
Instance thread number |
Instance status (status) |
Instance status |
Instance start time (start) |
Time the instance was started |
Oracle version (version) |
Oracle database version |
Database creation time (create) |
Date and time of database creation |
Last resetlogs time (resetlogs) |
Date and time that logs were reset |
Archivelog mode (archmode) |
Archivelog mode |
Archiver status (archiver) |
Status of the archiver |
Current redo log sequence (redoseq) |
Current redo log sequence number |
Current redo log SCN (redoscn) |
Current redo log system change number |
Flashback status (flashback) |
Flashback status |
Number of SAP connections (sapcon) |
Number of SAP connections |
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.