- Administering Oracle Database Exadata Cloud at Customer (Gen 1/OCI-C)
- Backing Up and Restoring Databases on Exadata Cloud at Customer
- View Details About Automatic Backups
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.
- 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) - Start a root-user command shell:
$ sudo -s #
- 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
- 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 ]
- Exit the root-user command shell and disconnect from the compute node:
# exit $ exit