Skip Headers

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

Part Number B10770-02
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
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

connectStringSpec

Syntax

connectStringSpec::=

Text description of connectStringSpec.gif follows


Text description of connectStringSpec



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