1. Administrator's Guide
  2. Managing Recovery Appliance
  3. Copying Backups to Tape with Recovery Appliance
  4. Scheduling a Tape Backup Job

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:

  1. Complete the steps in "Accessing Recovery Appliance in Cloud Control".

  2. 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.

  3. 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.

  1. With SQL*Plus or SQL Developer, connect to the Recovery Appliance database as the Recovery Appliance administrator.

  2. 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: