I restored a backup from an older version than the current database version. Therefore, when I tried to use the RMAN utility, I received the following errors:
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Sep 9 12:21:46 2022 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN> connect target / Recovery Manager incompatible with TARGET database: RMAN 8.0.4.0 to 11.1.0.7 required RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-06429: TARGET database is not compatible with this version of RMAN
After executing the scripts dbmsrman.sql,dbmsbkrs.sql,prvtrmns.plb and prvtbkrs.plb under the location @$ORACLE_HOME/rdbms/admin/ as the SYS owner, I was able to use the RMAN utility as below:
sqlplus / as sysdba SQL> @$ORACLE_HOME/rdbms/admin/dbmsrman.sql SQL> @$ORACLE_HOME/rdbms/admin/dbmsbkrs.sql SQL> @$ORACLE_HOME/rdbms/admin/prvtrmns.plb SQL>@$ORACLE_HOME/rdbms/admin/prvtbkrs.plb Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options [oracle@techdatabasket bin]$ rman Recovery Manager: Release 11.2.0.3.0 - Production on Fri Sep 9 12:36:14 2022 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN> connect target /
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)