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 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

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

Note: After the new application is fully configured, save the changes and go to the Backup SLAs configuration.