Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Part Number B14194-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

connectStringSpec

Syntax

connectStringSpec::=

Description of connectstringspec.gif follows
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

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 to a Target Database 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

Connecting to a Target Database and Entering the Password Interactively: Example This example connects to the target database as user SYS but without specifying a password at the command line. Note that you are prompted for a password.

% rman TARGET SYS

Recovery Manager: Release 10.1.0.2.0 - 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 TARGET /
RMAN> CONNECT CATALOG rman/rman@inst1

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