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.

• After being connected to a target database, you must exit and restart RMAN to connect to a different target database.

• If you need to connect to a different target, catalog, or auxiliary database, then you should start a new RMAN session.

• You cannot specify the NOCATALOG option on the command line and then run CONNECT CATALOG at the RMAN prompt.

• 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

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. An auxiliary instance can be used with the DUPLICATE command or used 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 database with an Oracle Net service name prod1. 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 different 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