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> select instance_name from v$instance; INSTANCE_NAME ---------------- RCAT11G SQL> select * from rcat.rc_database; DB_KEY DBINC_KEY DBID NAME RESETLOGS_CHANGE# RESETLOGS ---------- ---------- ---------- -------- ----------------- --------- 41 42 3287252358 DB2TEST1 1 05-JAN-18 1 2 65811618 DB1TEST1 1 05-JAN-18
Displaying the list of databases registered in the RCAT12c catalog.
SQL> select instance_name from v$instance; INSTANCE_NAME ---------------- RCAT12C SQL> select * from rcat.rc_database; no rows selected
Verifying existing backup meta data on RCAT11g.
SQL> select db_name, name from rcat.rc_datafile; DB_NAME NAME ------------------------------ ------------------------------------------------------------ DB2TEST1 /u01/oradata/DB2TEST11G/system01DB2TEST11G.dbf DB2TEST1 /u01/oradata/DB2TEST11G/sysaux01DB2TEST11G.dbf DB2TEST1 /u01/oradata/DB2TEST11G/undotbs01DB2TEST11G.dbf DB2TEST1 /u01/oradata/DB2TEST11G/users01DB2TEST11G.dbf DB1TEST1 /u01/oradata/DB1TEST11G/system01DB1TEST11G.dbf DB1TEST1 /u01/oradata/DB1TEST11G/sysaux01DB1TEST11G.dbf DB1TEST1 /u01/oradata/DB1TEST11G/undotbs01DB1TEST11G.dbf DB1TEST1 /u01/oradata/DB1TEST11G/users01DB1TEST11G.dbf 8 rows selected.
Migrating RCAT11g to RCAT12c
Importing RCAT11g catalog data into RCAT12c.
oracle@vmtestoradg1:/home/oracle/ [RCAT12C] rman catalog rcat/manager Recovery Manager: Release 12.2.0.1.0 RMAN> import catalog rcat/manager@RCAT11G; Starting import catalog at 05-JAN-2018 13:39:56 connected to source recovery catalog database PL/SQL package RCAT.DBMS_RCVCAT version 11.02.00.04 in IMPCAT database is too old RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of import catalog command at 01/05/2018 13:39:56 RMAN-06429: IMPCAT database is not compatible with this version of RMAN
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.
oracle@vmtestoradg1:/home/oracle/ [RCAT12C] sqlplus sys/manager@RCAT11G as sysdba SQL*Plus: Release 12.2.0.1.0 SQL> @/oracle/u01/app/oracle/product/12.2.0/db_1_0/rdbms/admin/dbmsrmansys.sql PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. PL/SQL procedure successfully completed.
oracle@vmtestoradg1:/home/oracle/ [RCAT12C] rman target sys/manager catalog rcat/manager@RCAT11G Recovery Manager: Release 12.2.0.1.0 connected to target database: RCAT12C (DBID=426487514) connected to recovery catalog database RMAN> upgrade catalog; recovery catalog owner is RCAT enter UPGRADE CATALOG command again to confirm catalog upgrade RMAN> upgrade catalog; recovery catalog upgraded to version 12.02.00.01 DBMS_RCVMAN package upgraded to version 12.02.00.01 DBMS_RCVCAT package upgraded to version 12.02.00.01.
Verifying new version of RCAT11g catalog.
oracle@vmreforadg01:/u00/app/oracle/network/admin/ [RCAT11G] sqlplus rcat/manager SQL*Plus: Release 11.2.0.4.0 SQL> select * from rcver; VERSION ------------ 12.02.00.01
Importing RCAT11g catalog data into RCAT12c catalog.
oracle@vmtestoradg1:/u01/app/oracle/network/admin/ [RCAT12C] rman catalog rcat/manager Recovery Manager: Release 12.2.0.1.0 connected to recovery catalog database RMAN> list db_unique_name all; RMAN> import catalog rcat/manager@RCAT11G; Starting import catalog at 05-JAN-2018 15:21:48 connected to source recovery catalog database import validation complete database unregistered from the source recovery catalog Finished import catalog at 05-JAN-2018 15:21:52 RMAN> list db_unique_name all; List of Databases DB Key DB Name DB ID Database Role Db_unique_name ------- ------- ----------------- --------------- ------------------ 2 DB1TEST1 65811618 PRIMARY DB1TEST11G 42 DB2TEST1 3287252358 PRIMARY DB2TEST11G
Verifying new configuration
Displaying the list of databases registered in the RCAT11g catalog.
oracle@vmreforadg01:/u00/app/oracle/network/admin/ [RCAT11G] sqh SQL*Plus: Release 11.2.0.4.0 SQL> select * from rcat.rc_database; no rows selected SQL> select db_name, name from rcat.rc_datafile; no rows selected SQL> select DB_KEY, DB_ID, START_TIME, COMPLETION_TIME from RCAT.RC_BACKUP_SET; no rows selected
Displaying the list of databases registered in the RCAT12c catalog.
oracle@vmtestoradg1:/u01/app/oracle/network/admin/ [RCAT12C] sqh SQL*Plus: Release 12.2.0.1.0 SQL> select * from rcat.rc_database; DB_KEY DBINC_KEY DBID NAME RESETLOGS_CHANGE# RESETLOGS FINAL_CHANGE# ---------- ---------- ---------- ----------------------------- ----------------- --------- ------------- 42 43 3287252358 DB2TEST1 1 05-JAN-18 2 3 65811618 DB1TEST1 1 05-JAN-18 SQL> select db_name, name from rcat.rc_datafile; DB_NAME NAME ------------------------------ ------------------------------------------------------------ DB2TEST1 /u01/oradata/DB2TEST11G/users01DB2TEST11G.dbf DB2TEST1 /u01/oradata/DB2TEST11G/system01DB2TEST11G.dbf DB1TEST1 /u01/oradata/DB1TEST11G/system01DB1TEST11G.dbf DB1TEST1 /u01/oradata/DB1TEST11G/sysaux01DB1TEST11G.dbf DB2TEST1 /u01/oradata/DB2TEST11G/undotbs01DB2TEST11G.dbf DB2TEST1 /u01/oradata/DB2TEST11G/sysaux01DB2TEST11G.dbf DB1TEST1 /u01/oradata/DB1TEST11G/undotbs01DB1TEST11G.dbf DB1TEST1 /u01/oradata/DB1TEST11G/users01DB1TEST11G.dbf 8 rows selected. SQL> select DB_KEY, DB_ID, START_TIME, COMPLETION_TIME from RCAT.RC_BACKUP_SET; DB_KEY DB_ID START_TIME COMPLETION_TIME ---------- ---------- ------------------- ------------------- 42 3287252358 05/01/2018 11:32:00 05/01/2018 11:32:00 42 3287252358 05/01/2018 11:32:02 05/01/2018 11:32:06 42 3287252358 05/01/2018 11:32:09 05/01/2018 11:32:10 42 3287252358 05/01/2018 11:32:12 05/01/2018 11:32:12 42 3287252358 05/01/2018 15:33:37 05/01/2018 15:33:37 42 3287252358 05/01/2018 15:33:40 05/01/2018 15:33:45 42 3287252358 05/01/2018 15:33:47 05/01/2018 15:33:48 42 3287252358 05/01/2018 15:33:50 05/01/2018 15:33:50 2 65811618 05/01/2018 11:29:36 05/01/2018 11:29:36 2 65811618 05/01/2018 11:29:38 05/01/2018 11:29:43 2 65811618 05/01/2018 11:29:45 05/01/2018 11:29:46 2 65811618 05/01/2018 11:29:48 05/01/2018 11:29:48 2 65811618 05/01/2018 15:31:17 05/01/2018 15:31:17 2 65811618 05/01/2018 15:31:19 05/01/2018 15:31:24 2 65811618 05/01/2018 15:31:26 05/01/2018 15:31:27 2 65811618 05/01/2018 15:31:29 05/01/2018 15:31:29 2 65811618 05/01/2018 15:44:47 05/01/2018 15:44:47 2 65811618 05/01/2018 15:44:49 05/01/2018 15:44:52 2 65811618 05/01/2018 15:44:56 05/01/2018 15:44:57 2 65811618 05/01/2018 15:45:00 05/01/2018 15:45:00 2 65811618 05/01/2018 15:46:53 05/01/2018 15:46:53 2 65811618 05/01/2018 15:46:55 05/01/2018 15:47:00 2 65811618 05/01/2018 15:47:02 05/01/2018 15:47:03 2 65811618 05/01/2018 15:47:05 05/01/2018 15:47:05 24 rows selected.
Checking new backup meta data to be recorded in RCAT12c catalog
Generating a new backup.
oracle@vmreforadg02:/u00/app/oracle/network/admin/ [DB2TEST11G] export NLS_DATE_FORMAT="DD/MM/YYYY HH24:MI:SS" oracle@vmreforadg02:/u00/app/oracle/network/admin/ [DB2TEST11G] rmanh Recovery Manager: Release 11.2.0.4.0 RMAN> connect target / connected to target database: DB2TEST1 (DBID=3287252358) RMAN> connect catalog rcat/manager@rcat12c connected to recovery catalog database RMAN> backup database plus archivelog; Starting backup at 05/01/2018 15:51:14 current log archived allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=32 device type=DISK channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=32 RECID=1 STAMP=964611118 input archived log thread=1 sequence=33 RECID=2 STAMP=964611131 input archived log thread=1 sequence=34 RECID=3 STAMP=964625616 input archived log thread=1 sequence=35 RECID=4 STAMP=964625629 input archived log thread=1 sequence=36 RECID=5 STAMP=964626674 channel ORA_DISK_1: starting piece 1 at 05/01/2018 15:51:16 channel ORA_DISK_1: finished piece 1 at 05/01/2018 15:51:17 piece handle=/u90/fast_recovery_area/DB2TEST11G/backupset/2018_01_05/o1_mf_annnn_TAG20180105T155116_f4z474b0_.bkp tag=TAG20180105T155116 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 05/01/2018 15:51:17 Starting backup at 05/01/2018 15:51:17 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=/u01/oradata/DB2TEST11G/system01DB2TEST11G.dbf input datafile file number=00003 name=/u01/oradata/DB2TEST11G/undotbs01DB2TEST11G.dbf input datafile file number=00002 name=/u01/oradata/DB2TEST11G/sysaux01DB2TEST11G.dbf input datafile file number=00004 name=/u01/oradata/DB2TEST11G/users01DB2TEST11G.dbf channel ORA_DISK_1: starting piece 1 at 05/01/2018 15:51:18 channel ORA_DISK_1: finished piece 1 at 05/01/2018 15:51:25 piece handle=/u90/fast_recovery_area/DB2TEST11G/backupset/2018_01_05/o1_mf_nnndf_TAG20180105T155117_f4z476gv_.bkp tag=TAG20180105T155117 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 05/01/2018 15:51:26 channel ORA_DISK_1: finished piece 1 at 05/01/2018 15:51:27 piece handle=/u90/fast_recovery_area/DB2TEST11G/backupset/2018_01_05/o1_mf_ncsnf_TAG20180105T155117_f4z47glg_.bkp tag=TAG20180105T155117 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 05/01/2018 15:51:27 Starting backup at 05/01/2018 15:51:27 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=37 RECID=6 STAMP=964626687 channel ORA_DISK_1: starting piece 1 at 05/01/2018 15:51:28 channel ORA_DISK_1: finished piece 1 at 05/01/2018 15:51:29 piece handle=/u90/fast_recovery_area/DB2TEST11G/backupset/2018_01_05/o1_mf_annnn_TAG20180105T155128_f4z47jn7_.bkp tag=TAG20180105T155128 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 05/01/2018 15:51:29
Verifying backup set in new RCAT12c catalog.
oracle@vmtestoradg1:/u01/app/oracle/network/admin/ [RCAT12C] sqh SQL*Plus: Release 12.2.0.1.0 SQL> select sysdate from dual; SYSDATE ------------------- 05/01/2018 15:53:16 SQL> select DB_KEY, DB_ID, START_TIME, COMPLETION_TIME from RCAT.RC_BACKUP_SET; DB_KEY DB_ID START_TIME COMPLETION_TIME ---------- ---------- ------------------- ------------------- 42 3287252358 05/01/2018 11:32:00 05/01/2018 11:32:00 42 3287252358 05/01/2018 11:32:02 05/01/2018 11:32:06 42 3287252358 05/01/2018 11:32:09 05/01/2018 11:32:10 42 3287252358 05/01/2018 11:32:12 05/01/2018 11:32:12 42 3287252358 05/01/2018 15:33:37 05/01/2018 15:33:37 42 3287252358 05/01/2018 15:33:40 05/01/2018 15:33:45 42 3287252358 05/01/2018 15:33:47 05/01/2018 15:33:48 42 3287252358 05/01/2018 15:33:50 05/01/2018 15:33:50 42 3287252358 05/01/2018 15:51:16 05/01/2018 15:51:16 42 3287252358 05/01/2018 15:51:18 05/01/2018 15:51:21 42 3287252358 05/01/2018 15:51:25 05/01/2018 15:51:26 42 3287252358 05/01/2018 15:51:28 05/01/2018 15:51:28 2 65811618 05/01/2018 11:29:36 05/01/2018 11:29:36 2 65811618 05/01/2018 11:29:38 05/01/2018 11:29:43 2 65811618 05/01/2018 11:29:45 05/01/2018 11:29:46 2 65811618 05/01/2018 11:29:48 05/01/2018 11:29:48 2 65811618 05/01/2018 15:31:17 05/01/2018 15:31:17 2 65811618 05/01/2018 15:31:19 05/01/2018 15:31:24 2 65811618 05/01/2018 15:31:26 05/01/2018 15:31:27 2 65811618 05/01/2018 15:31:29 05/01/2018 15:31:29 2 65811618 05/01/2018 15:44:47 05/01/2018 15:44:47 2 65811618 05/01/2018 15:44:49 05/01/2018 15:44:52 2 65811618 05/01/2018 15:44:56 05/01/2018 15:44:57 2 65811618 05/01/2018 15:45:00 05/01/2018 15:45:00 2 65811618 05/01/2018 15:46:53 05/01/2018 15:46:53 2 65811618 05/01/2018 15:46:55 05/01/2018 15:47:00 2 65811618 05/01/2018 15:47:02 05/01/2018 15:47:03 2 65811618 05/01/2018 15:47:05 05/01/2018 15:47:05 28 rows selected.