Skip Headers

Oracle9i Recovery Manager Reference
Release 2 (9.2)

Part Number A96565-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

RMAN Commands , 16 of 59


CONNECT

Syntax

Text description of connect.gif follows
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

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

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback