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.
You must have SYSDBA
privileges to connect to a target or auxiliary database.
Do not connect to the recovery catalog database as user SYS
.
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 Note: The connect string must not contain any white space, but it can contain punctuation characters such as a forward slash ( |
/ 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. |
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