{"id":10749,"date":"2018-01-12T15:36:18","date_gmt":"2018-01-12T14:36:18","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/"},"modified":"2018-01-12T15:36:18","modified_gmt":"2018-01-12T14:36:18","slug":"oracle-11g-to-12c-rman-catalog-migration","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/","title":{"rendered":"ORACLE 11g to 12c RMAN catalog migration"},"content":{"rendered":"

This is a small migration demo of a 11g catalog (RCAT11G) to a new 12c catalog (RCAT12c).<\/p>\n

Demo databases environments have been easily managed thanks to DBI DMK tool.<\/a><\/p>\n

oracle@vmreforadg01:\/home\/oracle\/ [RCAT11G] sqh\nSQL*Plus: Release 11.2.0.4.0 \n\noracle@vmtestoradg1:\/home\/oracle\/ [RCAT12C] sqh\nSQL*Plus: Release 12.2.0.1.0<\/pre>\n
 <\/p>\n
Current configuration<\/h3>\n
Displaying the list of databases registered in the RCAT11g catalog.<\/p>\n
SQL> select instance_name from v$instance;\n\nINSTANCE_NAME\n----------------\nRCAT11G\n\nSQL> select * from rcat.rc_database;\n\n\u00a0\u00a0\u00a0 DB_KEY\u00a0 DBINC_KEY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DBID NAME\u00a0\u00a0\u00a0\u00a0 RESETLOGS_CHANGE# RESETLOGS\n---------- ---------- ---------- -------- ----------------- ---------\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 41\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 DB2TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 05-JAN-18\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 DB1TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 05-JAN-18<\/pre>\n
 <\/p>\n
Displaying the list of databases registered in the RCAT12c catalog.<\/p>\n
SQL> select instance_name from v$instance;\n\nINSTANCE_NAME\n----------------\nRCAT12C\n\nSQL>\u00a0 select * from rcat.rc_database;\n\nno rows selected<\/pre>\n
 <\/p>\n
Verifying existing backup meta data on RCAT11g.<\/p>\n
SQL> select db_name, name from rcat.rc_datafile;\n\nDB_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NAME\n------------------------------ ------------------------------------------------------------\nDB2TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB2TEST11G\/system01DB2TEST11G.dbf\nDB2TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB2TEST11G\/sysaux01DB2TEST11G.dbf\nDB2TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB2TEST11G\/undotbs01DB2TEST11G.dbf\nDB2TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB2TEST11G\/users01DB2TEST11G.dbf\nDB1TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB1TEST11G\/system01DB1TEST11G.dbf\nDB1TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB1TEST11G\/sysaux01DB1TEST11G.dbf\nDB1TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB1TEST11G\/undotbs01DB1TEST11G.dbf\nDB1TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB1TEST11G\/users01DB1TEST11G.dbf\n\n8 rows selected.<\/pre>\n
 <\/p>\n
Migrating RCAT11g to RCAT12c<\/h3>\n
Importing RCAT11g catalog data into RCAT12c.<\/p>\n
oracle@vmtestoradg1:\/home\/oracle\/ [RCAT12C] rman catalog rcat\/manager\nRecovery Manager: Release 12.2.0.1.0\n\nRMAN> import catalog rcat\/manager@RCAT11G;\n\nStarting import catalog at 05-JAN-2018 13:39:56\nconnected to source recovery catalog database\nPL\/SQL package RCAT.DBMS_RCVCAT version 11.02.00.04 in IMPCAT database is too old\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of import catalog command at 01\/05\/2018 13:39:56\nRMAN-06429: IMPCAT database is not compatible with this version of RMAN<\/pre>\n
 <\/p>\n
When using IMPORT CATALOG, the version of the source recovery catalog schema must be equal to the current version of the destination recovery catalog schema. We, therefore, first need to upgrade RCAT11g catalog schema.<\/p>\n
oracle@vmtestoradg1:\/home\/oracle\/ [RCAT12C] sqlplus sys\/manager@RCAT11G as sysdba\nSQL*Plus: Release 12.2.0.1.0\n\nSQL> @\/oracle\/u01\/app\/oracle\/product\/12.2.0\/db_1_0\/rdbms\/admin\/dbmsrmansys.sql\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<\/pre>\n
oracle@vmtestoradg1:\/home\/oracle\/ [RCAT12C] rman target sys\/manager catalog rcat\/manager@RCAT11G\nRecovery Manager: Release 12.2.0.1.0\n\nconnected to target database: RCAT12C (DBID=426487514)\nconnected to recovery catalog database\n\nRMAN> upgrade catalog;\n\nrecovery catalog owner is RCAT\nenter UPGRADE CATALOG command again to confirm catalog upgrade\n\nRMAN> upgrade catalog;\n\nrecovery catalog upgraded to version 12.02.00.01\nDBMS_RCVMAN package upgraded to version 12.02.00.01\nDBMS_RCVCAT package upgraded to version 12.02.00.01.<\/pre>\n
 <\/p>\n
Verifying new version of RCAT11g catalog.<\/p>\n
oracle@vmreforadg01:\/u00\/app\/oracle\/network\/admin\/ [RCAT11G] sqlplus rcat\/manager\nSQL*Plus: Release 11.2.0.4.0\n\nSQL> select * from rcver;\n\nVERSION\n------------\n12.02.00.01<\/pre>\n
 <\/p>\n
Importing RCAT11g catalog data into RCAT12c catalog.<\/p>\n
oracle@vmtestoradg1:\/u01\/app\/oracle\/network\/admin\/ [RCAT12C] rman catalog rcat\/manager\nRecovery Manager: Release 12.2.0.1.0\n\nconnected to recovery catalog database\n\nRMAN> list db_unique_name all;\n\n\nRMAN> import catalog rcat\/manager@RCAT11G;\n\nStarting import catalog at 05-JAN-2018 15:21:48\nconnected to source recovery catalog database\nimport validation complete\ndatabase unregistered from the source recovery catalog\nFinished import catalog at 05-JAN-2018 15:21:52\n\nRMAN> list db_unique_name all;\n\n\nList of Databases\nDB Key\u00a0 DB Name\u00a0 DB ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Database Role\u00a0\u00a0\u00a0 Db_unique_name\n------- ------- ----------------- ---------------\u00a0 ------------------\n2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB1TEST1 65811618\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PRIMARY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB1TEST11G\n42\u00a0\u00a0\u00a0\u00a0\u00a0 DB2TEST1 3287252358\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PRIMARY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB2TEST11G<\/pre>\n
 <\/p>\n
Verifying new configuration<\/h3>\n
Displaying the list of databases registered in the RCAT11g catalog.<\/p>\n
oracle@vmreforadg01:\/u00\/app\/oracle\/network\/admin\/ [RCAT11G] sqh\nSQL*Plus: Release 11.2.0.4.0\n\nSQL> select * from rcat.rc_database;\n\nno rows selected\n\nSQL> select db_name, name from rcat.rc_datafile;\n\nno rows selected\n\nSQL> select DB_KEY, DB_ID, START_TIME, COMPLETION_TIME from RCAT.RC_BACKUP_SET;\n\nno rows selected<\/pre>\n
 <\/p>\n
Displaying the list of databases registered in the RCAT12c catalog.<\/p>\n
oracle@vmtestoradg1:\/u01\/app\/oracle\/network\/admin\/ [RCAT12C] sqh\nSQL*Plus: Release 12.2.0.1.0\n\nSQL> select * from rcat.rc_database;\n\n\u00a0\u00a0\u00a0 DB_KEY\u00a0 DBINC_KEY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DBID NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 RESETLOGS_CHANGE# RESETLOGS FINAL_CHANGE#\n---------- ---------- ---------- ----------------------------- ----------------- --------- -------------\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 43 3287252358 DB2TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 05-JAN-18\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0 65811618 DB1TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 05-JAN-18\n\nSQL> select db_name, name from rcat.rc_datafile;\n\nDB_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NAME\n------------------------------ ------------------------------------------------------------\nDB2TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB2TEST11G\/users01DB2TEST11G.dbf\nDB2TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB2TEST11G\/system01DB2TEST11G.dbf\nDB1TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB1TEST11G\/system01DB1TEST11G.dbf\nDB1TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB1TEST11G\/sysaux01DB1TEST11G.dbf\nDB2TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB2TEST11G\/undotbs01DB2TEST11G.dbf\nDB2TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB2TEST11G\/sysaux01DB2TEST11G.dbf\nDB1TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB1TEST11G\/undotbs01DB1TEST11G.dbf\nDB1TEST1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/oradata\/DB1TEST11G\/users01DB1TEST11G.dbf\n\n8 rows selected.\n\nSQL> select DB_KEY, DB_ID, START_TIME, COMPLETION_TIME from RCAT.RC_BACKUP_SET;\n\n\u00a0\u00a0\u00a0 DB_KEY\u00a0\u00a0\u00a0\u00a0\u00a0 DB_ID START_TIME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COMPLETION_TIME\n---------- ---------- ------------------- -------------------\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 11:32:00 05\/01\/2018 11:32:00\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 11:32:02 05\/01\/2018 11:32:06\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 11:32:09 05\/01\/2018 11:32:10\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 11:32:12 05\/01\/2018 11:32:12\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 15:33:37 05\/01\/2018 15:33:37\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 15:33:40 05\/01\/2018 15:33:45\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 15:33:47 05\/01\/2018 15:33:48\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 15:33:50 05\/01\/2018 15:33:50\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 11:29:36 05\/01\/2018 11:29:36\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 11:29:38 05\/01\/2018 11:29:43\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 11:29:45 05\/01\/2018 11:29:46\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 11:29:48 05\/01\/2018 11:29:48\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:31:17 05\/01\/2018 15:31:17\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:31:19 05\/01\/2018 15:31:24\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:31:26 05\/01\/2018 15:31:27\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:31:29 05\/01\/2018 15:31:29\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:44:47 05\/01\/2018 15:44:47\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:44:49 05\/01\/2018 15:44:52\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:44:56 05\/01\/2018 15:44:57\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:45:00 05\/01\/2018 15:45:00\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:46:53 05\/01\/2018 15:46:53\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:46:55 05\/01\/2018 15:47:00\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:47:02 05\/01\/2018 15:47:03\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:47:05 05\/01\/2018 15:47:05\n\n24 rows selected.<\/pre>\n
 <\/p>\n
Checking new backup meta data to be recorded in RCAT12c catalog<\/h3>\n
Generating a new backup.<\/p>\n
oracle@vmreforadg02:\/u00\/app\/oracle\/network\/admin\/ [DB2TEST11G] export NLS_DATE_FORMAT=\"DD\/MM\/YYYY HH24:MI:SS\"\noracle@vmreforadg02:\/u00\/app\/oracle\/network\/admin\/ [DB2TEST11G] rmanh\nRecovery Manager: Release 11.2.0.4.0\n\nRMAN> connect target \/\n\nconnected to target database: DB2TEST1 (DBID=3287252358)\n\nRMAN> connect catalog rcat\/manager@rcat12c\n\nconnected to recovery catalog database\n\nRMAN> backup database plus archivelog;\n\nStarting backup at 05\/01\/2018 15:51:14\ncurrent log archived\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=32 device type=DISK\nchannel ORA_DISK_1: starting archived log backup set\nchannel ORA_DISK_1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=32 RECID=1 STAMP=964611118\ninput archived log thread=1 sequence=33 RECID=2 STAMP=964611131\ninput archived log thread=1 sequence=34 RECID=3 STAMP=964625616\ninput archived log thread=1 sequence=35 RECID=4 STAMP=964625629\ninput archived log thread=1 sequence=36 RECID=5 STAMP=964626674\nchannel ORA_DISK_1: starting piece 1 at 05\/01\/2018 15:51:16\nchannel ORA_DISK_1: finished piece 1 at 05\/01\/2018 15:51:17\npiece handle=\/u90\/fast_recovery_area\/DB2TEST11G\/backupset\/2018_01_05\/o1_mf_annnn_TAG20180105T155116_f4z474b0_.bkp tag=TAG20180105T155116 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 05\/01\/2018 15:51:17\n\nStarting backup at 05\/01\/2018 15:51:17\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/u01\/oradata\/DB2TEST11G\/system01DB2TEST11G.dbf\ninput datafile file number=00003 name=\/u01\/oradata\/DB2TEST11G\/undotbs01DB2TEST11G.dbf\ninput datafile file number=00002 name=\/u01\/oradata\/DB2TEST11G\/sysaux01DB2TEST11G.dbf\ninput datafile file number=00004 name=\/u01\/oradata\/DB2TEST11G\/users01DB2TEST11G.dbf\nchannel ORA_DISK_1: starting piece 1 at 05\/01\/2018 15:51:18\nchannel ORA_DISK_1: finished piece 1 at 05\/01\/2018 15:51:25\npiece handle=\/u90\/fast_recovery_area\/DB2TEST11G\/backupset\/2018_01_05\/o1_mf_nnndf_TAG20180105T155117_f4z476gv_.bkp tag=TAG20180105T155117 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:07\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\nincluding current control file in backup set\nincluding current SPFILE in backup set\nchannel ORA_DISK_1: starting piece 1 at 05\/01\/2018 15:51:26\nchannel ORA_DISK_1: finished piece 1 at 05\/01\/2018 15:51:27\npiece handle=\/u90\/fast_recovery_area\/DB2TEST11G\/backupset\/2018_01_05\/o1_mf_ncsnf_TAG20180105T155117_f4z47glg_.bkp tag=TAG20180105T155117 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 05\/01\/2018 15:51:27\n\nStarting backup at 05\/01\/2018 15:51:27\ncurrent log archived\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting archived log backup set\nchannel ORA_DISK_1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=37 RECID=6 STAMP=964626687\nchannel ORA_DISK_1: starting piece 1 at 05\/01\/2018 15:51:28\nchannel ORA_DISK_1: finished piece 1 at 05\/01\/2018 15:51:29\npiece handle=\/u90\/fast_recovery_area\/DB2TEST11G\/backupset\/2018_01_05\/o1_mf_annnn_TAG20180105T155128_f4z47jn7_.bkp tag=TAG20180105T155128 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 05\/01\/2018 15:51:29<\/pre>\n
 <\/p>\n
Verifying backup set in new RCAT12c catalog.<\/p>\n
oracle@vmtestoradg1:\/u01\/app\/oracle\/network\/admin\/ [RCAT12C] sqh\nSQL*Plus: Release 12.2.0.1.0\n\nSQL> select sysdate from dual;\n\nSYSDATE\n-------------------\n05\/01\/2018 15:53:16\n\nSQL> select DB_KEY, DB_ID, START_TIME, COMPLETION_TIME from RCAT.RC_BACKUP_SET;\n\n\u00a0\u00a0\u00a0 DB_KEY\u00a0\u00a0\u00a0\u00a0\u00a0 DB_ID START_TIME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COMPLETION_TIME\n---------- ---------- ------------------- -------------------\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 11:32:00 05\/01\/2018 11:32:00\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 11:32:02 05\/01\/2018 11:32:06\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 11:32:09 05\/01\/2018 11:32:10\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 11:32:12 05\/01\/2018 11:32:12\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 15:33:37 05\/01\/2018 15:33:37\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 15:33:40 05\/01\/2018 15:33:45\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 15:33:47 05\/01\/2018 15:33:48\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 15:33:50 05\/01\/2018 15:33:50\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 15:51:16 05\/01\/2018 15:51:16\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 15:51:18 05\/01\/2018 15:51:21\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 15:51:25 05\/01\/2018 15:51:26\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 3287252358 05\/01\/2018 15:51:28 05\/01\/2018 15:51:28\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 11:29:36 05\/01\/2018 11:29:36\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 11:29:38 05\/01\/2018 11:29:43\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 11:29:45 05\/01\/2018 11:29:46\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 11:29:48 05\/01\/2018 11:29:48\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:31:17 05\/01\/2018 15:31:17\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:31:19 05\/01\/2018 15:31:24\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:31:26 05\/01\/2018 15:31:27\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:31:29 05\/01\/2018 15:31:29\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:44:47 05\/01\/2018 15:44:47\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:44:49 05\/01\/2018 15:44:52\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:44:56 05\/01\/2018 15:44:57\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:45:00 05\/01\/2018 15:45:00\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:46:53 05\/01\/2018 15:46:53\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:46:55 05\/01\/2018 15:47:00\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:47:02 05\/01\/2018 15:47:03\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 65811618 05\/01\/2018 15:47:05 05\/01\/2018 15:47:05\n\n28 rows selected.<\/pre>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
This is a small migration demo of a 11g catalog (RCAT11G) to a new 12c catalog (RCAT12c). Demo databases environments have been easily managed thanks to DBI DMK tool. oracle@vmreforadg01:\/home\/oracle\/ [RCAT11G] sqh SQL*Plus: Release 11.2.0.4.0 oracle@vmtestoradg1:\/home\/oracle\/ [RCAT12C] sqh SQL*Plus: Release 12.2.0.1.0   Current configuration Displaying the list of databases registered in the RCAT11g catalog. SQL> […]<\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198,59],"tags":[280,23,96,17,209,270],"type_dbi":[],"class_list":["post-10749","post","type-post","status-publish","format-standard","hentry","category-database-management","category-oracle","tag-database","tag-dba","tag-oracle","tag-oracle-11g","tag-oracle-12c","tag-rman"],"acf":[],"yoast_head":"\nORACLE 11g to 12c RMAN catalog migration - dbi Blog<\/title>\n<meta name=\"description\" content=\"Blog about migration of an ORACLE 11g RMAN catalog database to a new ORACLE 12c.\" \/>\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.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORACLE 11g to 12c RMAN catalog migration\" \/>\n<meta property=\"og:description\" content=\"Blog about migration of an ORACLE 11g RMAN catalog database to a new ORACLE 12c.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-12T14:36:18+00:00\" \/>\n<meta name=\"author\" content=\"Marc Wagner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marc Wagner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"ORACLE 11g to 12c RMAN catalog migration\",\"datePublished\":\"2018-01-12T14:36:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/\"},\"wordCount\":197,\"commentCount\":0,\"keywords\":[\"database\",\"DBA\",\"Oracle\",\"Oracle 11g\",\"Oracle 12c\",\"RMAN\"],\"articleSection\":[\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/\",\"name\":\"ORACLE 11g to 12c RMAN catalog migration - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2018-01-12T14:36:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"description\":\"Blog about migration of an ORACLE 11g RMAN catalog database to a new ORACLE 12c.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORACLE 11g to 12c RMAN catalog migration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\",\"name\":\"Marc Wagner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"caption\":\"Marc Wagner\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ORACLE 11g to 12c RMAN catalog migration - dbi Blog","description":"Blog about migration of an ORACLE 11g RMAN catalog database to a new ORACLE 12c.","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.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/","og_locale":"en_US","og_type":"article","og_title":"ORACLE 11g to 12c RMAN catalog migration","og_description":"Blog about migration of an ORACLE 11g RMAN catalog database to a new ORACLE 12c.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/","og_site_name":"dbi Blog","article_published_time":"2018-01-12T14:36:18+00:00","author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"ORACLE 11g to 12c RMAN catalog migration","datePublished":"2018-01-12T14:36:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/"},"wordCount":197,"commentCount":0,"keywords":["database","DBA","Oracle","Oracle 11g","Oracle 12c","RMAN"],"articleSection":["Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/","name":"ORACLE 11g to 12c RMAN catalog migration - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-01-12T14:36:18+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"description":"Blog about migration of an ORACLE 11g RMAN catalog database to a new ORACLE 12c.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-11g-to-12c-rman-catalog-migration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ORACLE 11g to 12c RMAN catalog migration"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628","name":"Marc Wagner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","caption":"Marc Wagner"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10749"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10749\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10749"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}