You can use BR*Tools for Oracle to show information about the database instance status.
Some steps in this procedure only apply if your database is an Oracle Real Application Cluster (RAC). These are marked “RAC only.”
...
1. Start the procedure using BRGUI or BRTOOLS, or from the command line:
¡ BRGUI or BRTOOLS:
i. Choose Instance Management → 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.
ii. Set the required options:
Menu Entry |
Equivalent BRSPACE Command Option |
BRSPACE profile (profile) |
|
Database user/password (user) |
|
Database instance (instance) |
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) |
|
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. |
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 dbstate
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 instance information → Show instance status.
2. RAC only: if you have already entered the name of the database instance, continue with step 4.
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 |
3. RAC only: to see more information, select one or more database instances.
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 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 |
Number of SAP connections (sapcon) |
Number of SAP connections |
4. RAC only: if you specified multiple instances, choose Continue to scroll through.
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.