Infrastructure at your Service

Marc Wagner

ORACLE 11g to 12c RMAN catalog migration

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.

 

 

 

One Comment

  • Christian Weiss says:

    Hello Marc,

    > “We, therefore, first need to upgrade RCAT11g catalog schema.”
    Customers who are using an Oracle Standard Edition database for the RMAN Catalog needs to be aware, that the Recovery Catalog using the Partitioning option in 12.2.
    So, when you try to “upgrade catalog” an Oracle Standard Edition database you will face an error, because of missing Partitioning. After that, the Catalog isn’t usable anymore and needs a restore.

    Best regards,
    Christian

     

Leave a Reply


4 × eight =

Marc Wagner
Marc Wagner