View Details About Automatic Backups

You can view historical details about scheduled and on-demand backups that use an automatic backup configuration.

You can use the bkup_api utility to view a list of backup jobs, which includes database backups and archive log backups. You can also view details for a specific job.

1. Connect as the opc user to the compute node. In a Data Guard configuration, connect to the compute node hosting the primary database. For detailed instructions, see Connecting to a Compute Node Through Secure Shell (SSH)
2. Start a root-user command shell:

   $ sudo -s
   #

3. Enter the following bkup_api command to view a list of backup jobs:

   # /var/opt/oracle/bkup_api/bkup_api list jobs [--all] --dbname=dbname [--pdb=pdbname]

   where:

   • --all optionally specifies that the job list contains database backups and archive log backups. Without this option, the list does not contain archive log backup jobs.
   • --dbname=dbname specifies the database name for the database that is the subject of the backups.
   • --pdb=pdbname optionally specifies that the job list only contains backups for the specified pluggable database (PDB).

   For example:

   # /var/opt/oracle/bkup_api/bkup_api list jobs --all --dbname=db12c
   DBaaS Backup API V1.5 @2016 Multi-Oracle home
   -> This node is not master. Running on Elastic configuration.
   -> Action : list_jobs
   -> logfile: /var/opt/oracle/bkup_api/log/bkup_api.log
   UUID                             | DATE                | STATUS  | TAG                | TYPE
   e1120cba477711e9a16d0010ee68ed9a | 2019-03-15 23:13:11 | success | TAG20190315T231806 | incremental
   0b4ead48484111e9ac030010ee68ed9a | 2019-03-16 23:13:11 | success | TAG20190316T231816 | incremental
   35ec694a490a11e98e130010ee68ed9a | 2019-03-17 23:13:13 | success | TAG20190317T231854 | full
   2fa5e16849cf11e9a5b30010ee68ed9a | 2019-03-18 22:43:06 | success | None               | archivelog
   60a08be849d311e987fb0010ee68ed9a | 2019-03-18 23:13:20 | success | TAG20190318T231751 | incremental
   915f149e49d711e991f60010ee68ed9a | 2019-03-18 23:43:06 | success | None               | archivelog
   f35926d249df11e99f440010ee68ed9a | 2019-03-19 00:43:06 | success | None               | archivelog
   54f3887649e811e9af320010ee68ed9a | 2019-03-19 01:43:06 | success | None               | archivelog
   

4. To view detailed information for a specific backup job, choose a job UUID from the list of backup jobs and enter the following command:

   # /var/opt/oracle/bkup_api/bkup_api --uuid=uuid --dbname=dbname

   For example:

   # /var/opt/oracle/bkup_api/bkup_api --uuid=60a08be849d311e987fb0010ee68ed9a --dbname=db12c
   DBaaS Backup API V1.5 @2016 Multi-Oracle home
   -> This node is not master. Running on Elastic configuration.
   @ STARTING CHECK STATUS 60a08be849d311e987fb0010ee68ed9a
   [ REQUEST TICKET ]
   [UUID    ->  60a08be849d311e987fb0010ee68ed9a
   [DBNAME  ->  db12c
   [STATE   ->  success
   [ACTION  ->  create-backup-incremental
   [STARTED ->  2019-03-18 23:13:20
   [ENDED   ->  2019-03-18 23:18:30.921995
   [PID     ->  282732
   [TAG     ->  TAG20190318T231751
   [LOG     ->  API:: Wallet is in open state
   [LOG     ->  API:: Oracle database state is up and running
   [LOG     ->  API:: DB instance: db12c
   [LOG     ->  API:: Validating the backup repository ......
   [LOG     ->  API::      All backup pieces are ok
   [LOG     ->  API:: Performing backup to local storage (primary backup)
   [LOG     ->  API:: Executing rman instructions
   [LOG     ->  API:: ...... OK
   [LOG     ->  API:: Backup to local storage is completed
   [LOG     ->  API:: Clean MOTD.
   [LOG     ->  API:: Performing backup to cloud storage (secondary backup)
   [LOG     ->  API:: Executing rman instructions
   [LOG     ->  API:: ......OK
   [LOG     ->  API:: Backup to cloud storage is completed
   [LOG     ->  API:: Clean MOTD.
   [LOG     ->  API:: Starting backup of config files
   [LOG     ->  API:: at time: 2019-03-18:23:17:51
   [LOG     ->  API:: Determining the oracle database id
   [LOG     ->  API::  DBID: 4075204950
   [LOG     ->  API:: Creating directories to store config files
   [LOG     ->  API:: Determining the oracle database id
   [LOG     ->  API::  DBID: 4075204950
   [LOG     ->  API:: Enabling RAC exclusions for config files.
   [LOG     ->  API:: Compressing config files into tar files
   [LOG     ->  API:: Uploading config files to cloud storage
   [LOG     ->  API:: Completed at time: 2019-03-18:23:18:18
   [LOG     ->  API:: at time: 2019-03-18:23:18:18
   [LOG     ->  API:: Config files backup ended successfully
   [LOG     ->  API:: Clean MOTD.
   [LOG     ->  API:: All requested tasks are completed
   [ END TICKET ]
   

5. Exit the root-user command shell and disconnect from the compute node:

   # exit
   $ exit