Skip Headers

Oracle® Database Recovery Manager Reference
10g Release 1 (10.1)

Part Number B10770-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to current chapter
Go to next page
View PDF




Text description of connectStringSpec.gif follows

Text description of connectStringSpec


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

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.


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 (@).


Establishes a connection for the specified user by using a password. If the target database is not open, then a password file must exist.


Establishes a connection to the database through an optional Oracle Net net service name.


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:


Recovery Manager: Release - Production

Copyright (c) 1995, 2003, Oracle.  All rights reserved.

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