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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)