|Oracle® Database Backup and Recovery Reference
11g Release 2 (11.2)
Part Number E10643-03
connectStringSpec subclause to specify the user name, 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
RMAN connections to a database are specified and authenticated in the same way as SQL*Plus connections to a database. The only difference is that RMAN connections to a target or auxiliary database require the
SYSDBA privilege. The
AS SYSDBA keywords are implied and cannot be explicitly specified. See Oracle Database Administrator's Guide to learn about database connection options when using SQL*Plus.
Caution:Good security practice requires that passwords should not be entered in plain text on the command line. You should enter passwords in RMAN only when requested by an RMAN prompt. See Oracle Database Security Guide to learn about password protection.
||If you do not specify a user ID or password when connecting to a target database, then a forward slash establishes a connection as user
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, then RMAN obtains the password interactively by displaying a prompt (see Example 4-11). The characters will not be echoed to the terminal.
Note: The connect string must not contain any white space, but it can contain punctuation characters such as a forward slash (
||Establishes a connection for the specified user by using a password. If the target database is not open, then a password file must exist.
Caution: Passwords entered in plain text on the command line are a security vulnerability. More secure alternatives, such as entering passwords in response to a prompt, are available.
||Establishes a connection to the database through an optional Oracle Net net service name (see Example 4-10).|
Example 4-10 Connecting to a Target Database Without a Recovery Catalog
This example starts RMAN without specifying a database connection. The
CONNECT command connects to a target database by using the Oracle Net service name
prod in the default
NOCATALOG mode. The
SYS password is entered in response to a prompt.
% rman RMAN> CONNECT TARGET SYS@prod target database Password: password connected to target database: PROD (DBID=39525561)
Example 4-11 Connecting to a Target Database at the Operating System Command Line
This example connects to the target database as user
SYS at the operating system command line, but without specifying a password. RMAN prompts for the password.
% rman TARGET SYS Recovery Manager: Release 184.108.40.206.0 - Production on Wed Jul 11 17:51:30 2007 Copyright (c) 1982, 2007, Oracle. All rights reserved. target database Password: password
Example 4-12 Connecting to a Target Database with Operating System Authentication
This example starts RMAN and then connects to the target database
prod using operating system authentication. The example also connects to the recovery catalog database
catdb using a net service name.
% rman RMAN> CONNECT TARGET / connected to target database: PROD (DBID=39525561) RMAN> CONNECT CATALOG rman@catdb recovery catalog database Password: password connected to recovery catalog database