Full Backup

If you want to create a full backup Oracle databases, you can use the BRBACKUP tool. When Veeam Plug-in for SAP on Oracle is configured, the plug-in transfers database backup files to a backup repository connected to Veeam Backup & Replication.

Example 1. Performing Full Database Backup in Offline Mode

Run the brbackup command with the following parameters:

1. Specify the path to the initialization profile file ($Oracle_HOME/dbs/veeam_initSID.sap) as the argument for the -p (-profile) parameter.
2. Specify util_file as the argument for the -d (-device) parameter. This option defines that a file-by-file backup will be performed using Veeam Plug-in.
3. Specify offline_force as the argument for the -t (-type) parameter. With this option, BRBACKUP shuts down the database and performs an offline backup.
4. Specify the argument for the -m (-mode) parameter. With the all argument, BRBACKUP performs backup of files in all tablespaces, but not the control files and online redo log files. For the full list of arguments for the -mode parameter, see this SAP article.
5. Specify credentials that will be used to connect to the database as the argument for the -u (-user) parameter. For details, see this SAP article.

Example 2. Performing Full Database Backup in Online Mode

Run the brbackup command with the following parameters:

1. Specify the path to the initialization profile file ($Oracle_HOME/dbs/veeam_initSID.sap) as the argument for the -p (-profile) parameter.
2. Specify util_file_online as the argument for the -d (-device) parameter.
3. Specify the argument for the -m (-mode) parameter. With the all argument, BRBACKUP performs backup of files in all tablespaces, but not the control files and online redo log files. For the full list of arguments for the -mode parameter, see this SAP article.
4. Specify credentials that will be used to connect to the database as the argument for the -u (-user) parameter. For details, see this SAP article.