Skip to content

RMAN CONNECT

    Use RMAN CONNECT command to establish a connection between RMAN and a target, auxiliary, or recovery catalog database.

    Connecting to a Target Database Without a Recovery Catalog

    This example starts RMAN in NOCATALOG mode and then connects to the target database with an Oracle Net service name prod1sbu is a user who is granted the SYSBACKUP privilege.

    % rman NOCATALOG
    RMAN> CONNECT TARGET "[email protected] AS SYSBACKUP";
    
    target database Password: password
    connected to target database: PROD1 (DBID=39525561)

    Connecting to a Target Database in the Default NOCATALOG Mode

    This example starts RMAN without specifying either CATALOG or NOCATALOG and then uses operating system authentication to connect to a target database with operating system authentication. Because no CONNECT CATALOG command has been run, RMAN defaults to NOCATALOG mode when you run the BACKUP command.

    % rman
    RMAN> CONNECT TARGET /
    RMAN> BACKUP DATABASE;
    

    At this point in the RMAN session, you cannot run CONNECT CATALOG because the session has defaulted to NOCATALOG mode. An attempt to connect to the catalog in this session receives an error:

    RMAN> CONNECT CATALOG [email protected]
    
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-06445: cannot connect to recovery catalog after NOCATALOG has been used

    Connecting to Target, Recovery Catalog, and Auxiliary Databases

    This example connects to a target database with operating system authentication and connects to the recovery catalog and auxiliary databases with password files. sbu is a user who is granted the SYSBACKUP privilege. RMAN prompts for the password.

    % rman
    RMAN> CONNECT TARGET;
    
    connected to target database: PROD (DBID=39525561)
    
    RMAN> CONNECT CATALOG [email protected];
     
    recovery catalog database Password: password
    connected to recovery catalog database
    
    RMAN> CONNECT AUXILIARY "[email protected] AS SYSBACKUP";
    
    auxiliary database Password: password
    connected to auxiliary database: DUPDB (not mounted)

    Connecting to the Root Using Operating System Authentication

    This example connects to the root in a CDB using operating system authentication. By default, the connection is established using SYSDBA privilege.

    %rman
    RMAN> CONNECT TARGET /
    

    Connecting to a PDB as a Local User

    This example connects to the PDB hr_pdb as the local user sbu_pdb who is granted the SYSBACKUP privilege on the hr_pdb PDB. hrpdb is the net service name corresponding to the PDB hr_pdb.

    %rman
    RMAN> CONNECT TARGET "[email protected] AS SYSBACKUP";
    

    Also See:

    ORACLE RMAN

    Interacting with RMAN