Listando os Jobs de Backup
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[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 Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU April 28, 2019 5:51:17 AM BRT Success eafe6e54-6e83-4113-9d5c-d9c2d9b56849 Delete Backup for Database name: OLTP_iad1f9 April 28, 2019 7:33:24 AM BRT Success efd8511c-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 9c26115e-2be1-4011-a87e-6bd9979ec8cb Delete Backup for Database name: OLTP_iad1f9 April 29, 2019 6:23:52 AM BRT Success 761bfcd8-09f2-481b-b385-43d80bb603ec Update objectstoreSwift:bALsAUuq3uHr5GJzB2pU April 30, 2019 6:01:49 AM BRT Success a404d09d-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 7042dbf8-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 |
Analisando os logs do backup
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 |
[root@bancora ~]# dbcli describe-job -i a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5 -j { "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "status" : "Failure", "message" : "DCS-10045:Validation error encountered: Window mismatch of backupconfig(30) and db recovery window(10).", "reports" : [ { "taskId" : "TaskZLockWrapper_251", "taskName" : "task:TaskZLockWrapper_251", "taskResult" : "DCS-10045:Validation error encountered: Window mismatch of backupconfig(30) and db recovery window(10).", "startTime" : "April 30, 2019 06:04:19 AM BRT", "endTime" : "April 30, 2019 06:04:32 AM BRT", "status" : "Failure", "taskDescription" : null, "parentTaskId" : "TaskServiceRequest_250", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Error", "updatedTime" : "April 30, 2019 06:04:32 AM BRT" }, { "taskId" : "TaskSequential_252", "taskName" : "task:TaskSequential_252", "taskResult" : "DCS-10045:Validation error encountered: Window mismatch of backupconfig(30) and db recovery window(10).", "startTime" : "April 30, 2019 06:04:19 AM BRT", "endTime" : "April 30, 2019 06:04:32 AM BRT", "status" : "Failure", "taskDescription" : null, "parentTaskId" : "TaskZLockWrapper_251", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Error", "updatedTime" : "April 30, 2019 06:04:32 AM BRT" }, { "taskId" : "TaskParallel_253", "taskName" : "Validate backup config", "taskResult" : "", "startTime" : "April 30, 2019 06:04:19 AM BRT", "endTime" : "April 30, 2019 06:04:19 AM BRT", "status" : "Success", "taskDescription" : null, "parentTaskId" : "TaskSequential_252", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Info", "updatedTime" : "April 30, 2019 06:04:19 AM BRT" }, { "taskId" : "TaskParallel_256", "taskName" : "Database container validation", "taskResult" : "", "startTime" : "April 30, 2019 06:04:19 AM BRT", "endTime" : "April 30, 2019 06:04:20 AM BRT", "status" : "Success", "taskDescription" : null, "parentTaskId" : "TaskSequential_252", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Info", "updatedTime" : "April 30, 2019 06:04:20 AM BRT" }, { "taskId" : "TaskParallel_259", "taskName" : "libopc existence check", "taskResult" : "", "startTime" : "April 30, 2019 06:04:20 AM BRT", "endTime" : "April 30, 2019 06:04:20 AM BRT", "status" : "Success", "taskDescription" : null, "parentTaskId" : "TaskSequential_252", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Info", "updatedTime" : "April 30, 2019 06:04:20 AM BRT" }, { "taskId" : "TaskZJsonRpcExt_262", "taskName" : "Backup Validations", "taskResult" : "Successfully validated for database backup", "startTime" : "April 30, 2019 06:04:20 AM BRT", "endTime" : "April 30, 2019 06:04:29 AM BRT", "status" : "Success", "taskDescription" : null, "parentTaskId" : "TaskSequential_252", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Info", "updatedTime" : "April 30, 2019 06:04:29 AM BRT" }, { "taskId" : "TaskZJsonRpcExt_264", "taskName" : "Recovery Window validation", "taskResult" : "DCS-10045:Validation error encountered: Window mismatch of backupconfig(30) and db recovery window(10).", "startTime" : "April 30, 2019 06:04:29 AM BRT", "endTime" : "April 30, 2019 06:04:32 AM BRT", "status" : "Failure", "taskDescription" : null, "parentTaskId" : "TaskSequential_252", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Error", "updatedTime" : "April 30, 2019 06:04:32 AM BRT" } ], "createTimestamp" : "April 30, 2019 06:04:17 AM BRT", "resourceList" : [ ], "description" : "Create Regular-L1 Backup with TAG-DBTRegular-L11556614192021uTg for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU", "updatedTime" : "April 30, 2019 06:04:32 AM BRT" } |
Listando a política retenção do backup
|
1 2 3 4 5 |
[root@bancora ~]# dbcli list-backupconfigs ID Name RecoveryWindow CrosscheckEnabled BackupDestination ---------------------------------------- -------------------- ---------------- ------------------- -------------------- 29156be7-1539-4d7f-8dca-fda994bfd13e bALsAUuq3uHr5GJzB2pU_BC 30 true ObjectStore |
Verificando a retenção do RMAN
|
1 2 3 |
RMAN> show all CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 10 DAYS; |
Esse problema pode acontecer se o recovery_window foi atualizado pelo comando RMAN, não pelo comando dbcli.
Atualizando o recovery_window pelo comando dbcli
i = ID
w = RecoveryWindow
|
1 |
[root@bancora ~]# dbcli update-backupconfig -i 29156be7-1539-4d7f-8dca-fda994bfd13e -w 10 |
Listando a política retenção do backup
|
1 2 3 4 5 |
[root@bancora ~]# dbcli list-backupconfigs ID Name RecoveryWindow CrosscheckEnabled BackupDestination ---------------------------------------- -------------------- ---------------- ------------------- -------------------- 29156be7-1539-4d7f-8dca-fda994bfd13e bALsAUuq3uHr5GJzB2pU_BC 10 true ObjectStore |