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.
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]#