Run Backup Template

The Run Backup Template wizard has the following options:

Target Database Logon Credentials

The target database is the database being backed up.

The user that performs the backup operation must be a database administrator. You can choose between operating system authentication or password files to authenticate database administrators.

Logon credentials

Logon credentials are not required when database administrators are authenticated using operating system authentication.

Logon credentials are required when database administrators are authenticated using password files. The credentials consist of a user name, a password, and optionally a net service name (TNS alias) which together make up the database connect string.

User name

Refers to the database administrator's login name. The administrator must have SYSDBA privileges.

Password

Refers to the login password for the database administrator.

Recovery Database Logon Credentials

Recovery Database Logon Credentials must be provided if the selected template uses an RMAN recovery catalog.

The recovery database contains the recovery catalog that consists of a set of Oracle tables and views. The Recovery Manager is used to manage the backup, restore, and recovery of Oracle databases.

The logon credentials for the Recovery Catalog database consist of the following, which together make up the database connect string:

  • User name

  • Password

  • Net service name (TNS alias)

    The Net service name is optional.

User name

Refers to the login name for the Oracle database that contains the recovery catalog. The user must be the recovery catalog owner.

Password

Refers to the login password for the user name.

Net service name

Also known as the TNS alias. Used to indicate what database to use.

Oracle translates the service name to a connect descriptor through the tnsnames.ora file. If this field is left blank, RMAN does not use a network listener to connect to the database. In this case, the selected Oracle SID determines what database to connect to. If you use a Recovery Catalog and thereby multiple SIDs, use a service name for either the target database or the recovery catalog database. Only one Oracle SID can be specified at any one time in the environment.