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 shut down the database.
This section describes how you shut down the database.
Shutting down the database 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 database instance shutdown, 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) |
|
Confirmation mode (confirm) |
|
Message language (language) |
|
BRSPACE command line (command) |
This shows you the BRSPACE -f dbshut 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
You need to enter at least the following command:
brspace -f dbshut
You can enter more parameters, including the instance name, if required. For more information, see BRSPACE -f dbshut.
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.
RAC only: to stop all database instances that are currently up and running, enter all_inst in Database instance (instance) or -i all_inst on the command line.
BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes a detail log.
If you have already entered the instance name, continue with step 5 (quick mode).
Otherwise, BRSPACE displays the Database instance shutdown main menu.
Choose Shut down database, the default selection.
RAC only: BRSPACE displays the List of database instances for shutdown.
List Entry |
Meaning |
---|---|
Pos. |
List sequence number |
Name |
Instance name |
Number of 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 |
RAC only: select a database instance or multiple 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.
In normal (that is, non-RAC systems), BRSPACE automatically selects the name of the single instance for you.
BRSPACE displays the menu Options for shutting down database instance.
Set the required options:
Menu Entry |
Meaning |
---|---|
Database close mode (mode) |
|
Force instant shutdown (force) |
|
SQLPLUS 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>.dbs displays the details.
The structure change log struc<DBSID>.log logs all structure changes.
For more information on how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.