RMAN : le catalogue et les vues de son référentiel - RMAN: the catalog and the views of its repository

11 décembre 2020

RMAN : le catalogue et les vues de son référentiel - RMAN: the catalog and the views of its repository

Introduction
Installer un catalogue RMAN permet de profiter de plusieurs fonctionnalités (voir cet article : http://dbaoraclesql.canalblog.com/archives/2020/11/05/38630569.html).

Attardons-nous aujourd'hui sur le repository (référentiel en français), constitué de 74 vues commençant par RC_. Celles-ci permettent d'interroger les sauvegardes RMAN avec toute la puissance du SQL via des SELECTs, sans utiliser les commandes LIST ou REPORT.

Attention, sans catalogue RMAN vous avez accès aussi à des vues pour interroger les backups RMAN. Mais ces vues, commençant par V$, sont liées à une base et une seule (sauf si architecture CDB) alors que dans un catalogue, les vues stockent les metadatas des sauvegardes de N bases de N serveurs Linux/Unix différents. Ici une correspondance des vues pour Oracle 12c; attention, il n'y a que 61 vues V$ contre 74 vues RC_ pour le catalogue... https://docs.oracle.com/database/121/RCMRF/rcviews1.htm#RCMRF1923.

Points d'attention
N/A.

Base de tests
Une base Oracle 18c multi-tenants contenant un catalogue RMAN.

Exemples

============================================================================================
Les vues du repository du catalogue RMAN
============================================================================================
On se connecte avec SQL*Plus à la base contenant le catalogue RMAN, avec le user créé à cette occasion qui est propriétaire du catalogue (voir mon article précédent sur la création du catalogue).
La liste des 74 vues dont 21 sur les backups (celles commençant par RC_BACKUP_).
SQL> select object_name from dba_objects where object_name like 'RC/_%' escape '/' order by 1;
OBJECT_NAME
--------------------------------------------
RC_ARCHIVED_LOG
RC_BACKUP_ARCHIVELOG_DETAILS
RC_BACKUP_ARCHIVELOG_SUMMARY
RC_BACKUP_CONTROLFILE
RC_BACKUP_CONTROLFILE_DETAILS
RC_BACKUP_CONTROLFILE_SUMMARY
RC_BACKUP_COPY_DETAILS
RC_BACKUP_COPY_SUMMARY
RC_BACKUP_CORRUPTION
RC_BACKUP_DATAFILE
RC_BACKUP_DATAFILE_DETAILS
RC_BACKUP_DATAFILE_SUMMARY
RC_BACKUP_FILES
RC_BACKUP_PIECE
RC_BACKUP_PIECE_DETAILS
RC_BACKUP_REDOLOG
RC_BACKUP_SET
RC_BACKUP_SET_DETAILS
RC_BACKUP_SET_SUMMARY
RC_BACKUP_SPFILE
RC_BACKUP_SPFILE_DETAILS
RC_BACKUP_SPFILE_SUMMARY
RC_CHECKPOINT
RC_CONTROLFILE_COPY
RC_COPY_CORRUPTION
RC_CURRENT_XMLFILE
RC_DATABASE
RC_DATABASE_BLOCK_CORRUPTION
RC_DATABASE_INCARNATION
RC_DATAFILE
RC_DATAFILE_COPY
RC_DELETED_OBJECT
RC_DISK_RESTORE_RANGE
RC_LBRECSETIMPL_T
RC_LBRECSETIMPL_T
RC_LBRECSET_T
RC_LBREC_T
RC_LISTBACKUPPIPE
RC_LISTRSRANGEPIPE
RC_LOG_HISTORY
RC_OFFLINE_RANGE
RC_PDBS
RC_PLUGGABLE_DATABASE_INC
RC_PROXY_ARCHIVEDLOG
RC_PROXY_ARCHIVELOG_DETAILS
RC_PROXY_ARCHIVELOG_SUMMARY
RC_PROXY_CONTROLFILE
RC_PROXY_COPY_DETAILS
RC_PROXY_COPY_SUMMARY
RC_PROXY_DATAFILE
RC_RANGERECSETIMPL_T
RC_RANGERECSETIMPL_T
RC_RANGERECSET_T
RC_RANGEREC_T
RC_RCVER
RC_REDO_LOG
RC_REDO_THREAD
RC_RESTORE_POINT
RC_RESTORE_RANGE
RC_RESYNC
RC_RMAN_BACKUP_JOB_DETAILS
RC_RMAN_BACKUP_SUBJOB_DETAILS
RC_RMAN_BACKUP_TYPE
RC_RMAN_CONFIGURATION
RC_RMAN_OUTPUT
RC_RMAN_STATUS
RC_SBT_RESTORE_RANGE
RC_SITE
RC_STORED_SCRIPT
RC_STORED_SCRIPT_LINE
RC_TABLESPACE
RC_TEMPFILE
RC_UNUSABLE_BACKUPFILE_DETAILS
RC_WATERMARKS
74 rows selected.

Dans la doc Oracle, sur la page "Summary of RMAN Recovery Catalog Views", il n'y en a que 61 de répertoriées avec leur équivalent en V$ alors qu'ici il y en a 74 : d'où l'intérêt d'avoir un catalogue RMAN pour accéder à plus d'infos https://docs.oracle.com/database/121/RCMRF/rcviews1.htm#RCMRF1923.

============================================================================================
Quelques vues
============================================================================================
Là où ces vues sont très utiles, c'est que certaines renferment des infos qu'on ne trouve pas ailleurs dans la base Oracle, ou moins facilement.

Vues sur les tablespaces
Par exemple, dans la vue RC_TABLESPACE, nous avons la date de suppression d'un tablespace. Pour mes tests, j'avais supprimé le tbs ZZTBS le 20/11/2020 08:26:53 puis restauré le 20/11/2020 08:41:12! A part aller dans le fichier alert_<SID>.log ou utiliser logminer, cette info n'est pas disponible dans la base Oracle; intéressant!
SQL> break on DB_NAME on PDB_NAME skip 1
SQL> select DB_NAME, PDB_NAME, TS#, NAME, to_char(CREATION_TIME,'DD/MM/YYYY HH24:MI:SS') as "CREATION_TIME", to_char(DROP_TIME,'DD/MM/YYYY HH24:MI:SS') as "DROP_TIME" from RC_TABLESPACE order by 1, 2, 3:
DB_NAME PDB_NAME TS# NAME CREATION_TIME DROP_TIME
-------- -------------------- ---------- ----------
ORCL12C ORCL 0 SYSTEM 02/03/2017 07:57:32
      1 SYSAUX 02/03/2017 07:57:32
      2 UNDOTBS1 02/03/2017 07:57:32
      3 TEMP 02/03/2017 07:57:32
      5 USERS 02/03/2017 07:58:02
      6 APEX_1991375173370654 02/03/2017 08:41:45
      7 APEX_1993195660370985 02/03/2017 08:41:48
      8 ZZTBS 20/11/2020 07:40:08 20/11/2020 08:26:53
      8 ZZTBS 20/11/2020 08:41:12
      9 ZZTBS02 20/11/2020 08:23:32
   ORDS 0 SYSTEM 19/11/2020 08:22:30
      1 SYSAUX 19/11/2020 08:22:30
      2 UNDOTBS1 19/11/2020 08:22:30
      3 TEMP 19/11/2020 08:22:30
      5 USERS 19/11/2020 08:22:31
      6 CATALOG_RMAN 19/11/2020 08:40:30
   PDB$SEED 0 SYSTEM 02/03/2017 07:53:20
      1 SYSAUX 02/03/2017 07:53:20
      2 UNDOTBS1 02/03/2017 07:53:20
      3 TEMP 02/03/2017 07:53:20
      0 SYSTEM 26/01/2017 13:52:40
      1 SYSAUX 26/01/2017 13:53:09
      3 TEMP 02/03/2017 07:52:48
      4 USERS 26/01/2017 13:54:50
      5 UNDOTBS2 02/03/2017 08:45:58
25 rows selected.

Vues sur les datafiles
Idem pour les datafiles : dans cdb_data_files on a les datafiles actuels de la base MAIS, dans RC_DATAFILE, on a en plus un historique avec les datafiles qui ont été supprimé avec le tablespace ZZTBS! C'est sympa :-)
Dans cdb_data_files j'ai une ligne pour le tbs ZZTBS mais c'est celui qui a été restauré; son file id est 23.
SQL> select TABLESPACE_NAME, FILE_NAME, FILE_ID from cdb_data_files order by 2;
TABLESPACE_NAME FILE_NAME FILE_ID
------------------------------ -----------------------------------------
CATALOG_RMAN /u01/app/oracle/oradata/orcl12c/ORDS/catalog_rman.dbf 20
SYSAUX /u01/app/oracle/oradata/orcl12c/ORDS/sysaux01.dbf 17
SYSTEM /u01/app/oracle/oradata/orcl12c/ORDS/system01.dbf 16
UNDOTBS1 /u01/app/oracle/oradata/orcl12c/ORDS/undotbs01.dbf 18
USERS /u01/app/oracle/oradata/orcl12c/ORDS/users01.dbf 19
APEX_1991375173370654 /u01/app/oracle/oradata/orcl12c/orcl/APEX_1991375173370654.dbf 13
APEX_1993195660370985 /u01/app/oracle/oradata/orcl12c/orcl/APEX_1993195660370985.dbf 14
ZZTBS02 /u01/app/oracle/oradata/orcl12c/orcl/ZZTBS02.dbf 22
SYSAUX /u01/app/oracle/oradata/orcl12c/orcl/sysaux01.dbf 10
SYSTEM /u01/app/oracle/oradata/orcl12c/orcl/system01.dbf 9
UNDOTBS1 /u01/app/oracle/oradata/orcl12c/orcl/undotbs01.dbf 11
USERS /u01/app/oracle/oradata/orcl12c/orcl/users01.dbf 12
ZZTBS /u01/app/oracle/oradata/orcl12c/orcl/zztbs.dbf 23
SYSAUX /u01/app/oracle/oradata/orcl12c/sysaux01.dbf 3
SYSTEM /u01/app/oracle/oradata/orcl12c/system01.dbf 1
UNDOTBS2 /u01/app/oracle/oradata/orcl12c/undotbs2.dbf 15
USERS /u01/app/oracle/oradata/orcl12c/users01.dbf 7
17 rows selected.

Dans RC_DATAFILE, j'ai deux lignes pour le tbs ZZTBS, la ligne de celui supprimé avec le file id 21 et celui qui a été restauré de file id 23.
SQL> select DB_NAME, PDB_NAME, TABLESPACE_NAME, NAME, FILE#, to_char(CREATION_TIME,'DD/MM/YYYY HH24:MI:SS') as "CREATION_TIME", to_char(DROP_TIME,'DD/MM/YYYY HH24:MI:SS') as "DROP_TIME" from RC_DATAFILE order by 1, 2, 3, 4;
DB_NAME PDB_NAME TABLESPACE_NAME NAME FILE# CREATION_TIME DROP_TIME
-------- -------------------- ------------------------------ -------------------------------
ORCL12C ORCL APEX_1991375173370654 /u01/app/oracle/oradata/orcl12c/orcl/APEX_1991375173370654.dbf 13 02/03/2017 08:41:45
      APEX_1993195660370985 /u01/app/oracle/oradata/orcl12c/orcl/APEX_1993195660370985.dbf 14 02/03/2017 08:41:48
      SYSAUX /u01/app/oracle/oradata/orcl12c/orcl/sysaux01.dbf 10 02/03/2017 07:57:32
      SYSTEM /u01/app/oracle/oradata/orcl12c/orcl/system01.dbf 9 02/03/2017 07:57:32
      UNDOTBS1 /u01/app/oracle/oradata/orcl12c/orcl/undotbs01.dbf 11 02/03/2017 07:57:32
      USERS /u01/app/oracle/oradata/orcl12c/orcl/users01.dbf 12 02/03/2017 07:58:02
      ZZTBS /u01/app/oracle/oradata/orcl12c/orcl/zztbs.dbf 21 20/11/2020 07:40:08 20/11/2020 08:26:53
      ZZTBS /u01/app/oracle/oradata/orcl12c/orcl/zztbs.dbf 23 20/11/2020 08:41:12
      ZZTBS02 /u01/app/oracle/oradata/orcl12c/orcl/ZZTBS02.dbf 22 20/11/2020 08:23:32
   ORDS CATALOG_RMAN /u01/app/oracle/oradata/orcl12c/ORDS/catalog_rman.dbf 20 19/11/2020 08:40:30
      SYSAUX /u01/app/oracle/oradata/orcl12c/ORDS/sysaux01.dbf 17 19/11/2020 08:22:30
      SYSTEM /u01/app/oracle/oradata/orcl12c/ORDS/system01.dbf 16 19/11/2020 08:22:30
      UNDOTBS1 /u01/app/oracle/oradata/orcl12c/ORDS/undotbs01.dbf 18 19/11/2020 08:22:30
      USERS /u01/app/oracle/oradata/orcl12c/ORDS/users01.dbf 19 19/11/2020 08:22:31
   PDB$SEED SYSAUX /u01/app/oracle/oradata/orcl12c/pdbseed/sysaux01.dbf 6 02/03/2017 07:53:20
      SYSTEM /u01/app/oracle/oradata/orcl12c/pdbseed/system01.dbf 5 02/03/2017 07:53:20
      UNDOTBS1 /u01/app/oracle/oradata/orcl12c/pdbseed/undotbs01.dbf 8 02/03/2017 07:53:20
      SYSAUX /u01/app/oracle/oradata/orcl12c/sysaux01.dbf 3 26/01/2017 13:53:09
      SYSTEM /u01/app/oracle/oradata/orcl12c/system01.dbf 1 26/01/2017 13:52:40
      UNDOTBS2 /u01/app/oracle/oradata/orcl12c/undotbs2.dbf 15 02/03/2017 08:45:58
      USERS /u01/app/oracle/oradata/orcl12c/users01.dbf 7 26/01/2017 13:54:50

Vues sur les backups
Le repository possède aussi des vues spécifiques aux backups, commençant par RC_BACKUP_; je pense que ce sont elles que RMAN interroge quand on fait un LIST BACKUP...
Voyons voir le contenu des vues RC_BACKUP_PIECE_DETAILS et RC_BACKUP_DATAFILE_DETAILS.
SQL> select B.DB_NAME, P.PDB_KEY, P.NAME, B.BS_KEY, B.BACKUP_TYPE, B.PIECE#, B.DEVICE_TYPE,TAG, to_char(B.START_TIME, 'DD/MM/YYYY HH24:MI:SS') as "START_TIME", B.ELAPSED_SECONDS, B.STATUS, B.BYTES from RC_BACKUP_PIECE_DETAILS B, RC_PDBS P WHERE B.PDB_KEY=P.PDB_KEY order by 1, 2, 3
DB_NAME PDB_KEY NAME BS_KEY B PIECE# DEVICE_TYP TAG START_TIME ELAPSED_SECONDS S BYTES
-------- ---------- ---------- ---------- - ---------- ---------- ---------------------
ORCL12C 7 PDB$SEED 417 D 1 DISK TAG20201120T081718 20/11/2020 08:19:35 13 A 537714688
      8 ORCL 414 D 1 DISK TAG20201120T081718 20/11/2020 08:17:19 48 A 1429889024
      9 ORDS 416 D 1 DISK TAG20201120T081718 20/11/2020 08:18:50 38 A 1024360448

SQL> select B.DB_NAME, B.PDB_NAME, B.TSNAME, B.FILE#, D.NAME, to_char(B.CREATION_TIME,'DD/MM/YYYY HH24:MI:SS') as "CREATION_TIME", B.FILESIZE_DISPLAY from RC_BACKUP_DATAFILE_DETAILS B, RC_DATAFILE D WHERE B.FILE# = D.FILE# ORDER BY 1, 2, 3;
DB_NAME PDB_NAME TSNAME FILE# NAME CREATION_TIME FILESIZE_D
-------- -------------------- ------------------------------ ---------- ------------------- -------------------
ORCL12C ORCL APEX_1991375173370654 13 /u01/app/oracle/oradata/orcl12c/orcl/APEX_1991375173370654.dbf 02/03/2017 08:41:45 7.57M
      APEX_1993195660370985 14 /u01/app/oracle/oradata/orcl12c/orcl/APEX_1993195660370985.dbf 02/03/2017 08:41:48 2.57M
      SYSAUX 10 /u01/app/oracle/oradata/orcl12c/orcl/sysaux01.dbf 02/03/2017 07:57:32 1.13G
      SYSTEM 9 /u01/app/oracle/oradata/orcl12c/orcl/system01.dbf 02/03/2017 07:57:32 340.01M
      UNDOTBS1 11 /u01/app/oracle/oradata/orcl12c/orcl/undotbs01.dbf 02/03/2017 07:57:32 460.01M
      USERS 12 /u01/app/oracle/oradata/orcl12c/orcl/users01.dbf 02/03/2017 07:58:02 73.76M
      ZZTBS 21 /u01/app/oracle/oradata/orcl12c/orcl/zztbs.dbf 20/11/2020 07:40:08 10.01M
   ORDS CATALOG_RMAN 20 /u01/app/oracle/oradata/orcl12c/ORDS/catalog_rman.dbf 19/11/2020 08:40:30 32.01M
      SYSAUX 17 /u01/app/oracle/oradata/orcl12c/ORDS/sysaux01.dbf 19/11/2020 08:22:30 360.01M
      SYSTEM 16 /u01/app/oracle/oradata/orcl12c/ORDS/system01.dbf 19/11/2020 08:22:30 260.01M
      UNDOTBS1 18 /u01/app/oracle/oradata/orcl12c/ORDS/undotbs01.dbf 19/11/2020 08:22:30 100.01M
      USERS 19 /u01/app/oracle/oradata/orcl12c/ORDS/users01.dbf 19/11/2020 08:22:31 547.01M
   PDB$SEED SYSAUX 6 /u01/app/oracle/oradata/orcl12c/pdbseed/sysaux01.dbf 02/03/2017 07:53:20 330.01M
      SYSTEM 5 /u01/app/oracle/oradata/orcl12c/pdbseed/system01.dbf 02/03/2017 07:53:20 250.01M
      UNDOTBS1 8 /u01/app/oracle/oradata/orcl12c/pdbseed/undotbs01.dbf 02/03/2017 07:53:20 100.01M
      SYSAUX 3 /u01/app/oracle/oradata/orcl12c/sysaux01.dbf 26/01/2017 13:53:09 470.01M
      SYSTEM 1 /u01/app/oracle/oradata/orcl12c/system01.dbf 26/01/2017 13:52:40 800.01M
      UNDOTBS2 15 /u01/app/oracle/oradata/orcl12c/undotbs2.dbf 02/03/2017 08:45:58 50.01M
      USERS 7 /u01/app/oracle/oradata/orcl12c/users01.dbf 26/01/2017 13:54:50 5.01M
19 rows selected.

Vue sur les messages RMAN
Tiens, une autre vue sympa, RC_RMAN_OUTPUT, qui stocke des infos des dernières opérations RMAN. Utile si on a oublié de copier/coller la sortie RMAN des dernières commandes.
Vous notez que l'on n'a pas les commandes RMAN exécutées dans ce listing mais la sortie à l'écran de celles-ci.
Que dit la doc Oracle?
RC_RMAN_OUTPUT corresponds to the control file view V$RMAN_OUTPUT.
This view is primarily for internal use by Enterprise Manager.
Column Data Type Description
DB_KEY NUMBER The primary key for the target database. Use this column to join with almost any other catalog view.
RSR_KEY NUMBER Unique key for the row in RC_RMAN_STATUS corresponding to the job that created this output.
SESSION_KEY NUMBER Session identifier. Use in joins with RC_RMAN_OUTPUT and RC_RMAN_BACKUP_JOB_DETAILS.
RECID NUMBER Contains the value displayed in V$RMAN_OUTPUT.RECID for this database.
STAMP NUMBER Stamp (used for ordering) of when the row for this line out output was added.
OUTPUT VARCHAR2(130) RMAN output text.

SQL> select * from RC_RMAN_OUTPUT order by stamp;
DB_KEY RSR_KEY SITE_KEY SESSION_KEY RECID STAMP OUTPUT
---------- ---------- ---------- ----------- ---------- ---------- ------------------
1 58 3 58 1 1056876212 connected to target database: ORCL12C (DBID=768045447)
1 58 3 58 2 1056876212 connected to recovery catalog database
1 58 3 58 3 1056876212
1 58 3 58 4 1056876222
1 58 3 58 5 1056876223 database registered in recovery catalog
1 58 3 58 6 1056876225 starting full resync of recovery catalog
1 58 3 58 8 1056876226
1 58 3 58 7 1056876226 full resync complete
1 58 3 58 9 1056876240
1 321 3 321 1 1056958551 connected to target database: ORCL12C (DBID=768045447)
1 322 3 322 2 1056958870 connected to target database: ORCL12C (DBID=768045447)
1 323 3 323 4 1056960407
1 323 3 323 3 1056960407 connected to target database: ORCL12C (DBID=768045447)
1 324 3 323 7 1056960412 Report of database schema for database with db_unique_name ORCL12C
1 324 3 323 8 1056960412
1 324 3 323 9 1056960412 List of Permanent Datafiles
1 324 3 323 10 1056960412 ===========================
1 324 3 323 11 1056960412 File Size(MB) Tablespace RB segs Datafile Name
1 324 3 323 12 1056960412 ---- -------- -------------------- ------- ------------------------
1 324 3 323 6 1056960412 using target database control file instead of recovery catalog
1 323 3 323 5 1056960412
1 324 3 323 24 1056960413 14 2 ORCL:APEX_1993195660370985 NO /u01/app/oracle/oradata/orcl12c/orcl/APEX_1993195660370985.dbf
1 324 3 323 26 1056960413 16 260 ORDS:SYSTEM YES /u01/app/oracle/oradata/orcl12c/ORDS/system01.dbf
1 324 3 323 27 1056960413 17 360 ORDS:SYSAUX NO /u01/app/oracle/oradata/orcl12c/ORDS/sysaux01.dbf
1 324 3 323 28 1056960413 18 100 ORDS:UNDOTBS1 YES /u01/app/oracle/oradata/orcl12c/ORDS/undotbs01.dbf
1 324 3 323 29 1056960413 19 547 ORDS:USERS NO /u01/app/oracle/oradata/orcl12c/ORDS/users01.dbf
1 324 3 323 30 1056960413 20 32 ORDS:CATALOG_RMAN NO /u01/app/oracle/oradata/orcl12c/ORDS/catalog_rman.dbf
1 324 3 323 31 1056960413 21 10 ORCL:ZZTBS NO /u01/app/oracle/oradata/orcl12c/orcl/zztbs.dbf
1 324 3 323 32 1056960413
1 324 3 323 33 1056960413 List of Temporary Files
1 324 3 323 34 1056960413 =======================
1 324 3 323 35 1056960413 File Size(MB) Tablespace Maxsize(MB) Tempfile Name
1 324 3 323 36 1056960413 ---- -------- -------------------- ----------- --------------------
1 324 3 323 37 1056960413 1 33 TEMP 32767 /u01/app/oracle/oradata/orcl12c/temp01.dbf
1 324 3 323 38 1056960413 2 64 PDB$SEED:TEMP 32767 /u01/app/oracle/oradata/orcl12c/pdbseed/temp012017-03-02_07-53-20-031-AM.dbf
1 324 3 323 39 1056960413 3 64 ORCL:TEMP 32767 /u01/app/oracle/oradata/orcl12c/orcl/temp01.dbf
1 324 3 323 40 1056960413 4 64 ORDS:TEMP 32767 /u01/app/oracle/oradata/orcl12c/ORDS/temp012017-03-02_07-53-20-031-AM.dbf
1 324 3 323 14 1056960413 3 470 SYSAUX NO /u01/app/oracle/oradata/orcl12c/sysaux01.dbf
1 324 3 323 13 1056960413 1 800 SYSTEM YES /u01/app/oracle/oradata/orcl12c/system01.dbf
1 324 3 323 23 1056960413 13 7 ORCL:APEX_1991375173370654 NO /u01/app/oracle/oradata/orcl12c/orcl/APEX_1991375173370654.dbf
1 324 3 323 22 1056960413 12 73 ORCL:USERS NO /u01/app/oracle/oradata/orcl12c/orcl/users01.dbf
1 324 3 323 21 1056960413 11 460 ORCL:UNDOTBS1 YES /u01/app/oracle/oradata/orcl12c/orcl/undotbs01.dbf
1 324 3 323 20 1056960413 10 1160 ORCL:SYSAUX NO /u01/app/oracle/oradata/orcl12c/orcl/sysaux01.dbf
1 324 3 323 19 1056960413 9 340 ORCL:SYSTEM YES /u01/app/oracle/oradata/orcl12c/orcl/system01.dbf
1 324 3 323 18 1056960413 8 100 PDB$SEED:UNDOTBS1 NO /u01/app/oracle/oradata/orcl12c/pdbseed/undotbs01.dbf
1 324 3 323 17 1056960413 7 5 USERS NO /u01/app/oracle/oradata/orcl12c/users01.dbf
1 324 3 323 16 1056960413 6 330 PDB$SEED:SYSAUX NO /u01/app/oracle/oradata/orcl12c/pdbseed/sysaux01.dbf
1 324 3 323 15 1056960413 5 250 PDB$SEED:SYSTEM NO /u01/app/oracle/oradata/orcl12c/pdbseed/system01.dbf
1 323 3 323 41 1056960413
1 324 3 323 25 1056960413 15 50 UNDOTBS2 YES /u01/app/oracle/oradata/orcl12c/undotbs2.dbf
1 323 3 323 42 1056960493
1 323 3 323 43 1056960493
1 323 3 323 44 1056960493
1 325 3 325 45 1056960797 connected to target database: ORCL12C (DBID=768045447)
1 325 3 325 46 1056960801 connected to recovery catalog database
...

On peut filtrer aussi pour afficher les opérations de RESTORE, avec les dates associées.
SQL> select * from RC_RMAN_OUTPUT where upper(OUTPUT) like '%RESTORE%' order by stamp;
DB_KEY RSR_KEY SITE_KEY SESSION_KEY RECID STAMP OUTPUT
---------- ---------- ---------- ----------- ---------- ---------- -----------------------------
1 525 3 325 342 1056961309 Starting restore at 11-20-2020 08:21:49
1 525 3 325 372 1056961310 Finished restore at 11-20-2020 08:21:50
1 584 3 573 601 1056962222 sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
1 591 3 573 609 1056962222 Starting restore at 11-20-2020 08:37:02
1 584 3 573 592 1056962222 # restore the controlfile
1 584 3 573 593 1056962222 restore clone controlfile;
1 591 3 573 613 1056962222 channel ORA_AUX_DISK_1: starting datafile backup set restore
1 591 3 573 620 1056962223 Finished restore at 11-20-2020 08:37:03
1 591 3 573 618 1056962223 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
1 591 3 573 617 1056962223 channel ORA_AUX_DISK_1: restored backup piece 1
1 584 3 573 626 1056962227 sql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end;
1 584 3 573 648 1056962229 # restore the tablespaces in the recovery set and the auxiliary set
1 584 3 573 649 1056962229 restore clone datafile 9, 1, 11, 15, 3, 10, 21;
1 624 3 573 681 1056962230 channel ORA_AUX_DISK_1: starting datafile backup set restore
1 624 3 573 678 1056962230 Starting restore at 11-20-2020 08:37:10
1 624 3 573 682 1056962230 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
1 624 3 573 690 1056962295 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05
1 624 3 573 691 1056962295 channel ORA_AUX_DISK_1: starting datafile backup set restore
1 624 3 573 692 1056962295 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
1 624 3 573 689 1056962295 channel ORA_AUX_DISK_1: restored backup piece 1
1 624 3 573 699 1056962342 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:47
1 624 3 573 700 1056962342 Finished restore at 11-20-2020 08:39:02
1 584 3 573 719 1056962342 # online the datafiles restored or switched
1 624 3 573 698 1056962342 channel ORA_AUX_DISK_1: restored backup piece 1
1 584 3 573 844 1056962474 sql 'begin dbms_backup_restore.AutoBackupFlag(TRUE); end;';
1 584 3 573 854 1056962475 sql statement: begin dbms_backup_restore.AutoBackupFlag(TRUE); end;

Nous n'avons regardé que 5 vues du catalogue RMAN et je pense que vous êtes convaincu de l'intérêt de celui-ci... je vous laisse maintenant vous amuser avec les autres vues et trouver les plus intéressantes pour vous :-)