{"id":14689,"date":"2021-10-01T00:55:40","date_gmt":"2021-10-01T03:55:40","guid":{"rendered":"https:\/\/www.dbarj.com.br\/?p=14689"},"modified":"2021-10-01T09:11:55","modified_gmt":"2021-10-01T12:11:55","slug":"how-to-upgrade-and-downgrade-oracle-database-18c-to-19c","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/","title":{"rendered":"How to upgrade and downgrade Oracle Database 18c to 19c"},"content":{"rendered":"<p>Today my experiment will be upgrading 18c (18.14) to the latest 19c version (currently it is 19.12) in multitenant architecture with 2 PDBs. The idea of this scenario is to validate and test not only the upgrade process but especially the downgrade strategy.<\/p>\n<p id=\"BDVSdKq\"><img loading=\"lazy\" decoding=\"async\" width=\"1544\" height=\"558\" class=\"alignnone size-full wp-image-14692 \" src=\"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_61560ed65bf64.png\" alt=\"\" srcset=\"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_61560ed65bf64.png 1544w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_61560ed65bf64-300x108.png 300w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_61560ed65bf64-1024x370.png 1024w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_61560ed65bf64-768x278.png 768w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_61560ed65bf64-1536x555.png 1536w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_61560ed65bf64-870x314.png 870w\" sizes=\"auto, (max-width: 1544px) 100vw, 1544px\" \/><\/p>\n<p>Please note I will keep the COMPATIBLE parameter of my target 19c as 18.0.0 so I can try my fallback strategy without any issues.<\/p>\n<p><strong>My playground will be:<\/strong><\/p>\n<ul>\n<li><strong>Source DB (18.14.0):<\/strong>\n<ul>\n<li>Running on server odbfcl-18-0-0-0<\/li>\n<li>18.14 RU<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">dbca -silent -createDatabase \\\r\n-gdbName orcl \\\r\n-templateName General_Purpose.dbc \\\r\n-characterSet AL32UTF8 \\\r\n-createAsContainerDatabase true \\\r\n-numberOfPDBs 1 \\\r\n-pdbAdminPassword \"Rodrigo.123\" \\\r\n-pdbName PDB01 \\\r\n-useLocalUndoForPDBs true \\\r\n-databaseConfigType SINGLE \\\r\n-databaseType MULTIPURPOSE \\\r\n-datafileDestination \/u01\/app\/oradata \\\r\n-dvConfiguration false \\\r\n-emConfiguration NONE \\\r\n-enableArchive false \\\r\n-memoryMgmtType AUTO_SGA \\\r\n-totalMemory 4000 \\\r\n-nationalCharacterSet AL16UTF16 \\\r\n-olsConfiguration false \\\r\n-recoveryAreaDestination \/u01\/app\/fra \\\r\n-sampleSchema false \\\r\n-sid orcl \\\r\n-storageType FS \\\r\n-useOMF false \\\r\n-sysPassword \"Rodrigo.123\" \\\r\n-systemPassword \"Rodrigo.123\"<\/pre>\n<ul>\n<li><strong>Target DB (19.12.0):<\/strong>\n<ul>\n<li>Running on server odbfcl-19-0-0-0<\/li>\n<li>19.12 RU<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h4><span style=\"text-decoration: underline;\">Preparing my source environment<\/span><\/h4>\n<p>In my 18c CDB source system, I will create a new PDB and some user data, so I can check them later after the migration.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-18-0-0-0 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 18.0.0.0.0 - Production on Thu Sep 30 19:33:19 2021\r\nVersion 18.14.0.0.0\r\n\r\nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\r\nVersion 18.14.0.0.0\r\n\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 PDB01                          READ WRITE NO\r\n\r\nSQL&gt; CREATE PLUGGABLE DATABASE PDB02 ADMIN USER PDBADMIN IDENTIFIED BY \"Rodrigo.123\" file_name_convert=('\/u01\/app\/oradata\/ORCL\/pdbseed\/','\/u01\/app\/oradata\/ORCL\/PDB02\/');\r\n\r\nPluggable database created.\r\n\r\nSQL&gt; ALTER PLUGGABLE DATABASE PDB02 OPEN;\r\n\r\nPluggable database altered.\r\n\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 PDB01                          READ WRITE NO\r\n         4 PDB02                          READ WRITE NO\r\n\r\nSQL&gt; alter session set container=PDB01;\r\n\r\nSession altered.\r\n\r\nSQL&gt; CREATE USER TEST IDENTIFIED BY \"oracle\";\r\n\r\nUser created.\r\n\r\nSQL&gt; GRANT DBA TO TEST;\r\n\r\nGrant succeeded.\r\n\r\nSQL&gt; select file_name from dba_data_files;\r\n\r\nFILE_NAME\r\n--------------------------------------------------------------------------------\r\n\/u01\/app\/oradata\/ORCL\/PDB01\/undotbs01.dbf\r\n\/u01\/app\/oradata\/ORCL\/PDB01\/sysaux01.dbf\r\n\/u01\/app\/oradata\/ORCL\/PDB01\/system01.dbf\r\n\/u01\/app\/oradata\/ORCL\/PDB01\/users01.dbf\r\n\r\nSQL&gt; CREATE TABLESPACE TOOLS DATAFILE '\/u01\/app\/oradata\/ORCL\/PDB01\/tools01.dbf' size 10M;\r\n\r\nTablespace created.\r\n\r\nSQL&gt; CREATE TABLE TEST.T1 TABLESPACE TOOLS AS SELECT * FROM DBA_TABLES;\r\n\r\nTable created.\r\n\r\nSQL&gt; select count(*) from TEST.T1;\r\n\r\n  COUNT(*)\r\n----------\r\n      2134\r\n\r\nSQL&gt;<\/pre>\n<h4><span style=\"text-decoration: underline;\">Upgrading first<\/span><\/h4>\n<p>The first step is to perform the upgrade of the 18c. I will use AutoUpgrade as it automates most of the tasks for me.<\/p>\n<p>My config file has:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">global.autoupg_log_dir=\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\r\nupg1.log_dir=\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/18c\r\nupg1.sid=orcl\r\nupg1.source_home=\/u01\/app\/oracle\/product\/18.0.0.0\/dbhome_1\r\nupg1.target_home=\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\r\nupg1.target_version=19\r\nupg1.upgrade_node=localhost\r\nupg1.run_utlrp=yes\r\nupg1.timezone_upg=no<\/pre>\n<p>As I&#8217;m also moving to a new server, I will break the <strong>AutoUpgrade<\/strong> in the <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/upgrd\/examples-of-autoupgrade-workflows.html#GUID-04742E36-180F-4BEA-B693-9F4ED6A2073D\" target=\"_blank\" rel=\"noopener\">3 steps approach<\/a>. Please note you don&#8217;t need to break it in 3 phases if you have the new Oracle Home version already deployed on that same server.<\/p>\n<p>So first, let me start with the <strong>analyse<\/strong> phase:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-18-0-0-0 ~]$ $ORACLE_HOME\/jdk\/bin\/java -jar autoupgrade.jar -config .\/upgrade.cfg -mode analyze\r\nAutoUpgrade 21.2.210721 launched with default options\r\nProcessing config file ...\r\n+--------------------------------+\r\n| Starting AutoUpgrade execution |\r\n+--------------------------------+\r\n1 databases will be analyzed\r\nType 'help' to list console commands\r\nupg&gt; Job 101 completed\r\n------------------- Final Summary --------------------\r\nNumber of databases            [ 1 ]\r\n\r\nJobs finished                  [1]\r\nJobs failed                    [0]\r\nJobs pending                   [0]\r\n------------- JOBS FINISHED WITH ERROR -------------\r\nJob 101 for orcl\r\n\r\nPlease check the summary report at:\r\n\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.html\r\n\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.log\r\n<\/pre>\n<p>Next, the <strong>fixups<\/strong>:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-18-0-0-0 ~]$ $ORACLE_HOME\/jdk\/bin\/java -jar autoupgrade.jar -config .\/upgrade.cfg -mode fixups\r\nAutoUpgrade 21.2.210721 launched with default options\r\nProcessing config file ...\r\n+--------------------------------+\r\n| Starting AutoUpgrade execution |\r\n+--------------------------------+\r\n1 databases will be processed\r\nType 'help' to list console commands\r\nupg&gt; Job 102 completed\r\n------------------- Final Summary --------------------\r\nNumber of databases            [ 1 ]\r\n\r\nJobs finished                  [1]\r\nJobs failed                    [0]\r\nJobs pending                   [0]\r\n------------- JOBS FINISHED WITH ERROR -------------\r\nJob 102 for orcl\r\n\r\nPlease check the summary report at:\r\n\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.html\r\n\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.log<\/pre>\n<p>The next step is to stop the database and move all the database and configuration files (including datafiles, controlfiles, spfile, pwfile) and also the files generated by AutoUpgrade tool (<em>upgrade.cfg<\/em> and <em>\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/<\/em> folder) to the new server. Note again you won&#8217;t need this if you are upgrading to the same server.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-18-0-0-0 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 18.0.0.0.0 - Production on Thu Sep 30 20:12:27 2021\r\nVersion 18.14.0.0.0\r\n\r\nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\r\nVersion 18.14.0.0.0\r\n\r\nSQL&gt; shut immediate;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\n\r\nSQL&gt; exit\r\nDisconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\r\nVersion 18.14.0.0.0<\/pre>\n<p>After everything is placed, I need to start up the database in 19c Oracle Home in upgrade mode:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-19-0-0-0 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 30 20:30:25 2021\r\nVersion 19.12.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL&gt; startup upgrade;\r\nORACLE instance started.\r\n\r\nTotal System Global Area 3154114080 bytes\r\nFixed Size\t\t    9139744 bytes\r\nVariable Size\t\t  754974720 bytes\r\nDatabase Buffers\t 2382364672 bytes\r\nRedo Buffers\t\t    7634944 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\n\r\nSQL&gt; exit;\r\nDisconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.12.0.0.0<\/pre>\n<p>And finally, I will call the <strong>upgrade<\/strong> phase of AutoUpgrade on the target machine:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-19-0-0-0 ~]$ $ORACLE_HOME\/jdk\/bin\/java -jar autoupgrade.jar -config .\/upgrade.cfg -mode upgrade\r\nAutoUpgrade 21.2.210721 launched with default options\r\nProcessing config file ...\r\n+--------------------------------+\r\n| Starting AutoUpgrade execution |\r\n+--------------------------------+\r\n1 databases will be processed\r\nType 'help' to list console commands\r\nupg&gt; Job 103 completed\r\n------------------- Final Summary --------------------\r\nNumber of databases            [ 1 ]\r\n\r\nJobs finished                  [1]\r\nJobs failed                    [0]\r\nJobs pending                   [0]\r\n\r\nPlease check the summary report at:\r\n\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.html\r\n\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.log<\/pre>\n<p>Now just checking if my database was really upgraded:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-19-0-0-0 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 1 00:14:27 2021\r\nVersion 19.12.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.12.0.0.0\r\n\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 PDB01                          READ WRITE NO\r\n         4 PDB02                          READ WRITE NO\r\n\r\nSQL&gt; alter session set container=PDB01;\r\n\r\nSession altered.\r\n\r\nSQL&gt; select count(*) from TEST.T1;\r\n\r\n  COUNT(*)\r\n----------\r\n      2134\r\n\r\nSQL&gt; select cname, prv_version, version from registry$;\r\n\r\nCNAME                                              PRV_VERSION                    VERSION\r\n-------------------------------------------------- ------------------------------ ------------------------------\r\nOracle Database Catalog Views                      18.0.0.0.0                     19.0.0.0.0\r\nOracle Database Packages and Types                 18.0.0.0.0                     19.0.0.0.0\r\nOracle XML Database                                18.0.0.0.0                     19.0.0.0.0\r\nOracle Real Application Clusters                   18.0.0.0.0                     19.0.0.0.0\r\nOracle Workspace Manager                           18.0.0.0.0                     19.0.0.0.0\r\nJServer JAVA Virtual Machine                       18.0.0.0.0                     19.0.0.0.0\r\nOracle XDK                                         18.0.0.0.0                     19.0.0.0.0\r\nOracle Database Java Packages                      18.0.0.0.0                     19.0.0.0.0\r\nOracle Text                                        18.0.0.0.0                     19.0.0.0.0\r\nOracle Multimedia                                  18.0.0.0.0                     19.0.0.0.0\r\nOLAP Analytic Workspace                            18.0.0.0.0                     19.0.0.0.0\r\nOracle OLAP API                                    18.0.0.0.0                     19.0.0.0.0\r\nSpatial                                            18.0.0.0.0                     19.0.0.0.0\r\nOracle Label Security                              18.0.0.0.0                     19.0.0.0.0\r\nOracle Database Vault                              18.0.0.0.0                     19.0.0.0.0\r\n\r\n15 rows selected.\r\n\r\nSQL&gt; show parameter compatible\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ncompatible                           string      18.0.0\r\nnoncdb_compatible                    boolean     FALSE<\/pre>\n<h4><span style=\"text-decoration: underline;\">Downgrade<\/span><\/h4>\n<p>Now that I&#8217;m on 19c, let&#8217;s imagine a fallback scenario. After running my production in this environment for some time, I want to move back to the original 18c database. I can&#8217;t simply restore a backup as I already had some production workload executed in this new database. So a downgrade is the only option I have.<\/p>\n<p>Let&#8217;s start the downgrading process. I followed the <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/upgrd\/downgrading-oracle-db-after-upgrade.html#GUID-EAF290FD-5F22-4FEE-829D-B3587168471F\" target=\"_blank\" rel=\"noopener\">official documentation<\/a> but there is also a <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=2548962.1\" target=\"_blank\" rel=\"noopener\">MOS Note<\/a> for it.<\/p>\n<p>The overall steps are:<\/p>\n<ul>\n<li>Taking a backup of my CDB before starting.<\/li>\n<li>Cleaning out the UNIFIED_AUDIT_TRAIL.<\/li>\n<li>Starting CDB in downgrade mode.<\/li>\n<li>Calling DB downgrade\n<ul>\n<li><strong>$ORACLE_HOME\/bin\/dbdowngrade<br \/>\n<\/strong><\/li>\n<\/ul>\n<\/li>\n<li>Startup the database in the original Oracle Home<\/li>\n<li>Run catrelod.sql<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>First, I need to clean (or backup) the UNIFIED_AUDIT_TRAIL in all the containers:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-19-0-0-0 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 1 01:40:25 2021\r\nVersion 19.12.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.12.0.0.0\r\n\r\nSQL&gt; select count(*) from UNIFIED_AUDIT_TRAIL;\r\n\r\n  COUNT(*)\r\n----------\r\n      2091\r\n\r\nSQL&gt; EXEC DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(audit_trail_type =&gt; DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, use_last_arch_timestamp =&gt; FALSE);\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL&gt; alter session set container=PDB01;\r\n\r\nSession altered.\r\n\r\nSQL&gt; select count(*) from UNIFIED_AUDIT_TRAIL;\r\n\r\n  COUNT(*)\r\n----------\r\n      1056\r\n\r\nSQL&gt; EXEC DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(audit_trail_type =&gt; DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, use_last_arch_timestamp =&gt; FALSE);\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL&gt; alter session set container=PDB02;\r\n\r\nSession altered.\r\n\r\nSQL&gt; select count(*) from UNIFIED_AUDIT_TRAIL;\r\n\r\n  COUNT(*)\r\n----------\r\n      1031\r\n\r\nSQL&gt; EXEC DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(audit_trail_type =&gt; DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, use_last_arch_timestamp =&gt; FALSE);\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL&gt; alter session set container=PDB$SEED;\r\n\r\nSession altered.\r\n\r\nSQL&gt; select count(*) from UNIFIED_AUDIT_TRAIL;\r\n\r\n  COUNT(*)\r\n----------\r\n      1035\r\n\r\nSQL&gt; EXEC DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(audit_trail_type =&gt; DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, use_last_arch_timestamp =&gt; FALSE);\r\n\r\nPL\/SQL procedure successfully completed.<\/pre>\n<p>The next step is to start up the database in downgrade mode:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-19-0-0-0 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 1 02:36:01 2021\r\nVersion 19.12.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL&gt; startup downgrade;\r\nORACLE instance started.\r\n\r\nTotal System Global Area 3154114080 bytes\r\nFixed Size\t\t    9139744 bytes\r\nVariable Size\t\t  637534208 bytes\r\nDatabase Buffers\t 2499805184 bytes\r\nRedo Buffers\t\t    7634944 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\n\r\nSQL&gt; alter pluggable database all open downgrade;\r\n\r\nPluggable database altered.\r\n\r\nSQL&gt; show pdbs;\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       MIGRATE    YES\r\n         3 PDB01                          MIGRATE    YES\r\n         4 PDB02                          MIGRATE    YES<\/pre>\n<p>Finally, calling the <em><strong>$ORACLE_HOME\/bin\/dbdowngrade<\/strong><\/em> wrapper:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-19-0-0-0 ~]$ sh $ORACLE_HOME\/bin\/dbdowngrade\r\nDowngrading containers\r\ncatcon::set_log_file_base_path: ALL catcon-related output will be written to [\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/downgrade\/catdwgrd_catcon_21426.lst]\r\n\r\ncatcon::set_log_file_base_path: catcon: See [\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/downgrade\/catdwgrd*.log] files for output generated by scripts\r\n\r\ncatcon::set_log_file_base_path: catcon: See [\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/downgrade\/catdwgrd_*.lst] files for spool files, if any\r\n\r\ncatcon.pl: completed successfully\r\n[oracle@odbfcl-19-0-0-0 ~]$ grep '^ORA-' \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/downgrade\/catdwgrd*.log\r\n[oracle@odbfcl-19-0-0-0 ~]$<\/pre>\n<p>As you can see above. No errors were returned.<\/p>\n<p>Finally, the last step is to start back the database on the original 18c Oracle Home in upgrade mode. In my case, I had to move back all the database and configuration files (including datafiles, controlfiles, spfile, pwfile) to the original system.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-18-0-0-0 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 18.0.0.0.0 - Production on Fri Oct 1 02:44:12 2021\r\nVersion 18.14.0.0.0\r\n\r\nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL&gt; startup upgrade;\r\nORACLE instance started.\r\n\r\nTotal System Global Area 3154112808 bytes\r\nFixed Size\t\t    8900904 bytes\r\nVariable Size\t\t  771751936 bytes\r\nDatabase Buffers\t 2365587456 bytes\r\nRedo Buffers\t\t    7872512 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\n\r\nSQL&gt; alter pluggable database all open upgrade;\r\n\r\nPluggable database altered.\r\n\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       MIGRATE    YES\r\n         3 PDB01                          MIGRATE    YES\r\n         4 PDB02                          MIGRATE    YES\r\n\r\nSQL&gt; exit\r\nDisconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\r\nVersion 18.14.0.0.0\r\n[oracle@odbfcl-18-0-0-0 ~]$<\/pre>\n<p>And the last step is to run <em><strong>catrelod.sql<\/strong><\/em>, to recreate the database objects for the 18c version:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-18-0-0-0 ~]$ $ORACLE_HOME\/perl\/bin\/perl $ORACLE_HOME\/rdbms\/admin\/catcon.pl -n 1 -e -b catrelod -d $ORACLE_HOME\/rdbms\/admin catrelod.sql\r\ncatcon::set_log_file_base_path: ALL catcon-related output will be written to [\/home\/oracle\/catrelod_catcon_27176.lst]\r\n\r\ncatcon::set_log_file_base_path: catcon: See [\/home\/oracle\/catrelod*.log] files for output generated by scripts\r\n\r\ncatcon::set_log_file_base_path: catcon: See [\/home\/oracle\/catrelod_*.lst] files for spool files, if any\r\n\r\ncatcon.pl: completed successfully\r\n[oracle@odbfcl-18-0-0-0 ~]$ grep '^ORA-' \/home\/oracle\/catrelod*.log\r\n[oracle@odbfcl-18-0-0-0 ~]$<\/pre>\n<p>Now I&#8217;m with my CDB is back in 18c:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-18-0-0-0 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 18.0.0.0.0 - Production on Fri Oct 1 03:37:45 2021\r\nVersion 18.14.0.0.0\r\n\r\nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\r\nVersion 18.14.0.0.0\r\n\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       MIGRATE    YES\r\n         3 PDB01                          MIGRATE    YES\r\n         4 PDB02                          MIGRATE    YES\r\n\r\nSQL&gt; shut immediate;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\n\r\nSQL&gt; startup;\r\nORACLE instance started.\r\n\r\nTotal System Global Area 3154112808 bytes\r\nFixed Size\t\t    8900904 bytes\r\nVariable Size\t\t  771751936 bytes\r\nDatabase Buffers\t 2365587456 bytes\r\nRedo Buffers\t\t    7872512 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\n\r\nSQL&gt; alter pluggable database all open;\r\n\r\nPluggable database altered.\r\n\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 PDB01                          READ WRITE NO\r\n         4 PDB02                          READ WRITE NO\r\n\r\nSQL&gt; alter session set container=PDB01;\r\n\r\nSession altered.\r\n\r\nSQL&gt; select count(*) from TEST.T1;\r\n\r\n  COUNT(*)\r\n----------\r\n      2134\r\n\r\nSQL&gt; exit\r\nDisconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\r\nVersion 18.14.0.0.0<\/pre>\n<p>And that&#8217;s it! As you can see, there is no mystery about moving forward and back from 19c to 18c.<\/p>\n<b>Have you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-14689 jlk' href='javascript:void(0)' data-task='like' data-post_id='14689' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-14689 lc'>+3<\/span><\/a><\/div><\/div> <div class='status-14689 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Today my experiment will be upgrading 18c (18.14) to the latest 19c version (currently it is 19.12) in multitenant architecture with 2 PDBs. The idea of this scenario is to validate and test not only the upgrade process but especially the downgrade strategy. Please note I will keep the COMPATIBLE parameter of my target 19c &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-14689","post","type-post","status-publish","format-standard","hentry","category-database-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to upgrade and downgrade Oracle Database 18c to 19c - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"In this article, I describe the steps to upgrade an Oracle Database from 18c to 19c and also how can you roll it back.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"How to upgrade and downgrade Oracle Database 18c to 19c\",\"datePublished\":\"2021-10-01T03:55:40+00:00\",\"dateModified\":\"2021-10-01T12:11:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/\"},\"wordCount\":571,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/img_61560ed65bf64.png\",\"articleSection\":[\"Oracle Database General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/\",\"name\":\"How to upgrade and downgrade Oracle Database 18c to 19c - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/img_61560ed65bf64.png\",\"datePublished\":\"2021-10-01T03:55:40+00:00\",\"dateModified\":\"2021-10-01T12:11:55+00:00\",\"description\":\"In this article, I describe the steps to upgrade an Oracle Database from 18c to 19c and also how can you roll it back.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/img_61560ed65bf64.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/img_61560ed65bf64.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/10\\\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to upgrade and downgrade Oracle Database 18c to 19c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to upgrade and downgrade Oracle Database 18c to 19c - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"In this article, I describe the steps to upgrade an Oracle Database from 18c to 19c and also how can you roll it back.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"How to upgrade and downgrade Oracle Database 18c to 19c","datePublished":"2021-10-01T03:55:40+00:00","dateModified":"2021-10-01T12:11:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/"},"wordCount":571,"commentCount":2,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_61560ed65bf64.png","articleSection":["Oracle Database General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/","url":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/","name":"How to upgrade and downgrade Oracle Database 18c to 19c - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/#primaryimage"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_61560ed65bf64.png","datePublished":"2021-10-01T03:55:40+00:00","dateModified":"2021-10-01T12:11:55+00:00","description":"In this article, I describe the steps to upgrade an Oracle Database from 18c to 19c and also how can you roll it back.","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/#primaryimage","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_61560ed65bf64.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_61560ed65bf64.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2021\/10\/how-to-upgrade-and-downgrade-oracle-database-18c-to-19c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"How to upgrade and downgrade Oracle Database 18c to 19c"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/14689","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=14689"}],"version-history":[{"count":5,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/14689\/revisions"}],"predecessor-version":[{"id":14705,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/14689\/revisions\/14705"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=14689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=14689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=14689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}