Creating a Job Template

This task creates a job template for archive-to-cloud.

The options given to RACLI are passed to the installer, which handles setting lifecycle management for the bucket.

1. Log in to SQL*Plus with an admin db_user user.

2. Create a SBT_JOB_TEMPLATE for archive-to-cloud. The supported algorithms are ‘AES128’, ‘AES192’, and ‘AES256’. The attribute set name is either <CLOUD_LOCATION_NAME>_1 for 1 stream or <CLOUD_LOCATION_NAME>_2 for two (2) streams in parallel.

   SQL> exec dbms_ra.create_sbt_job_template(template_name=>'<COPY_TO_CLOUD_TEMPLATE_NAME>',
   protection_policy_name=>'BRONZE',
   attribute_set_name=>'< Attribute Set Name >',
   backup_type=>'ALL',
   full_template_name=>'<COPY_TO_CLOUD_TEMPLATE_NAME>',
   from_tag=>NULL,
   priority=>100,
   copies=>1,
   window=>NULL,
   compression_algorithm=>'<SUPPORTED_COMPRESSION>',
   encryption_algorithm=>'<SUPPORTED_ALGO>');

   Note: When using compliance, Oracle recommends having one bucket per database. When you create a job template in a compliance environment, use db_unique_name instead of protection_policy_name in your job template, unless the protection policy is used by a single database.

   SQL> exec dbms_ra.create_sbt_job_template(template_name=>'<COPY_TO_CLOUD_TEMPLATE_NAME>',
   db_unique_name=> '< Database Name>',
   attribute_set_name=>'< Attribute Set Name >',
   backup_type=>'ALL',
   full_template_name=>'<COPY_TO_CLOUD_TEMPLATE_NAME>',
   from_tag=>NULL,
   priority=>100,
   copies=>1,
   window=>NULL,
   compression_algorithm=>'<SUPPORTED_COMPRESSION>',
   encryption_algorithm=>'<SUPPORTED_ALGO>');

   For details on the command options, refer to “CREATE_SBT_JOB_TEMPLATE”.

3. Run the archive-to-cloud job..

   SQL> exec dbms_ra.queue_sbt_backup_task('<COPY_TO_CLOUD_TEMPLATE_NAME>');
   
   PL/SQL procedure successfully completed.

4. Verify backup initiation.

   SQL> SELECT task_type, state, TRUNC(last_execute_time), COUNT(*)
   FROM ra_task
   WHERE state IN ('RUNNING','EXECUTABLE','WAITING','LIBRARY_WAIT')
   AND archived = 'N'
   GROUP BY task_type, state, TRUNC(last_execute_time);
   
   TASK_TYPE      STATE         TRUNC(LAS  COUNT(*)
   
   -------------- ------------- ---------  ----------
   BACKUP_SBT     EXECUTABLE    18-JUN-18  18
   BACKUP_SBT     RUNNING       18-JUN-18  2