Retrieve the History of Scheduled Backup Results with the bkup

Retrieve the History of Scheduled Backup Results with the bkup_api Utility

Retrieve details for each backup instance in the history of a scheduled backup.

You can use the bkup_api utility to list each backup job for a scheduled backup. The command can also display CDB jobs and bkup_archlogs as well as details of 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:
```
# /var/opt/oracle/bkup_api/bkup_api list jobs --all
```
where:
- --all specifies that the job list contains CDB jobs and bkup_archlogs.
- --dbname=dbname is required for ExaData systems and is the database name for the database that you want to recover.
- --pdb specifies that the list only contains PDB jobs from the specified database.
- --uuid=uuid specifies that the command returns detailed information about the job with the specified UUID.
Choose a job UUID from the list displayed and enter the following command:
```
# /var/opt/oracle/bkup_api/bkup_api list jobs  --uuid=uuid
```
Exit the root-user command shell and disconnect from the compute node:
```
# exit
$ exit
```

Get all jobs:

[opc]# /var/opt/oracle/bkup_api/bkup_api list jobs --dbname=sample --all 
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
c3d11e6c250211e9af3100163e6d8d75 | 2019-01-31 02:49:11 | success | None               | archivelog
25c15436250b11e98a2000163e6d8d75 | 2019-01-31 03:49:12 | success | None               | archivelog
87775fa6251311e9aca300163e6d8d75 | 2019-01-31 04:49:11 | success | None               | archivelog
e9ce9da6251b11e985b400163e6d8d75 | 2019-01-31 05:49:12 | success | None               | archivelog
4b375fbc252411e9be4e00163e6d8d75 | 2019-01-31 06:49:11 | success | None               | archivelog
acb0ebe8252c11e9a12a00163e6d8d75 | 2019-01-31 07:49:11 | success | None               | archivelog
0eaf0fd4253511e9a4bd00163e6d8d75 | 2019-01-31 08:49:12 | success | None               | archivelog
7056d17e253d11e99e9b00163e6d8d75 | 2019-01-31 09:49:12 | success | None               | archivelog
d2897916254511e9bfd200163e6d8d75 | 2019-01-31 10:49:12 | success | None               | archivelog
34328510254e11e988cc00163e6d8d75 | 2019-01-31 11:49:12 | success | None               | archivelog
95d6b522255611e9a59300163e6d8d75 | 2019-01-31 12:49:11 | success | None               | archivelog
f79613a4255e11e9b1ea00163e6d8d75 | 2019-01-31 13:49:12 | success | None               | archivelog
593d0844256711e9b75f00163e6d8d75 | 2019-01-31 14:49:11 | success | None               | archivelog
bb4339de256f11e9a72c00163e6d8d75 | 2019-01-31 15:49:13 | success | None               | archivelog
1d7dcf94257811e99c2100163e6d8d75 | 2019-01-31 16:49:13 | success | None               | archivelog
80213598258011e9978700163e6d8d75 | 2019-01-31 17:49:30 | success | None               | archivelog
e04ec392258811e9a96400163e6d8d75 | 2019-01-31 18:49:13 | success | None               | archivelog
4264c9ca259111e990a900163e6d8d75 | 2019-01-31 19:49:13 | success | None               | archivelog
a3e8f344259911e9bf4500163e6d8d75 | 2019-01-31 20:49:11 | success | None               | archivelog
05cec57225a211e9aff500163e6d8d75 | 2019-01-31 21:49:12 | success | None               | archivelog
678ba60625aa11e9993000163e6d8d75 | 2019-01-31 22:49:12 | success | None               | archivelog
...

Get details for one job:

[opc]# /var/opt/oracle/bkup_api/bkup_api --uuid=sampled829e711e993d700163e6d8d75           
DBaaS Backup API V1.5 @2016 Multi-Oracle home
DBaaS Backup API V1.5 @2015 Multi-Oracle home
-> This node is not master. Running on Elastic configuration.
@ STARTING CHECK STATUS sampled829e711e993d700163e6d8d75
[ REQUEST TICKET ]
[UUID    ->  sampled829e711e993d700163e6d8d75
[DBNAME  ->  FSPOD1
[STATE   ->  failed
[ACTION  ->  create-backup-incremental
[STARTED ->  2019-02-06 08:19:34
[ENDED   ->  2019-02-06 00:46:51.469039
[PID     ->  258279
[TAG     ->  None
[ERROR   ->  API::ERROR Cannot complete the Incremental backup to cloud storage.
[ERROR   ->  API::ERROR Please check the obkup /var/opt/oracle/log/FSPOD1/obkup/obkup_2019-02-06_00:19:52.log for more information.
[ERROR   ->  API::ERROR RMAN errors found during backup
[ERROR   ->  API::ERROR-Detail
[ERROR   ->  OBKUP:: ..... FAIL
[ERROR   ->  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
[ERROR   ->  RMAN-03002: failure of backup command at 02/06/2019 00:46:05
[ERROR   ->  RMAN-03002: failure of backup command at 02/06/2019 00:46:22
[LOG     ->  API:: Oracle database state is up and running
[LOG     ->  API:: DB instance: FSPOD1
[LOG     ->  API:: Validating the backup repository ......
[LOG     ->  API::      All backup pieces are ok
[LOG     ->  API:: Performing Incremental Backup to Cloud Storage
[LOG     ->  API:: Executing rman instructions
[LOG     ->  API:: ..... FAIL
[LOG     ->  API::ERROR Cannot complete the Incremental backup to cloud storage.
[LOG     ->  API::ERROR-Detail
[LOG     ->  API::ERROR RMAN errors found during backup
[LOG     ->  API::ERROR Please check the obkup /var/opt/oracle/log/FSPOD1/obkup/obkup_2019-02-06_00:19:52.log for more information.
[LOG     ->  API:: Message sent to DB alertlog.
[LOG     ->  API:: Message sent to System log.
[LOG     ->  API:: Clean MOTD.
[LOG     ->  API:: Message sent to MOTD.
[ END TICKET ]
[opc]#