RMAN Commands , 16 of 59

CONNECT

Syntax

Text description of the illustration connect.gif

Purpose

To establish a connection between RMAN and a target, auxiliary, or recovery catalog database.

Note:

When connecting from the command line, the password may be visible to other users on the system. The CONNECT command avoids this problem.

See Also:

"cmdLine" for command line connection options

Restrictions and Usage Notes

You can only run the CONNECT TARGET, CONNECT CATALOG, and CONNECT AUXILIARY commands if you are at the RMAN prompt and if you are not already connected to the specified databases.
If you need to connect to a different target, catalog, or auxiliary database, then you should start a new RMAN session.
You cannot run CONNECT CATALOG command when RMAN is in the default NOCATALOG mode, that is, when these conditions are met:
- You started RMAN at the command without specifying either CATALOG or NOCATALOG.
- You have already run a command such as BACKUP that requires a repository connection.

Keywords and Parameters

Syntax Element	Description
`CONNECT` `TARGET` connectStringSpec	Establishes a connection between RMAN and the target database.
`CONNECT` `CATALOG` connectStringSpec	Establishes a connection between RMAN and the recovery catalog database. You must run this command before running any command that requires a repository. Otherwise, RMAN defaults to `NOCATALOG` mode and invalidates the use of `CONNECT` `CATALOG` in the session.
`CONNECT` `AUXILIARY` connectStringSpec	Establishes a connection between RMAN and an auxiliary instance. You can use an auxiliary instance with the `DUPLICATE` command or during TSPITR.

Examples

Connecting Without a Recovery Catalog: Example

This example starts RMAN and then connects to the target database with an Oracle Net service name prod1:

% rman NOCATALOG
RMAN> CONNECT TARGET sys/change_on_install@prod1;

Connecting in the Default NOCATALOG Mode: Example

This example starts RMAN and then connects to the target through Oracle Net. Because BACKUP is run and no CONNECT CATALOG has been run, RMAN defaults to NOCATALOG mode:

% rman
RMAN> CONNECT TARGET sys/change_on_install@prod1;
RMAN> BACKUP DATAFILE 7;
# You cannot run CONNECT CATALOG after this point because RMAN has defaulted to NOCATALOG

Connecting with a Recovery Catalog: Example

This example starts RMAN and then connects to the target database prod1 by using operating system authentication and the recovery catalog database rcat by using a password file:

% rman
RMAN> CONNECT TARGET /
RMAN> CONNECT CATALOG rman/rman@rcat

Connecting to Target, Recovery Catalog, and Duplicate Databases: Example

This example connects to three databases specifying a username and password for each:

% rman
RMAN> CONNECT TARGET SYS/sysdba@prod1
RMAN> CONNECT CATALOG rman/rman@rcat
RMAN> CONNECT AUXILIARY SYS/sysdba@dupdb