Set up automatic #Oracle database back-up using #RMAN

By | September 19, 2017

There is a very easy method of setting up on Linux an automatic back-up for Oracle by using database procedures, RMAN and scripts.

STEP 1: Define a back-up script

Create in /home/oracle/backup.sh a script file with the content:

Where rman parameters are configured in the following /home/oracle/bin/backup.rman configuration file:

STEP 2: Create an Oracle scheduled job to run the script at 01:00 a.m. each day

STEP 3: Create an automatic tape/external storage backup job

The only thing left to do is to leave enough time for the rman process to complete, then copy the backups from “
/data/flash_recovery_area/backup” on an external location.

Advertisements

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.