RMAN CONNECT command establishs connection between RMAN and target database. RMAN can also connect with auxiliary or recovery catalog databases.RMAN CONNECT command connections require SYSDBA privilege.

  • AS SYSDBA clause is not required while issuing connect command.
  • Use CONNECT command if RMAN is not already connected to the database.
  • To connect different target, catalog, or auxiliary databases issue new RMAN connect command.

RMAN Connect Syntax

CONNECT [ TARGET
  | AUXILIRY
  | CATALOG connectString]

RMAN Connect Parameters

CONNECT TARGET

Establishes a connection between RMAN and a target database

CONNECT AUXILIARY

Establishes a connection between RMAN and an auxiliary database instance

CONNECT CATALOG

Establishes a connection between RMAN and a recovery catalog database.

connectString

[userid] [/ [password]] [@net_service_name]

RMAN Connect Examples

Connecting RMAN to Target Database Without a Recovery Catalog

In first step RMAN is connected without any catalog and target database. In second step RMAN CONNECT is used to connect target database.

% RMAN NOCATALOG
RMAN> CONNECT TARGET SYS/password@prod1;
connected to target database: PROD1 (DBID=39525561)

Connecting to Target, Recovery Catalog, and Auxiliary Databases

RMAN> CONNECT TARGET SYS/password@prod1;
connected to target database: PROD1 (DBID=39525561)

RMAN> CONNECT CATALOG rman/password@catdb;
connected to recovery catalog database

RMAN> CONNECT AUXILIARY SYS/password@dupdb;
connected to auxiliary database: DUPDB (not mounted)

Connecting to Target database with operating system authentication

% rman
RMAN> CONNECT TARGET;
connected to target database: PROD (DBID=39525561)
Go to top
JSN Boot template designed by JoomlaShine.com