upgrade RMAN Catalog schema per supportare database oracle 12c
Supponiamo di voler registrare un database 12c su catalogo RMAN.
[oracle@oradb12 admin]$ rman target / catalog rman/xxxxxx@CATDB
Recovery Manager: Release 12.2.0.1.0 - Production on Mon Nov 26 14:40:35 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=22131311111)
connected to recovery catalog database
PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old
RMAN> register database;
PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old
PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 11/26/2018 14:42:57
RMAN-06429: RCVCAT database is not compatible with this version of RMAN
[oracle@oradb12 admin]$ rman target / catalog rman/xxxxxx@CATDB
Recovery Manager: Release 12.2.0.1.0 - Production on Mon Nov 26 14:40:35 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=22131311111)
connected to recovery catalog database
PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old
RMAN> register database;
PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old
PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 11/26/2018 14:42:57
RMAN-06429: RCVCAT database is not compatible with this version of RMAN
Risalire alla versione dello schema RMAN Catalog.
oracle@oradb12:/home/oracle> sqlplus rman/xxxx@CATDB
SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 26 14:57:30 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SELECT * FROM rcver;
VERSION
------------------------------------
11.02.00.04
Per effettuare l'upgade collegarsi ad RMAN Catalog.
[oracle@oradb12 admin]$ rman target / catalog rman/xxxxxx@CATDB
RMAN>upgrade catalog;