We use cookies on our website to ensure we provide you with the best experience on our website. By using our website, you agree to the use of cookies for analytics and personalized content.This website uses cookies. More Information
It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda Backup

Protecting Oracle Databases

  • Last updated on

Oracle databases can be protected by using native tools like RMAN to create a backup dump file or by configuring a pre-execute script on the Barracuda Backup Agent.

Oracle on Microsoft Windows

To automate the Oracle database backup process, you must create a script and command file which utilizes the Oracle RMAN.

Running an Oracle database in archivelog mode allows you to back up the database while it is open and in use. Verify your Oracle database is in archivelog mode to complete your backup.

Example

Create a script named backup.bat containing the following:

C:
cd C:\ora10g\BIN
rman @C:\backup_rman\backup.rman

Create a command file named backup.rman containing the following:

connect target 'system/password'
run
{
allocate channel d1 type disk;
backup AS COMPRESSED BACKUPSET tag Full_database_open format 'C:\backup_rman\db_%t_%s_p%p.dbf' database;
backup AS COMPRESSED BACKUPSET archivelog all format 'C:\dbbackup_rman\al_%t_%s_p%p.dbf' delete all input;
backup AS COMPRESSED BACKUPSET current controlfile tag =cf1 format 'C:\dbbackup_rman\cf_%t_%s_p%p.dbf';
delete noprompt expired backup;
}

After creating the script and command file, edit the Barracuda Backup Agent config.ini file located in C:\Program Files\Barracuda\Barracuda Backup Agent\Config\, and add the following line under the entry [configuration]:

PreExecuteScript=C:\backup.bat

Save and run a backup from Barracuda Backup, and verify that the RMAN dump files are backed up with the barracuda Agent or CIFS method.

Oracle on Linux

To automate the Oracle database backup process, you must create a script and command file which utilizes the Oracle RMAN.

Running an Oracle database in archivelog mode allows you to back up the database while it is open and in use. Verify your Oracle database is in archivelog mode to complete your backup, as shown in Figure 1.

Figure 1. archivelog mode.

oracleRMAN01.png

Example

Create a script named backup.sh containing the following:

#!/bin/bash
su – oracle -c "rman cmdfile='/u01/backup.rman'"

Create a command file named backup.rman containing the following:

connect target SYSTEM/<password>;
configure channel device type disk format '/u01/backup/%d_DB_%u_%s_%p';
configure retention policy to recovery window of 3 days;
backup database plus archivelog;
quit;

After creating the script and command file, edit the Barracuda Backup Agent config.ini file located in "/usr/local/barracuda/bbs/config/", and add either the preExecuteScript or postExecuteScript command following line under the entry [configuration]. For example:

preExecuteScript

[configuration]
preExecuteScript=/u01/backup.sh

or

postExecuteScript

[configuration]
postExecuteScript=C:\afterBackup.bat

 

Save and run a backup from Barracuda Backup, and verify that the RMAN dump files are backed up with the Barracuda Backup Agent.

 

 

 

 

 

 

 

Last updated on