Oracle Cloud – Rodrigo Silva e Silva

Oracle Database 12c Standard Edition ERROR ORA-28374: typed master key not found in wallet ao criar tablespace

CREATE TABLESPACE TESTE DATAFILE  '/u02/app/oracle/oradata/TESTE/ERP/teste.dbf' size 1024M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED;
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet

CREATE TABLESPACE TESTE DATAFILE '/u02/app/oracle/oradata/TESTE/ERP/teste.dbf' size 1024M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED;

ERROR at line 1:

ORA-28374: typed master key not found in wallet

Analisando o status da wallet do CDB$ROOT

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT

column WRL_PARAMETER format a40;
column STATUS format a10;
column WALLET_TYPE format a10;

SQL> SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;

WRL_PARAMETER                            STATUS     WALLET_TYP
---------------------------------------- ---------- ----------
/u01/app/oracle/admin/EXM/tde_wallet/    OPEN       AUTOLOGIN

SQL> show con_name;

CON_NAME

------------------------------

CDB$ROOT

column WRL_PARAMETER format a40;

column STATUS format a10;

column WALLET_TYPE format a10;

SQL> SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;

WRL_PARAMETER STATUS WALLET_TYP

---------------------------------------- ---------- ----------

/u01/app/oracle/admin/EXM/tde_wallet/ OPEN AUTOLOGIN

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE close;

keystore altered.

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE close;

keystore altered.

SET KEYSTORE

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE open IDENTIFIED BY "j-sIc2#dPKFzoLI6PZ-4" CONTAINER=ALL;

keystore altered.

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE open IDENTIFIED BY "j-sIc2#dPKFzoLI6PZ-4" CONTAINER=ALL;

keystore altered.

Acessando o PDB01

SQL> ALTER SESSION SET CONTAINER = PDB01;

Session altered.

SQL> ALTER SESSION SET CONTAINER = PDB01;

Session altered.

SET KEY

SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY "j-sIc2#dPKFzoLI6PZ-4" with backup;

keystore altered.

SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY "j-sIc2#dPKFzoLI6PZ-4" with backup;

keystore altered.

Create Tablespace

SQL> CREATE TABLESPACE TESTE DATAFILE  '/u02/app/oracle/oradata/EXM/SANKHYA/teste.dbf' size 10M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED;

Tablespace created.

SQL> CREATE TABLESPACE TESTE DATAFILE '/u02/app/oracle/oradata/EXM/SANKHYA/teste.dbf' size 10M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED;

Tablespace created.

Resolvido!

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 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

[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

[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"
}

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

[root@bancora ~]# dbcli list-backupconfigs

ID                                       Name                 RecoveryWindow   CrosscheckEnabled   BackupDestination
---------------------------------------- -------------------- ---------------- ------------------- --------------------
29156be7-1539-4d7f-8dca-fda994bfd13e     bALsAUuq3uHr5GJzB2pU_BC 30               true                ObjectStore

[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

RMAN> show all

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 10 DAYS;

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

[root@bancora ~]# dbcli update-backupconfig -i 29156be7-1539-4d7f-8dca-fda994bfd13e -w 10

1	[root@bancora ~]# dbcli update-backupconfig -i 29156be7-1539-4d7f-8dca-fda994bfd13e -w 10

Listando…

Categoria: Oracle Cloud

ORA-28374: typed master key not found in wallet

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

Oracle Cloud Erro Backup Incremental