connect::=
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 used from within RMAN avoids this problem.See Also:
"cmdLine" for command line connection optionsYou 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 must start a new RMAN session.
You cannot use the CONNECT
CATALOG
command when RMAN is in the default NOCATALOG
mode, that is, when these conditions are met:
You started RMAN without specifying either CATALOG
or NOCATALOG
.
You have already run a command such as BACKUP
that requires a repository connection.
Syntax Element | Description |
---|---|
CONNECT AUXILIARY connectStringSpec |
Establishes a connection between RMAN and an auxiliary instance. Auxiliary instances are used with the TRANSPORT TABLESPACE and DUPLICATE commands, and during RMAN TSPITR. |
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 TARGET connectStringSpec |
Establishes a connection between RMAN and the target database. |
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 Auxiliary 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;