> For the complete documentation index, see [llms.txt](https://docs.storware.eu/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.storware.eu/protecting-applications/applications/oracle.md).

# Oracle

To create a new application for Oracle database backup, go to the tab: **Applications -> Instances**

Then select the **Create** button. The Creating an Application Definition section will be displayed, which needs to be completed.

This is a description of how your script is going to be invoked - you need to specify:

* **Name** - unique name of the application in the Storware Backup & Recovery system.
* **Choose Node Config** - select which node should perform the task.
* **Backup policy** - specify which backup policy should be used for this application.
* **Command execution configuration** - select a prepared template for Oracle backup or create a [new](/administration/applications/execution-configurations.md) one yourself.

In the SSH access subtab, complete the following fields:

* **Host** - set the address of the host where the Oracle instance exists.
* **Port** - set the host port.

Next, select OS Credentials or create a new one and provide the following information:

* **Name** - unique name of the OS Credentials.
* **User** - indicate a user for SSH connection.
* **Password** - enter the connection password.
* **SSH key path** - alternatively, you can specify the SSH key path for authorization.

After saving the application configuration, define the following environment variables:

#### Environment Variables

<table data-search="false"><thead><tr><th>Variable</th><th>Value</th><th>Description</th></tr></thead><tbody><tr><td><code>VP_ORACLE_DBORARCH</code></td><td><code>db</code> / <code>arch</code></td><td>Backs up the database (<code>db</code>) or database logs (<code>arch</code>).</td></tr><tr><td><code>VP_ORACLE_PASSWORD</code></td><td><em>string</em></td><td>Password for the Oracle database user.</td></tr><tr><td><code>VP_ORACLE_RETENTION</code></td><td><em>string</em></td><td>RMAN retention policy. Use <code>RECOVERY_WINDOWS_OF_14_DAYS</code> for days or <code>REDUNDANCY_14</code> for backup count.</td></tr><tr><td><code>VP_ORACLE_ENVIROINMENTVARIABLES</code></td><td><em>string</em></td><td>Path to the Oracle database environment variables.</td></tr><tr><td><code>VP_ORACLE_SCRIPTPATH</code></td><td><em>string</em></td><td>Path to the backup script on the Oracle Database server. Copy the script from <code>/opt/vprotect/server/scripts/application</code> to the Oracle host. Then specify its local path here.</td></tr><tr><td><code>VP_ORACLE_COMPRESS</code></td><td><code>yes</code> / <code>no</code></td><td>Compresses the backup on the Oracle server.</td></tr><tr><td><code>VP_ORACLE_USER</code></td><td><em>string</em></td><td>Oracle login username.</td></tr><tr><td><code>VP_ORACLE_LOGPATH</code></td><td><em>string</em></td><td>Path on the Oracle server for the backup job log file.</td></tr><tr><td><code>VP_ORACLE_STOREPATH</code></td><td><em>string</em></td><td>Path on the Oracle server for the backup file.</td></tr></tbody></table>

{% hint style="info" %}
**Note:** After the new application is fully configured, **save** the changes and go to the [Backup SLAs](/administration/applications/backup-slas.md) configuration.
{% endhint %}