Starting Up the Database with BR*Tools

Use

You can use BR*Tools for Oracle to start up the database.

This section describes how you start the database.

Starting up the database is part of Instance Management with BR*Tools.

For more information on the approach to database instance management, see Instance Management.

Prerequisites

Some steps in this procedure only apply if your database is an Oracle Real Application Cluster (RAC). These are marked “RAC only.”

Procedure

...

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

Ў        BRGUI or BRTOOLS:

                                                  i.       Choose Instance Management ® Start up database

BRGUI or BRTOOLS displays the menu BRSPACE options for database instance startup, where you specify the options with which you call BRSPACE.

                                                ii.       Set the required options:

Menu Entry

Equivalent BRSPACE

Command Option

BRSPACE profile (profile)

-p|-profile

Database user/password (user)

-u|-user

Database instance (instance)

-f dbstart -i|-instance

Confirmation mode (confirm)

-c|-confirm

Message language (language)

-l|-language

BRSPACE command line (command)

This shows you the BRSPACE -f dbstart that is to be executed using the current settings.

                                               iii.       Choose Continue.

BRGUI or BRTOOLS prompts you to start BRSPACE.

                                               iv.       Choose Continue to start BRSPACE.

Ў        Command line

You need to enter at least the following command:

brspace –f dbstart

You can enter more parameters, including the instance name, if required. For more information, see BRSPACE -f dbstart.

Whichever way you start the procedure – with BRGUI or BRTOOLS, or from the command line – you can take advantage of 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 start all database instances that are currently down, enter all_down in Database instance (instance) or -i all_down 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.

       2.      If you have already entered the instance name, continue with step 5 (quick mode).

Otherwise, BRSPACE displays the Database instance startup main menu.

       3.      Choose Start up database, the default selection.

RAC only: BRSPACE displays the List of database instances for startup.

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

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

BRSPACE displays the menu Options for starting up database instance.

In normal (that is, non-RAC systems), BRSPACE automatically selects the name of the single instance for you.

       5.      Set the required options:

Menu Entry

Meaning

Database startup to-state (state)

-f dbstart -s|-state

Database open mode (mode)

-f dbstart -m|-mode

Force instant restart (force)

-f dbstart -f|-force

SQLPLUS command (command)

The SQL command that is to be executed using the current settings. For more information, see your Oracle SQL documentation.

       6.      To start processing with the selected options, choose Continue.

Results

Check the results in the BRSPACE logs.

·        The summary log space<DBSID>.logdisplays the return code.

·        The detail log s<encoded timestamp>.dbr displays the details.

For more information on how to view the logs with BR*Tools, see Showing Logs and Profiles with BR*Tools.