{"id":813,"date":"2019-05-07T12:20:37","date_gmt":"2019-05-07T15:20:37","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=813"},"modified":"2019-05-07T12:20:37","modified_gmt":"2019-05-07T15:20:37","slug":"oracle-cloud-erro-backup-incremental","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2019\/05\/07\/oracle-cloud-erro-backup-incremental\/","title":{"rendered":"Oracle Cloud Erro Backup Incremental"},"content":{"rendered":"

Listando os Jobs de Backup<\/h3>\n
[root@bancora bin]# dbcli list-jobs \n\nID                                       Description                                                                 Created                             Status\n---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------\nc58393ad-5ae3-4c7b-928c-d9fdbfabf5de     Create Regular-L1 Backup with TAG-DBTRegular-L115563549458327dN for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU April 27, 2019 5:50:18 AM BRT       Success\nbc0cb3df-0661-4297-8a4d-b74a434f222a     Delete Backup for Database name: OLTP_iad1f9                                April 27, 2019 6:38:33 AM BRT       Success\n02c3e0fb-dcd0-439e-b968-82f9c3df3f0e     Create Regular-L0 Backup with TAG-DBTRegular-L01556441408120FW0 for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU April 28, 2019 5:51:17 AM BRT       Success\neafe6e54-6e83-4113-9d5c-d9c2d9b56849     Delete Backup for Database name: OLTP_iad1f9                                April 28, 2019 7:33:24 AM BRT       Success\nefd8511c-dced-4876-ab7e-1860271a6ff6     Create Regular-L1 Backup with TAG-DBTRegular-L11556527793681Wxh for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU April 29, 2019 5:50:43 AM BRT       Success\n9c26115e-2be1-4011-a87e-6bd9979ec8cb     Delete Backup for Database name: OLTP_iad1f9                                April 29, 2019 6:23:52 AM BRT       Success\n761bfcd8-09f2-481b-b385-43d80bb603ec     Update objectstoreSwift:bALsAUuq3uHr5GJzB2pU                                April 30, 2019 6:01:49 AM BRT       Success\na404d09d-ea2d-4cfd-b643-5bba1f4fc2a5     Create Regular-L1 Backup with TAG-DBTRegular-L11556614192021uTg for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU April 30, 2019 6:04:17 AM BRT       Failure\n7042dbf8-210f-45cf-98e2-6f6ea7f045d1     Create Regular-L0 Backup with TAG-DBTRegular-L01556700598241tWQ for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU May 1, 2019 5:51:00 AM BRT          Failure<\/pre>\n
Analisando os logs do backup<\/h3>\n
[root@bancora ~]# dbcli describe-job -i a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5 -j\n{\n  \"jobId\" : \"a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5\",\n  \"status\" : \"Failure\",\n  \"message\" : \"DCS-10045:Validation error encountered: Window mismatch of backupconfig(30) and db recovery window(10).\",\n  \"reports\" : [ {\n    \"taskId\" : \"TaskZLockWrapper_251\",\n    \"taskName\" : \"task:TaskZLockWrapper_251\",\n    \"taskResult\" : \"DCS-10045:Validation error encountered: Window mismatch of backupconfig(30) and db recovery window(10).\",\n    \"startTime\" : \"April 30, 2019 06:04:19 AM BRT\",\n    \"endTime\" : \"April 30, 2019 06:04:32 AM BRT\",\n    \"status\" : \"Failure\",\n    \"taskDescription\" : null,\n    \"parentTaskId\" : \"TaskServiceRequest_250\",\n    \"jobId\" : \"a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5\",\n    \"tags\" : [ ],\n    \"reportLevel\" : \"Error\",\n    \"updatedTime\" : \"April 30, 2019 06:04:32 AM BRT\"\n  }, {\n    \"taskId\" : \"TaskSequential_252\",\n    \"taskName\" : \"task:TaskSequential_252\",\n    \"taskResult\" : \"DCS-10045:Validation error encountered: Window mismatch of backupconfig(30) and db recovery window(10).\",\n    \"startTime\" : \"April 30, 2019 06:04:19 AM BRT\",\n    \"endTime\" : \"April 30, 2019 06:04:32 AM BRT\",\n    \"status\" : \"Failure\",\n    \"taskDescription\" : null,\n    \"parentTaskId\" : \"TaskZLockWrapper_251\",\n    \"jobId\" : \"a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5\",\n    \"tags\" : [ ],\n    \"reportLevel\" : \"Error\",\n    \"updatedTime\" : \"April 30, 2019 06:04:32 AM BRT\"\n  }, {\n    \"taskId\" : \"TaskParallel_253\",\n    \"taskName\" : \"Validate backup config\",\n    \"taskResult\" : \"\",\n    \"startTime\" : \"April 30, 2019 06:04:19 AM BRT\",\n    \"endTime\" : \"April 30, 2019 06:04:19 AM BRT\",\n    \"status\" : \"Success\",\n    \"taskDescription\" : null,\n    \"parentTaskId\" : \"TaskSequential_252\",\n    \"jobId\" : \"a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5\",\n    \"tags\" : [ ],\n    \"reportLevel\" : \"Info\",\n    \"updatedTime\" : \"April 30, 2019 06:04:19 AM BRT\"\n  }, {\n    \"taskId\" : \"TaskParallel_256\",\n    \"taskName\" : \"Database container validation\",\n    \"taskResult\" : \"\",\n    \"startTime\" : \"April 30, 2019 06:04:19 AM BRT\",\n    \"endTime\" : \"April 30, 2019 06:04:20 AM BRT\",\n    \"status\" : \"Success\",\n    \"taskDescription\" : null,\n    \"parentTaskId\" : \"TaskSequential_252\",\n    \"jobId\" : \"a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5\",\n    \"tags\" : [ ],\n    \"reportLevel\" : \"Info\",\n    \"updatedTime\" : \"April 30, 2019 06:04:20 AM BRT\"\n  }, {\n    \"taskId\" : \"TaskParallel_259\",\n    \"taskName\" : \"libopc existence check\",\n    \"taskResult\" : \"\",\n    \"startTime\" : \"April 30, 2019 06:04:20 AM BRT\",\n    \"endTime\" : \"April 30, 2019 06:04:20 AM BRT\",\n    \"status\" : \"Success\",\n    \"taskDescription\" : null,\n    \"parentTaskId\" : \"TaskSequential_252\",\n    \"jobId\" : \"a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5\",\n    \"tags\" : [ ],\n    \"reportLevel\" : \"Info\",\n    \"updatedTime\" : \"April 30, 2019 06:04:20 AM BRT\"\n  }, {\n    \"taskId\" : \"TaskZJsonRpcExt_262\",\n    \"taskName\" : \"Backup Validations\",\n    \"taskResult\" : \"Successfully validated for database backup\",\n    \"startTime\" : \"April 30, 2019 06:04:20 AM BRT\",\n    \"endTime\" : \"April 30, 2019 06:04:29 AM BRT\",\n    \"status\" : \"Success\",\n    \"taskDescription\" : null,\n    \"parentTaskId\" : \"TaskSequential_252\",\n    \"jobId\" : \"a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5\",\n    \"tags\" : [ ],\n    \"reportLevel\" : \"Info\",\n    \"updatedTime\" : \"April 30, 2019 06:04:29 AM BRT\"\n  }, {\n    \"taskId\" : \"TaskZJsonRpcExt_264\",\n    \"taskName\" : \"Recovery Window validation\",\n    \"taskResult\" : \"DCS-10045:Validation error encountered: Window mismatch of backupconfig(30) and db recovery window(10).\",\n    \"startTime\" : \"April 30, 2019 06:04:29 AM BRT\",\n    \"endTime\" : \"April 30, 2019 06:04:32 AM BRT\",\n    \"status\" : \"Failure\",\n    \"taskDescription\" : null,\n    \"parentTaskId\" : \"TaskSequential_252\",\n    \"jobId\" : \"a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5\",\n    \"tags\" : [ ],\n    \"reportLevel\" : \"Error\",\n    \"updatedTime\" : \"April 30, 2019 06:04:32 AM BRT\"\n  } ],\n  \"createTimestamp\" : \"April 30, 2019 06:04:17 AM BRT\",\n  \"resourceList\" : [ ],\n  \"description\" : \"Create Regular-L1 Backup with TAG-DBTRegular-L11556614192021uTg for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU\",\n  \"updatedTime\" : \"April 30, 2019 06:04:32 AM BRT\"\n}<\/pre>\n
Listando a pol\u00edtica reten\u00e7\u00e3o do backup<\/h3>\n
[root@bancora ~]# dbcli list-backupconfigs\n\nID                                       Name                 RecoveryWindow   CrosscheckEnabled   BackupDestination\n---------------------------------------- -------------------- ---------------- ------------------- --------------------\n29156be7-1539-4d7f-8dca-fda994bfd13e     bALsAUuq3uHr5GJzB2pU_BC 30               true                ObjectStore\n<\/pre>\n
Verificando a reten\u00e7\u00e3o do RMAN<\/h3>\n
RMAN> show all\n\nCONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 10 DAYS;<\/pre>\n
Esse problema pode acontecer se o recovery_window foi atualizado pelo comando RMAN, n\u00e3o pelo comando dbcli.<\/p>\n
Atualizando o recovery_window pelo comando dbcli<\/h3>\n
i = ID
\nw = RecoveryWindow<\/p>\n
[root@bancora ~]# dbcli update-backupconfig -i 29156be7-1539-4d7f-8dca-fda994bfd13e -w 10<\/pre>\n
Listando a pol\u00edtica reten\u00e7\u00e3o do backup<\/h3>\n
[root@bancora ~]# dbcli list-backupconfigs\n\nID                                       Name                 RecoveryWindow   CrosscheckEnabled   BackupDestination\n---------------------------------------- -------------------- ---------------- ------------------- --------------------\n29156be7-1539-4d7f-8dca-fda994bfd13e     bALsAUuq3uHr5GJzB2pU_BC 10               true                ObjectStore<\/pre>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Listando os Jobs de Backup [root@bancora bin]# dbcli list-jobs ID Description Created Status —————————————- ————————————————————————— ———————————– ———- c58393ad-5ae3-4c7b-928c-d9fdbfabf5de Create Regular-L1 Backup with TAG-DBTRegular-L115563549458327dN for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU April 27, 2019 5:50:18 AM BRT Success bc0cb3df-0661-4297-8a4d-b74a434f222a Delete Backup for Database name: OLTP_iad1f9 April 27, 2019 6:38:33 AM BRT Success 02c3e0fb-dcd0-439e-b968-82f9c3df3f0e Create Regular-L0 Backup with TAG-DBTRegular-L01556441408120FW0 for…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[17,91,92,93,106,296,297,298],"class_list":["post-813","post","type-post","status-publish","format-standard","hentry","category-oracle-cloud","tag-dcs-10045validation-error-encountered-window-mismatch-of-backupconfig30-and-db-recovery-window10","tag-dbcli-list-backupconfigs","tag-dbcli-list-jobs","tag-dbcli-update-backupconfig","tag-dcs-10045","tag-recovery-window","tag-recovery_window","tag-recoverywindow"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=813"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/813\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}