{"id":3087,"date":"2021-03-24T07:43:47","date_gmt":"2021-03-24T07:43:47","guid":{"rendered":"https:\/\/swiv.com.br\/solved-issue-pl-sql-package-sys-dbms_backup_restore-version-18-03-00-00-in-target-database-is-not-current\/"},"modified":"2026-05-27T20:02:49","modified_gmt":"2026-05-27T19:02:49","slug":"solved-issue-pl-sql-package-sys-dbms_backup_restore-version-18-03-00-00-in-target-database-is-not-current","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/03\/24\/solved-issue-pl-sql-package-sys-dbms_backup_restore-version-18-03-00-00-in-target-database-is-not-current\/","title":{"rendered":"[Solved] Issue: PL\/SQL package SYS.DBMS_BACKUP_RESTORE version 18.03.00.00 in TARGET database is not current"},"content":{"rendered":"\n<p>Recentemente apliquei um PSU ao meu banco de laborat\u00f3rio 18C, e no momento que logo no RMAN, a mensagem abaixo \u00e9 reportada:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Wed Mar 24 04:29:41 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n \nPL\/SQL package SYS.DBMS_BACKUP_RESTORE version 18.03.00.00 in TARGET database is not current\nPL\/SQL package SYS.DBMS_RCVMAN version 18.03.00.00 in TARGET database is not current\nconnected to target database: RMANDB (DBID=3825250984)\n \nRMAN&gt; exit\n \n \nRecovery Manager complete.\n<\/pre><\/div>\n\n\n<p>\u00c9 poss\u00edvel notarmos que o RMAN ainda est\u00e1 trabalhando na 18.03, sendo que o database est\u00e1 na 18.13:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 OPatch]$ pwd\n\/oracle\/18.0.0\/product\/OPatch\n&#x5B;oracle@oel8 OPatch]$ .\/opatch lsinventory | grep escript\nARU platform description:: Linux x86-64\nPatch description:  &quot;Database Release Update : 18.13.0.0.210119 (32204699)&quot;\nPatch description:  &quot;OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)&quot;\nPatch description:  &quot;OCW RELEASE UPDATE 18.3.0.0.0 (28090553)&quot;\n<\/pre><\/div>\n\n<p>Apesar da nota &#8220;<strong>PL\/SQL package SYS.DBMS_BACKUP_RESTORE Version is Not Current (Doc ID 2741760.1)<\/strong>&#8221; ser da 19C para cima, o conceito para recompilar os objetos do RMAN e seu upgrade s\u00e3o os mesmos. Link <a rel=\"\\&quot;noreferrer noopener\" noopener=\"\" href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?_afrLoop=386138389472129&amp;id=2741760.1&amp;displayIndex=2&amp;_afrWindowMode=0&amp;_adf.ctrl-state=16lfe7y04_4#FIX\" target=\"\\&quot;_blank\\&quot;\">AQUI<\/a>.<\/p>\n\n\n<p>Iniciando processo descrito na nota que se resume em:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sqlplus \/ as sysdba\n \nSQL&gt; @$ORACLE_HOME\/rdbms\/admin\/dbmsrman.sql\nSQL&gt; @$ORACLE_HOME\/rdbms\/admin\/dbmsbkrs.sql\nSQL&gt; @$ORACLE_HOME\/rdbms\/admin\/prvtrmns.plb\nSQL&gt; @$ORACLE_HOME\/rdbms\/admin\/prvtbkrs.plb\n<\/pre><\/div>\n\n\n<p>Execu\u00e7\u00e3o:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 OPatch]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Wed Mar 24 04:39:07 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.13.0.0.0\n \nSQL&gt; @$ORACLE_HOME\/rdbms\/admin\/dbmsrman.sql\n \nSession altered.\n \n \nPackage created.\n \n \nPL\/SQL procedure successfully completed.\n \n \nPL\/SQL procedure successfully completed.\n \n \nPL\/SQL procedure successfully completed.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nPL\/SQL procedure successfully completed.\n \n \nSynonym dropped.\n \n \nView dropped.\n \n \nFunction dropped.\n \n \nType dropped.\n \n \nType dropped.\n \n \nType dropped.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType body created.\n \n \nFunction created.\n \n \nView created.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nSynonym dropped.\n \n \nView dropped.\n \n \nSynonym dropped.\n \n \nView dropped.\n \n \nSynonym dropped.\n \n \nView dropped.\n \n \nFunction dropped.\n \n \nType dropped.\n \n \nType dropped.\n \n \nType dropped.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType body created.\n \n \nFunction created.\n \n \nView created.\n \n \nView created.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nView created.\n \n \nView created.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nView created.\n \n \nView created.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nSession altered.\n \nSQL&gt;\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; @$ORACLE_HOME\/rdbms\/admin\/dbmsbkrs.sql\n \nSession altered.\n \n \nPackage created.\n \n \nSession altered.\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; @$ORACLE_HOME\/rdbms\/admin\/prvtrmns.plb\n \nSession altered.\n \n \nPackage body created.\n \n \nSession altered.\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; @$ORACLE_HOME\/rdbms\/admin\/prvtbkrs.plb\n \nSession altered.\n \n \nPackage body created.\n \n \nSession altered.\n<\/pre><\/div>\n\n\n<p>Item resolvido com sucesso:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 OPatch]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Wed Mar 24 04:42:17 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n \nconnected to target database: RMANDB (DBID=3825250984)\n \nRMAN&gt;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Recentemente apliquei um PSU ao meu banco de laborat\u00f3rio 18C, e no momento que logo no RMAN, a mensagem abaixo \u00e9 reportada: \u00c9 poss\u00edvel notarmos que o RMAN ainda est\u00e1 trabalhando na 18.03, sendo que o database est\u00e1 na 18.13: Apesar da nota &#8220;PL\/SQL package SYS.DBMS_BACKUP_RESTORE Version is Not Current (Doc ID 2741760.1)&#8221; ser da [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3],"tags":[],"class_list":["post-3087","post","type-post","status-publish","format-standard","hentry","category-administration","category-backup-recovery"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3087","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=3087"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3087\/revisions"}],"predecessor-version":[{"id":9207,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3087\/revisions\/9207"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=3087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=3087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=3087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}