Scheduling a Tape Backup Job
This section describes the steps required to set the schedule for a tape backup job.
To schedule a tape backup job with Cloud Control:
-
Complete the steps in "Accessing Recovery Appliance in Cloud Control".
-
In the Schedule section, select one of the following:
-
Immediately: Runs the tape backup job right away.
-
Later: Runs the tape backup job at a future, specified time. Enter the date and time when you want the job to run in the
mm/dd/yyyy hh:mm:ss
format. If you want this job to repeat, then select the frequency from the Repeat drop-down list and enter the applicable values.
-
-
Click OK to save the job.
To edit the schedule settings, select the required tape backup job, click Edit, and make the necessary changes.
To schedule a tape backup job with DBMS_RA:
After creating an SBT job, you must schedule its execution. Typically, you schedule the job to run at regular intervals using a scheduling utility such as Oracle Scheduler.
When an SBT job runs, Recovery Appliance examines all backups of the specified type for the specified databases, and selects the ones that have not yet been copied to tape. Recovery Appliance then generates and queues tasks that copy those backups to tape. One task of type BACKUP_SBT
is added to the Recovery Appliance task queue for each backup piece to copy.
To schedule a tape backup job with Oracle Scheduler, you create a job that will invoke DBMS_RA.QUEUE_SBT_BACKUP_TASK
. This procedure takes a single argument, the name of the SBT job.
-
With SQL*Plus or SQL Developer, connect to the Recovery Appliance database as the Recovery Appliance administrator.
-
Run
DBMS_SCHEDULER.CREATE_JOB
.For example, run the following PL/SQL anonymous block:
BEGIN DBMS_SCHEDULER.CREATE_JOB( job_name => 'sbtjob1', job_type => 'PLSQL_BLOCK', job_action => 'dbms_ra.queue_sbt_backup_task(''oltp_arch_lastfull'');', start_date => SYSTIMESTAMP, enabled => TRUE, auto_drop => TRUE, repeat_interval => 'freq=WEEKLY; BYDAY=MON,WED,FRI; BYHOUR=23'); END;
See Also:
-
"Creating a Tape Backup Job" to learn how to create an SBT job
-
See Oracle Database Administrator’s Guide and Oracle Database PL/SQL Packages and Types Reference for information about Oracle Scheduler