RMAN Commands , 17 of 59

connectStringSpec

Syntax

Text description of the illustration connectStringSpec.gif

Purpose

A subclause specifying the username, password, and net service name for connecting to a target, recovery catalog, or auxiliary database. The connection is necessary to authenticate the user and identify the database.

Restrictions and Usage Notes

You must have SYSDBA privileges on the target and auxiliary databases.
Do not connect to the recovery catalog database as user SYS.

Keywords and Parameters

Syntax Element	Description
`/`	If you do not specify a user ID or password when connecting to the target database, then a forward slash establishes a connection as user `SYS` by using operating system authentication. For example, enter the following to connect to the target database: % rman TARGET / Note: The forward slash depends on platform-specific environment variables.
`userid`	Establishes a connection to the database for the specified user. If you do not specify a password, RMAN obtains the password interactively by displaying a prompt. The characters will not be echoed to the terminal. You must have `SYSDBA` authority when connecting to the target or auxiliary database, but must not connect as `SYS` to the recovery catalog database. Note: The connect string must not contain any white space, but it can contain punctuation characters such as a forward slash (`/`) and an at sign (`@`).
`/``password`	Establishes a connection for the specified user by using a password. If the target database is not open, then a password file must exist.
`@``net_service_name`	Establishes a connection to the database through an optional Oracle Net net service name.

Examples

Connecting Without a Recovery Catalog: Example

This example connects to the target database by using a password and the Oracle Net service name prod1 in the default NOCATALOG mode:

% rman TARGET SYS/change_on_install@prod1

Entering the Password Interactively: Example

This example connects to the target database as user SYS but without specifying a password at the command line:

% rman TARGET SYS

Recovery Manager: Release 9.0.1.0.0

target database Password:

Connecting with Operating System Authentication: Example

This example starts RMAN and then connects to the target database prod1 by using operating system authentication and the recovery catalog database rcat using a net service name:

% rman
RMAN> CONNECT TARGET /
RMAN> CONNECT CATALOG rman/rman@rcat

Connecting to a Target Database, Recovery Catalog, and Auxiliary Instance: Example

This example connects to three different databases from the command line, specifying a username, password, and net service name for each:

% rman TARGET SYS/pwd1@prod1 CATALOG rman/rman@rcat AUXILIARY SYS/pwd2@dupdb