Show TOC

Starting BR*ToolsLocate this document in the navigation structure

Use

You can use this procedure to start BR*Tools for Oracle. You can only use BR*Tools to manage a database system that is running on the same host system.

Prerequisites

  • You have configured:

  • Logon user

    You can log on as the operating system user who owns the data files of the database system. The standard Oracle user created during the installation of the SAP system is ora<dbsid> (UNIX) or <DBSID>ADM (Windows).

    You can also use some BR*Tools programs if you are logged on as the SAP System user <sapsid>adm. This requires the authorization for the BR*Tools program to be set accordingly (for example, under UNIX: rwsr_xr_x orac11 dba brbackup).

    The advantage of this procedure is that the administrator who works with BR*Tools does not have the authorizations of user ora<dbsid> (who can delete database files directly, for example, and perform other critical operations for the database).

    BR*Tools establishes the connection to the database with a special database user who has authorization to create and delete tablespaces, to create data files, and so on (DBA privileges). This default user is system.

Procedure

  1. Log on to the host where your database system is running.

    Note

    If you start BR*Tools with a script, as a background job or from the command line, you must not use special characters (such as $ or #) in the user name and password.

  2. If you want BR*Tools to log on as user system to the Oracle database, call it as follows from the command line:

    OS> <brtool> ...

    For example, brbackup -t online ...

    If the default password is not used, you have to use option -u <user>/<password>.

    You can call BR*Tools with the following command options:

    • OS> <brtool> -p [<path>/]<profile name>

      You can also specify an initialization profile that is different to the standard profile.

      If you do not specify option -p, BR*Tools uses the values set in the default profile init<DBSID>.sap, which must be available. For more information, see Configuration of BR*Tools.

    • OS> <brtool> -u <user>/<password>

      Specifies a DBA user different to the default user ( system/<default password>).

      <user name>: Database user that you defined

      <password>: Password of your database user.

      If possible, avoid starting BR*Tools with the command option -u and the immediate entry of user name and password. In this case, the command line with the DBA user and its password can be displayed in the UNIX process list (for example, by using the ps command).

      Enter the password interactively. When you use <brtool> -u <user>, the system prompts you to enter a valid password. In this case, the password does not appear on the screen as it is entered and is not displayed in the process list. The password length is 30 characters.

The following examples illustrate different procedures for using passwords:

Example

OS> <brtool> -u system

BR*Tools prompts you for the password. The password is not visible on the screen.

OS> <brtool> -u

BR*Tools prompts you for the user and password. The password appears on the screen.

OS> <brtool> -u < <file name>

The user and password is written to the file <file name>. Access to this file can be restricted with operating system privileges.

OS> <brtool> -u /...

Call for an OPS$ user (also applies to background processing). To make sure that the password is not visible in the process list, you can create an OPS$ user (see Oracle documentation and information in SAP Service Marketplace) in the database and assign the SAPDBA role to the user.

You can get an overview of all the command options by entering the following command:

OS> <brtool> -h[elp]

For information about other command options that are not mentioned in this section, see the section on command options for the relevant one of the BR*Tools. For example, for BRSPACE command options, see Command Options for BRSPACE.