{"id":1837,"date":"2020-08-27T22:27:07","date_gmt":"2020-08-27T22:27:07","guid":{"rendered":"https:\/\/swiv.com.br\/rman-06429-rcvcat-database-is-not-compatible\/"},"modified":"2026-05-27T20:02:53","modified_gmt":"2026-05-27T19:02:53","slug":"rman-06429-rcvcat-database-is-not-compatible","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2020\/08\/27\/rman-06429-rcvcat-database-is-not-compatible\/","title":{"rendered":"[Solved] Issue: RMAN-06429: RCVCAT database is not compatible"},"content":{"rendered":"\n

Ao tentar executar um backup de um banco recentemente atualizado para 18C, recebi a seguinte mensagem:<\/p>\n\n\n

\nPL\/SQL package OWNER.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old\nPL\/SQL package OWNER.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of crosscheck command at 08\/19\/2020 11:09:25\nRMAN-12010: automatic channel allocation initialization failed\nRMAN-06429: RCVCAT database is not compatible with this version of RMAN\n<\/pre><\/div>\n\n
Encontrei o Oracle note “RMAN-06429: RCVCAT database is not compatible with this version of RMAN (Doc ID 2022782.1)<\/strong>“.<\/p>\n\n\n
\"\"<\/figure>\n\n\n\n
Nesta nota, \u00e9 indicado a necessidade de se realizar um “UPGRADE CATALOG”. O detalhe \u00e9 que o meu banco de cat\u00e1logo est\u00e1 na vers\u00e3o 10.2.0.4, e durante o processo de atualiza\u00e7\u00e3o, um novo erro \u00e9 reportado:<\/p>\n\n\n
\n[user@hostname folder]$ rman target \/ catalog OWNER\/*****@CAT10G\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Wed Aug 19 11:33:01 2020\nVersion 18.5.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n \nconnected to target database: TESTE (DBID=3671898123)\nconnected to recovery catalog database\nPL\/SQL package OWNER.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old\n \nRMAN> register database;\n \nPL\/SQL package OWNER.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old\nPL\/SQL package OWNER.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of register command at 08\/19\/2020 11:33:12\nRMAN-06429: RCVCAT database is not compatible with this version of RMAN\n \nRMAN> upgrade catalog;\n \nrecovery catalog owner is OWNER\nenter UPGRADE CATALOG command again to confirm catalog upgrade\n \nRMAN> upgrade catalog;\n \nerror creating dbms_rcvvpc package body\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-06443: error upgrading recovery catalog\n \nRMAN>\n<\/pre><\/div>\n\n
Por desconfiar se a minha vers\u00e3o de cat\u00e1logo ainda \u00e9 compat\u00edvel com o meu target database, recorro \u00e0 nota “RMAN Compatibility Matrix (Doc ID 73431.1)<\/strong>” e percebo que ainda estou dentro da matriz de compatibilidade.<\/p>\n\n\n
\"\"<\/figure>\n\n\n\n
Como no erro \u00e9 mencionado que a package “dbms_rcvvpc” ficou com algum problema, tento recompil\u00e1-la manualmente e checo em detalhes o seu erro:<\/p>\n\n\n
\nSQL> alter PACKAGE OWNER.DBMS_RCVVPC compile body;\n \nWarning: Package Body altered with compilation errors.\n \nSQL> show errors;\nErrors for PACKAGE BODY OWNER.DBMS_RCVVPC:\n \nLINE\/COL ERROR\n-------- -----------------------------------------------------------------\n112\/12   PLS-00801: internal error [*** ASSERT at file pdw4.c, line 5926;\n         Illegal defun (141) for name expression;\n         DBMS_RCVVPC__OW_NER__B__5447795[112, 12]]\n \nSQL>\n<\/pre><\/div>\n\n
A partir deste erro mais detalhado, consigo chegar na nota “Bug 7322183 – PLS-00801: internal error ASSERT at file pdw4.c, line 5926, Illegal defun for name expression (Doc ID 7322183.8)<\/strong>” que reporta a exist\u00eancia de um bug nas vers\u00f5es 10.2.0.3 e 10.2.0.4 no banco de cat\u00e1logo, na tentativa de fazer o upgrade, quando o target database est\u00e1 na vers\u00e3o 12.2 (por\u00e9m, em chamado aberto, tamb\u00e9m confirmei que se aplicar para bancos 18C, que era o meu caso).<\/p>\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Nesta etapa, n\u00e3o existe muito o que se fazer. A \u00fanica solu\u00e7\u00e3o seria subir a vers\u00e3o do banco de cat\u00e1logo de 10.2.0.4 para 10.2.0.5, ou migrar este owner espec\u00edfico para algum outros banco com vers\u00e3o mais recente, utilizando o recurso “IMPORT CATALOG”. Felizmente, eu possu\u00eda outro banco de cat\u00e1logo com vers\u00e3o 12.2. Ent\u00e3o eu fiz a cria\u00e7\u00e3o de uma nova tablespace e owner no banco novo:<\/p>\n\n\n
\nCREATE TABLESPACE TABLESPACE_TESTE DATAFILE \n  '+DISK_GROUP' SIZE 33M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\nLOGGING\nONLINE\nPERMANENT\nEXTENT MANAGEMENT LOCAL AUTOALLOCATE\nBLOCKSIZE 8K\nSEGMENT SPACE MANAGEMENT AUTO\nFLASHBACK ON;\n \n \nCREATE USER OWNER\n  IDENTIFIED BY *****\n  DEFAULT TABLESPACE TABLESPACE_TESTE\n  PROFILE DEFAULT\n  ACCOUNT UNLOCK;\n  -- 3 Roles for OWNER \n  GRANT RECOVERY_CATALOG_OWNER TO OWNER;\n  GRANT CONNECT TO OWNER;\n  GRANT RESOURCE TO OWNER;\n  ALTER USER OWNER DEFAULT ROLE ALL;\n  -- 1 System Privilege for OWNER \n  GRANT UNLIMITED TABLESPACE TO OWNER;\n  -- 1 Tablespace Quota for OWNER \n  ALTER USER OWNER QUOTA UNLIMITED ON TABLESPACE_TESTE;\n<\/pre><\/div>\n\n\n
Tentando importar o cat\u00e1logo:<\/p>\n\n\n
\n[user@hostname~]$ rman target \/ catalog OWNER\/***@CAT12C\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Wed Aug 26 09:22:54 2020\nVersion 18.5.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n \nconnected to target database: TESTE (DBID=3671898123)\nconnected to recovery catalog database\n \nRMAN> IMPORT CATALOG OWNER\/*****@CAT10G\n2> ;\n \nStarting import catalog at 26-AUG-20\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of import catalog command at 08\/26\/2020 09:23:44\nRMAN-06428: recovery catalog is not installed\n \nRMAN>\n \n \n \nRMAN> create catalog;\n \nrecovery catalog created\n \nRMAN> IMPORT CATALOG OWNER\/*****@CAT10G;\n \nStarting import catalog at 26-AUG-20\nconnected to source recovery catalog database\nrecovery catalog is partially upgraded to 18.05.00.00\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of import catalog command at 08\/26\/2020 09:27:36\nRMAN-06429: IMPCAT database is not compatible with this version of RMAN\n \nRMAN>\n<\/pre><\/div>\n\n
O erro acima acontece pois um pr\u00e9-requisito do import catalog n\u00e3o foi realizado. Link AQUI<\/a>.<\/p>\n\n\n
\"\"
The version of the source recovery catalog schema must be equal to the current version of the destination recovery catalog schema. If they are not equal, then upgrade the schemas to the same version.<\/em><\/figcaption><\/figure>\n\n\n\n
Ou seja, para importar o cat\u00e1logo para outro banco, ele j\u00e1 precisa ter sofrido o “upgrade catalog”. Por\u00e9m eu n\u00e3o conseguia fazer o upgrade por conta do bug. Desse modo, com respaldo do fornecedor, precisei fazer um export do owner de cat\u00e1logo 10G e import\u00e1-lo no banco 12C, mesmo ele possuindo alguns objetos inv\u00e1lidos por conta do upgrade mal sucedido. Segue abaixo a importa\u00e7\u00e3o do mesmo para abreviar o processo:<\/p>\n\n\n
\n[user@hostname_novo EXP]$ impdp parfile=imp.par\n \nImport: Release 12.2.0.1.0 - Production on Thu Aug 20 08:42:21 2020\n \nCopyright (c) 1982, 2017, Oracle and\/or its affiliates.  All rights reserved.\n \nConnected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\nMaster table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded\/unloaded\nimport done in AL32UTF8 character set and AL16UTF16 NCHAR character set\nexport done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set\nWarning: possible data loss in character set conversions\nStarting "SYSTEM"."SYS_IMPORT_FULL_01":  system\/******** parfile=imp.par\nProcessing object type SCHEMA_EXPORT\/USER\nORA-31684: Object type USER:"OWNER" already exists\n \nProcessing object type SCHEMA_EXPORT\/SYSTEM_GRANT\nProcessing object type SCHEMA_EXPORT\/ROLE_GRANT\nProcessing object type SCHEMA_EXPORT\/DEFAULT_ROLE\nProcessing object type SCHEMA_EXPORT\/TABLESPACE_QUOTA\nProcessing object type SCHEMA_EXPORT\/PRE_SCHEMA\/PROCACT_SCHEMA\nProcessing object type SCHEMA_EXPORT\/TYPE\/TYPE_SPEC\nProcessing object type SCHEMA_EXPORT\/SEQUENCE\/SEQUENCE\nProcessing object type SCHEMA_EXPORT\/SEQUENCE\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\n. . imported "OWNER"."BDF"                     1.835 MB   15356 rows\n. . imported "OWNER"."BP"                      1.543 MB    7485 rows\n. . imported "OWNER"."ROUT"                    640.4 KB    7111 rows\n. . imported "OWNER"."BRL"                     709.0 KB    8864 rows\n. . imported "OWNER"."BS"                      625.4 KB    7485 rows\n. . imported "OWNER"."RLH"                     504.6 KB    8974 rows\n. . imported "OWNER"."RSR"                     109.4 KB     691 rows\n. . imported "OWNER"."CFS"                     107.2 KB     156 rows\n. . imported "OWNER"."AL"                      36.96 KB     123 rows\n. . imported "OWNER"."BCF"                     54.84 KB     616 rows\n. . imported "OWNER"."BSF"                     62.14 KB    1091 rows\n. . imported "OWNER"."CKP"                     8.242 KB       9 rows\n. . imported "OWNER"."CONF"                    6.976 KB       3 rows\n. . imported "OWNER"."CONFIG"                  5.257 KB       1 rows\n. . imported "OWNER"."DB"                      6.203 KB       2 rows\n. . imported "OWNER"."DBINC"                   7.242 KB       4 rows\n. . imported "OWNER"."DF"                      19.71 KB      49 rows\n. . imported "OWNER"."NODE"                    18.68 KB       2 rows\n. . imported "OWNER"."OFFR"                    9.648 KB      34 rows\n. . imported "OWNER"."ORL"                     8.843 KB      26 rows\n. . imported "OWNER"."PDB"                     7.812 KB       2 rows\n. . imported "OWNER"."PDBINC"                    7.5 KB       2 rows\n. . imported "OWNER"."PDB_DBINC"               6.242 KB       4 rows\n. . imported "OWNER"."RCVER"                   4.953 KB       1 rows\n. . imported "OWNER"."RT"                      7.210 KB       4 rows\n. . imported "OWNER"."SITE_DFATT"              8.664 KB      49 rows\n. . imported "OWNER"."SITE_TFATT"              8.046 KB       8 rows\n. . imported "OWNER"."TF"                      8.781 KB       8 rows\n. . imported "OWNER"."TS"                      11.87 KB      55 rows\n. . imported "OWNER"."TSATT"                   8.867 KB      55 rows\n. . imported "OWNER"."BCB"                         0 KB       0 rows\n. . imported "OWNER"."BCR"                         0 KB       0 rows\n. . imported "OWNER"."CCB"                         0 KB       0 rows\n. . imported "OWNER"."CCF"                         0 KB       0 rows\n. . imported "OWNER"."CDF"                         0 KB       0 rows\n. . imported "OWNER"."DELETED_OBJECT"              0 KB       0 rows\n. . imported "OWNER"."DO_SEQ"                      0 KB       0 rows\n. . imported "OWNER"."FB"                          0 KB       0 rows\n. . imported "OWNER"."GRSP"                        0 KB       0 rows\n. . imported "OWNER"."NRSP"                        0 KB       0 rows\n. . imported "OWNER"."ORSEVENT"                    0 KB       0 rows\n. . imported "OWNER"."RCFILE"                      0 KB       0 rows\n. . imported "OWNER"."RR"                          0 KB       0 rows\n. . imported "OWNER"."RRCACHE"                     0 KB       0 rows\n. . imported "OWNER"."SBT_TEMPLATE_DB"             0 KB       0 rows\n. . imported "OWNER"."SCR"                         0 KB       0 rows\n. . imported "OWNER"."SCRL"                        0 KB       0 rows\n. . imported "OWNER"."SERVER"                      0 KB       0 rows\n. . imported "OWNER"."TEMPRES"                     0 KB       0 rows\n. . imported "OWNER"."VPC_DATABASES"               0 KB       0 rows\n. . imported "OWNER"."VPC_USERS"                   0 KB       0 rows\n. . imported "OWNER"."WATERMARKS"                  0 KB       0 rows\n. . imported "OWNER"."XAL"                         0 KB       0 rows\n. . imported "OWNER"."XCF"                         0 KB       0 rows\n. . imported "OWNER"."XDF"                         0 KB       0 rows\n. . imported "OWNER"."XMLSTORE"                    0 KB       0 rows\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/INDEX\nProcessing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/CONSTRAINT\nProcessing object type SCHEMA_EXPORT\/PACKAGE\/PACKAGE_SPEC\nProcessing object type SCHEMA_EXPORT\/PACKAGE\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nProcessing object type SCHEMA_EXPORT\/FUNCTION\/FUNCTION\nProcessing object type SCHEMA_EXPORT\/FUNCTION\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nProcessing object type SCHEMA_EXPORT\/PACKAGE\/COMPILE_PACKAGE\/PACKAGE_SPEC\/ALTER_PACKAGE_SPEC\nProcessing object type SCHEMA_EXPORT\/FUNCTION\/ALTER_FUNCTION\nProcessing object type SCHEMA_EXPORT\/VIEW\/VIEW\nProcessing object type SCHEMA_EXPORT\/PACKAGE\/PACKAGE_BODY\nProcessing object type SCHEMA_EXPORT\/TYPE\/TYPE_BODY\nORA-39082: Object type TYPE_BODY:"OWNER"."RC_LBRECSETIMPL_T" created with compilation warnings\n \nORA-39082: Object type TYPE_BODY:"OWNER"."RC_LBRECSETIMPL_T" created with compilation warnings\n \nProcessing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/REF_CONSTRAINT\nProcessing object type SCHEMA_EXPORT\/TABLE\/TRIGGER\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/FUNCTIONAL_AND_BITMAP\/INDEX\nORA-39082: Object type VIEW:"OWNER"."RC_RMAN_BACKUP_SUBJOB_DETAILS" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_RMAN_BACKUP_JOB_DETAILS" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_SET_DETAILS" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_PIECE_DETAILS" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_COPY_DETAILS" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_PROXY_COPY_DETAILS" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_PROXY_ARCHIVELOG_DETAILS" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_DATAFILE_DETAILS" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_CONTROLFILE_DETAILS" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_ARCHIVELOG_DETAILS" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_SPFILE_DETAILS" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_SET_SUMMARY" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_DATAFILE_SUMMARY" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_CONTROLFILE_SUMMARY" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_ARCHIVELOG_SUMMARY" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_SPFILE_SUMMARY" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_BACKUP_COPY_SUMMARY" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_PROXY_COPY_SUMMARY" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_PROXY_ARCHIVELOG_SUMMARY" created with compilation warnings\n \nORA-39082: Object type VIEW:"OWNER"."RC_UNUSABLE_BACKUPFILE_DETAILS" created with compilation warnings\n \nJob "SYSTEM"."SYS_IMPORT_FULL_01" completed with 23 error(s) at Thu Aug 20 08:43:51 2020 elapsed 0 00:01:25\n \n[user@hostname_novo EXP]$\n<\/pre><\/div>\n\n\n
Uma vez importado no novo banco de cat\u00e1logo 12C, posso proceder com o upgrade catalog:<\/p>\n\n\n
\n[user@hostname ~]$ rman target \/ catalog OWNER\/****@CAT12C\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Thu Aug 20 08:44:35 2020\nVersion 18.5.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n \nconnected to target database: TESTE (DBID=3671898123)\nconnected to recovery catalog database\nrecovery catalog is partially upgraded to 18.05.00.00\n \nRMAN> upgrade catalog;\n \nOracle error from recovery catalog database: ORA-06550: line 1, column 41:\nPLS-00201: identifier 'DBMS_RCVMAN.GETPACKAGEVERSION' must be declared\nORA-06550: line 1, column 34:\nPL\/SQL: Statement ignored\n \nrecovery catalog owner is OWNER\nenter UPGRADE CATALOG command again to confirm catalog upgrade\n \nRMAN> upgrade catalog;\n \nrecovery catalog is partially upgraded to 18.05.00.00\nrecovery catalog upgraded to version 18.05.00.00.00\nDBMS_RCVMAN package upgraded to version 18.05.00.00\nDBMS_RCVCAT package upgraded to version 18.05.00.00.\n \nRMAN>\n<\/pre><\/div>\n\n\n
Realizando o register do database e validando se o comando report schema lista todos os arquivos do banco:<\/p>\n\n\n
\n[user@hostname folder]$ rman target \/ catalog OWNER\/****@CAT12C\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Thu Aug 20 08:48:14 2020\nVersion 18.5.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n \nconnected to target database: TESTE (DBID=3671898123)\nconnected to recovery catalog database\n \nRMAN> report schema;\n \nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of report command at 08\/20\/2020 08:48:23\nRMAN-06004: Oracle error from recovery catalog database: RMAN-20001: target database not found in recovery catalog\n \nRMAN> register database;\n \ndatabase registered in recovery catalog\nstarting full resync of recovery catalog\nfull resync complete\n \nRMAN> report schema;\n \nReport of database schema for database with db_unique_name TESTE\n \nList of Permanent Datafiles\n===========================\nFile Size(MB) Tablespace           RB segs Datafile Name\n---- -------- -------------------- ------- ------------------------\n1    960      SYSTEM               YES     +DISK_TESTE\/TESTE\/DATAFILE\/system.256.100521234\n2    5790     SYSAUX               NO      +DISK_TESTE\/TESTE\/DATAFILE\/sysaux.257.100546742\n3    544      UNDOTBS1             YES     +DISK_TESTE\/TESTE\/DATAFILE\/undotbs1.257.10052747473\n4    1568     UNDOTBS2             YES     +DISK_TESTE\/TESTE\/DATAFILE\/undotbs2.259.100247447\n5    5        USERS                NO      +DISK_TESTE\/TESTE\/DATAFILE\/users.258.102572474\n6    1050     OWNER_MDS            NO      +DISK_TESTE\/TESTE\/DATAFILE\/owner_mds.261.10027554754\n7    60       OWNER_IAU            NO      +DISK_TESTE\/TESTE\/DATAFILE\/owner_iau.262.10063673467\n8    130      OWNER_IAS_UMS        NO      +DISK_TESTE\/TESTE\/DATAFILE\/owner_ias_ums.263.100644564\n9    60       OWNER_WLS            NO      +DISK_TESTE\/TESTE\/DATAFILE\/owner_wls.264.10063467467\n10   10       OWNER_STB            NO      +DISK_TESTE\/TESTE\/DATAFILE\/owner_stb.265.100675344574\n11   100      OWNER_ESS            NO      +DISK_TESTE\/TESTE\/DATAFILE\/owner_ess.266.1006247257\n12   120      OWNER_IAS_OPSS       NO      +DISK_TESTE\/TESTE\/DATAFILE\/owner_ias_opss.267.100257247247\n13   5250     OWNER_SSS            NO      +DISK_TESTE\/TESTE\/DATAFILE\/owner_sss.268.100257247547\n14   240      OWNER_APP            NO      +DISK_TESTE\/TESTE\/DATAFILE\/owner_app.259.10053257457574\n15   20       OWNER_AUDIT          NO      +DISK_TESTE\/TESTE\/DATAFILE\/owner_audit.260.10257247247\n \nList of Temporary Files\n=======================\nFile Size(MB) Tablespace           Maxsize(MB) Tempfile Name\n---- -------- -------------------- ----------- --------------------\n1    1024     TEMP                 10240       +DISK_TESTE\/TESTE\/TEMPFILE\/temp.258.100457435747\n2    100      OWNER_IAS_TEMP      32767       +DISK_TESTE\/TESTE\/TEMPFILE\/owner_ias_temp.261.1275457275427\n \nRMAN>\n<\/pre><\/div>\n\n\n
A partir disso, \u00e9 poss\u00edvel ver que n\u00e3o h\u00e1 mais objetos inv\u00e1lidos no owner do cat\u00e1logo do rman do banco 12C, por conta do upgrade bem sucedido. Al\u00e9m disso, os backups s\u00e3o realizado com sucesso.<\/p>\n\n\n
\n...\nchannel CANAL1: backup set complete, elapsed time: 00:00:35\nFinished backup at 27-AUG-20\n...\nStarting Control File and SPFILE Autobackup at 27-AUG-20\npiece handle=c-3671898825-20200827-0b comment=API Version 2.0,MMS Version 5.0.0.0\nFinished Control File and SPFILE Autobackup at 27-AUG-20\n...\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
Ao tentar executar um backup de um banco recentemente atualizado para 18C, recebi a seguinte mensagem: Encontrei o Oracle note “RMAN-06429: RCVCAT database is not compatible with this version of RMAN (Doc ID 2022782.1)“. Nesta nota, \u00e9 indicado a necessidade de se realizar um “UPGRADE CATALOG”. O detalhe \u00e9 que o meu banco de cat\u00e1logo […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1837","post","type-post","status-publish","format-standard","hentry","category-backup-recovery"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1837","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=1837"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1837\/revisions"}],"predecessor-version":[{"id":9285,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1837\/revisions\/9285"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}