Configure RMAN recovery catalog and Register Database - 19c

Purpose of the Recovery Catalog

A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. Typically, you store the catalog in a dedicated database. A recovery catalog provides the following benefits:

• A recovery catalog creates redundancy for the RMAN repository stored in the control file of each target database. The recovery catalog serves as a secondary metadata repository. If the target control file and all backups are lost, then the RMAN metadata still exists in the recovery catalog.

• A recovery catalog centralizes metadata for all your target databases. Storing the metadata in a single place makes reporting and administration tasks easier to perform.

Steps to create recovery catalog database

Step 1: Connect to the target database which you want to use as a recovery catalog.

Here in my case, I am using pdb "RCAT" as a recovery catalog

[code] SQL> select name,open_mode from v$database; NAME OPEN_MODE -------------------- -------------------- ORCL1 READ WRITE SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCL1PDB MOUNTED 4 PDB1 READ WRITE NO 5 RCAT READ WRITE NO SQL> [/code]

Step 2: Change your database to the pdb database. In my case RCAT
[code] SQL> alter session set container=RCAT; Session altered. SQL> show con_name CON_NAME ------------------------------ RCAT SQL> [/code]


Step 3: We need to create tablespace which we need to store backup information of registered target database.
[code] SQL> show parameter db_create_file_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_create_file_dest string /u01/app/oracle/oradata/PDB SQL> SQL> CREATE TABLESPACE RCAT_TBS DATAFILE SIZE 100M; Tablespace created. SQL> [/code]


Step 4: Create user who will act as a recovery catalog owner
[code] SQL> CREATE USER RCATOWN IDENTIFIED BY "oracle" DEFAULT TABLESPACE RCAT_TBS QUOTA UNLIMITED ON RCAT_TBS; User created. [/code]


Step 5: "RECOVERY_CATALOG_OWNER" role is needed for the user to create catalog database
[code] SQL> GRANT RECOVERY_CATALOG_OWNER TO RCATOWN; Grant succeeded. SQL> [/code]


Step 6: Create TNS entry in tnsnames.ora for pdb "RCAT" database
[code] RCAT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19c.oracledbashop.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RCAT.oracledbashop.com) ) ) [/code]


Step 7: Connect RMAN to pdb "RCAT" database with catalog clause
[code] [oracle@orcl19c admin]$ rman catalog RCATOWN/'oracle'@RCAT Recovery Manager: Release 19.0.0.0.0 - Production on Sun Apr 19 18:27:28 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to recovery catalog database RMAN> [/code]

Step 8: Issue create catalog database command 

[code] RMAN> create catalog; recovery catalog created RMAN> [/code]

Step 9: Connect to RMAN with target and cataloe
[code] [oracle@orcl19c admin]$ rman target sys/oracle@ORCL1 catalog RCATOWN/oracle@RCAT Recovery Manager: Release 19.0.0.0.0 - Production on Sun Apr 19 18:31:19 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL1 (DBID=1414679838) connected to recovery catalog database RMAN> [/code]

Step 10: Register database and check the status. The REPORT SCHEMA command lists and displays information about the database files, tablespaces, and so on.
[code] RMAN> register database; database registered in recovery catalog starting full resync of recovery catalog full resync complete RMAN> report schema; Report of database schema for database with db_unique_name ORCL1 List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 910 SYSTEM YES /u01/app/oracle/oradata/ORCL1/system01.dbf 3 540 SYSAUX NO /u01/app/oracle/oradata/ORCL1/sysaux01.dbf 4 330 UNDOTBS1 YES /u01/app/oracle/oradata/ORCL1/undotbs01.dbf 5 270 PDB$SEED:SYSTEM NO /u01/app/oracle/oradata/ORCL1/pdbseed/system01.dbf 6 330 PDB$SEED:SYSAUX NO /u01/app/oracle/oradata/ORCL1/pdbseed/sysaux01.dbf 7 5 USERS NO /u01/app/oracle/oradata/ORCL1/users01.dbf 8 100 PDB$SEED:UNDOTBS1 NO /u01/app/oracle/oradata/ORCL1/pdbseed/undotbs01.dbf 9 270 ORCL1PDB:SYSTEM NO /u01/app/oracle/oradata/ORCL1/orcl1pdb/system01.dbf 10 340 ORCL1PDB:SYSAUX NO /u01/app/oracle/oradata/ORCL1/orcl1pdb/sysaux01.dbf 11 100 ORCL1PDB:UNDOTBS1 NO /u01/app/oracle/oradata/ORCL1/orcl1pdb/undotbs01.dbf 12 5 ORCL1PDB:USERS NO /u01/app/oracle/oradata/ORCL1/orcl1pdb/users01.dbf 13 1 GG_TBS NO /u01/app/oracle/oradata/OGG/datafile/gg_cdb.dbf 14 1 ORCL1PDB:GG_TBS NO /u01/app/oracle/oradata/OGG/datafile/gg_pdb1.dbf 15 1024 ENCRYPT_TEST NO /u01/app/oracle/oradata/ORCL1/encrypt_test.dbf 16 270 PDB1:SYSTEM YES /u01/app/oracle/oradata/ORCL1/PDB1/system01.dbf 17 330 PDB1:SYSAUX NO /u01/app/oracle/oradata/ORCL1/PDB1/sysaux01.dbf 18 100 PDB1:UNDOTBS1 YES /u01/app/oracle/oradata/ORCL1/PDB1/undotbs01.dbf 19 5 PDB1:USERS NO /u01/app/oracle/oradata/ORCL1/PDB1/users01.dbf 20 280 RCAT:SYSTEM YES /u01/app/oracle/oradata/ORCL1/RCAT/system01.dbf 21 340 RCAT:SYSAUX NO /u01/app/oracle/oradata/ORCL1/RCAT/sysaux01.dbf 22 100 RCAT:UNDOTBS1 YES /u01/app/oracle/oradata/ORCL1/RCAT/undotbs01.dbf 23 5 RCAT:USERS NO /u01/app/oracle/oradata/ORCL1/RCAT/users01.dbf 24 100 RCAT:RCAT_TBS NO /u01/app/oracle/oradata/PDB/ORCL1/A3ADAF86A9AD6CE3E05301BEA8AC2362/datafile/o1_mf_rcat_tbs_h9sq14sq_.dbf List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 32 TEMP 32767 /u01/app/oracle/oradata/ORCL1/temp01.dbf 2 36 PDB$SEED:TEMP 32767 /u01/app/oracle/oradata/ORCL1/pdbseed/temp012020-01-20_23-16-38-484-PM.dbf 3 36 ORCL1PDB:TEMP 32767 /u01/app/oracle/oradata/ORCL1/orcl1pdb/temp01.dbf 4 36 PDB1:TEMP 32767 /u01/app/oracle/oradata/ORCL1/PDB1/temp012020-01-20_23-16-38-484-PM.dbf 5 36 RCAT:TEMP 32767 /u01/app/oracle/oradata/ORCL1/RCAT/temp012020-01-20_23-16-38-484-PM.dbf [/code]

Step 11: Take backup with recovery catalog (Optional)
[code] RMAN> backup database; Starting backup at 19-APR-20 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=347 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00015 name=/u01/app/oracle/oradata/ORCL1/encrypt_test.dbf input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL1/system01.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL1/sysaux01.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL1/undotbs01.dbf input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL1/users01.dbf input datafile file number=00013 name=/u01/app/oracle/oradata/OGG/datafile/gg_cdb.dbf channel ORA_DISK_1: starting piece 1 at 19-APR-20 channel ORA_DISK_1: finished piece 1 at 19-APR-20 piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0cuu2726_1_1 tag=TAG20200419T183653 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 input datafile file number=00021 name=/u01/app/oracle/oradata/ORCL1/RCAT/sysaux01.dbf input datafile file number=00020 name=/u01/app/oracle/oradata/ORCL1/RCAT/system01.dbf input datafile file number=00022 name=/u01/app/oracle/oradata/ORCL1/RCAT/undotbs01.dbf input datafile file number=00024 name=/u01/app/oracle/oradata/PDB/ORCL1/A3ADAF86A9AD6CE3E05301BEA8AC2362/datafile/o1_mf_rcat_tbs_h9sq14sq_.dbf input datafile file number=00023 name=/u01/app/oracle/oradata/ORCL1/RCAT/users01.dbf channel ORA_DISK_1: starting piece 1 at 19-APR-20 channel ORA_DISK_1: finished piece 1 at 19-APR-20 piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0duu272d_1_1 tag=TAG20200419T183653 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00010 name=/u01/app/oracle/oradata/ORCL1/orcl1pdb/sysaux01.dbf input datafile file number=00009 name=/u01/app/oracle/oradata/ORCL1/orcl1pdb/system01.dbf input datafile file number=00011 name=/u01/app/oracle/oradata/ORCL1/orcl1pdb/undotbs01.dbf input datafile file number=00012 name=/u01/app/oracle/oradata/ORCL1/orcl1pdb/users01.dbf input datafile file number=00014 name=/u01/app/oracle/oradata/OGG/datafile/gg_pdb1.dbf channel ORA_DISK_1: starting piece 1 at 19-APR-20 channel ORA_DISK_1: finished piece 1 at 19-APR-20 piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0euu272g_1_1 tag=TAG20200419T183653 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00017 name=/u01/app/oracle/oradata/ORCL1/PDB1/sysaux01.dbf input datafile file number=00016 name=/u01/app/oracle/oradata/ORCL1/PDB1/system01.dbf input datafile file number=00018 name=/u01/app/oracle/oradata/ORCL1/PDB1/undotbs01.dbf input datafile file number=00019 name=/u01/app/oracle/oradata/ORCL1/PDB1/users01.dbf channel ORA_DISK_1: starting piece 1 at 19-APR-20 channel ORA_DISK_1: finished piece 1 at 19-APR-20 piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0fuu272k_1_1 tag=TAG20200419T183653 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00006 name=/u01/app/oracle/oradata/ORCL1/pdbseed/sysaux01.dbf input datafile file number=00005 name=/u01/app/oracle/oradata/ORCL1/pdbseed/system01.dbf input datafile file number=00008 name=/u01/app/oracle/oradata/ORCL1/pdbseed/undotbs01.dbf channel ORA_DISK_1: starting piece 1 at 19-APR-20 channel ORA_DISK_1: finished piece 1 at 19-APR-20 piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0guu272n_1_1 tag=TAG20200419T183653 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 Finished backup at 19-APR-20 Starting Control File and SPFILE Autobackup at 19-APR-20 piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-1414679838-20200419-03 comment=NONE Finished Control File and SPFILE Autobackup at 19-APR-20 RMAN> [/code]