Oracle plug-in

Download PDF of this page

The Oracle plug-in uses SQL*Plus to communicate with the database and quiesce & unquiesce oracle database for backup.

The Snap Creator Oracle plug-in supports Oracle Automatic Storage Management (offline or online backups) and online backup of a Real Application Clusters (RAC) database configuration. The Interoperability Matrix contains the latest information about support and compatibility.

To use C Shell (CSH) with the Oracle plug-in on UNIX or Linux platforms, the following conditions should be met:

  • Snap Creator Agent must be started as the Oracle user, instead of the root user.

  • The Oracle user must have the proper environmental variables (ORACLE_HOME and ORACLE_SID) set for the plug-in driven SQL*Plus commands to work.

    This can be accomplished using a shell startup file, such as ~/.cshrc.

The following table lists the Oracle plug-in parameters, provides their settings, and describes them:

Parameter Setting Description

APP_NAME

Oracle

Application name

ORACLE_DATABASES

db_name:user_name

List of Oracle databases and user names Multiple databases and user names can be specified as a semicolon-separated list, for example, db1:user1;db2:user2.

SQLPLUS_CMD

Path to the sqlplus command

CNTL_FILE_BACKUP_DIR

Path to the directory where the user should store the backup control filesThe Oracle user must have appropriate permissions to this directory.

ORA_TEMP

Path to the directory to store the temporary file, for example, /tmp.The Oracle user must have appropriate permissions to this directory.

ARCHIVE_LOG_ONLY

(Y

N

policy:<Y

N>)

Informs the Oracle plug-in to perform only a switch log operationThis setting is useful if you are handling archive log backups separately from data backups.

ORACLE_HOME

Path to the Oracle home directory

ORACLE_HOME_SID

Path to the Oracle home directory for a given system identifier (SID)When backing up multiple databases, it might be important to specify more than one Oracle home directory.

ORACLE_EXPORT_PARAMETERS

(Y

N )

The ORACLE_HOME and ORACLE_SID environment parameters are exported by using the export command. This is applicable only in UNIX or a Linux-based environment.

ORACLE_BACKUPMODE

Option to configure offline or online backups by using the Snap Creator policy. The default option is online. ORACLE_BACKUPMODE=hourly:online,daily:offline

ORACLE_SHUTDOWNABORT

(Y

Related information