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

brbackup -p $Oracle_HOME/dbs/veeam_initSID.sap -d util_file -t offline_force -m all -u <user>/<password>

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

brbackup -p $Oracle_HOME/dbs/veeam_initSID.sap -d util_file_online -t online_cons -m all -u <user>/<password>

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 online_cons as the argument for the -t (-type) parameter. With this option, BRBACKUP backs up the database in the online state. Also, BRBACKUP keeps the database open during the backup. If offline redo log files are generated during the backup, BRBACKUP backs up them to the same backup file.
  4. Specify the argument for the -m (-mode) parameter. With the all argument, BRBACKUP backs up 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.

Important

When you use BRBACKUP, you must specify the full directory path to the Veeam Plug-in initialization profile file (-p $Oracle_HOME/dbs/veeam_initSID.sap). If the profile file is in the default directory, you can specify only the file name.

Page updated 7/25/2024

Page content applies to build 12.1.2.172