--Archived and unarchived redo logs
SELECT * FROM RC_ARCHIVED_LOG
--Details about archived redo log backups for Enterprise Manager
SELECT * FROM RC_BACKUP_ARCHIVELOG_DETAILS
--Summary of information about archived redo log backups for Enterprise Manager
SELECT * FROM RC_BACKUP_ARCHIVELOG_SUMMARY
--Control files backed up in backup sets
SELECT * FROM RC_BACKUP_CONTROLFILE
--Details about control file backups for Enterprise Manager
SELECT * FROM RC_BACKUP_CONTROLFILE_DETAILS
--Summary of information about control file backups for Enterprise Manager
SELECT * FROM RC_BACKUP_CONTROLFILE_SUMMARY
--Details about datafile image copy backups for Enterprise Manager
SELECT * FROM RC_BACKUP_COPY_DETAILS
--Summary of information about datafile image copy backups for Enterprise Manager
SELECT * FROM RC_BACKUP_COPY_SUMMARY
--Corrupt block ranges in datafile backups
SELECT * FROM RC_BACKUP_CORRUPTION
--Datafiles in backup sets
SELECT * FROM RC_BACKUP_DATAFILE
--Details about datafile backups for Enterprise Manager
SELECT * FROM RC_BACKUP_DATAFILE_DETAILS
--Summary of information about datafile backups for Enterprise Manager
SELECT * FROM RC_BACKUP_DATAFILE_SUMMARY
--RMAN backups and copies known to the repository.
SELECT * FROM RC_BACKUP_FILES
--Backup pieces
SELECT * FROM RC_BACKUP_PIECE
--Details about backup pieces for Enterprise Manager
SELECT * FROM RC_BACKUP_PIECE_DETAILS
--Archived redo logs in backup sets
SELECT * FROM RC_BACKUP_REDOLOG
--Backup sets for all incarnations of databases registered in the catalog
SELECT * FROM RC_BACKUP_SET
--Details about backup sets for Enterprise Manager
SELECT * FROM RC_BACKUP_SET_DETAILS
--Summary of information about backup sets for Enterprise Manager
SELECT * FROM RC_BACKUP_SET_SUMMARY
--Server parameter files in backups
SELECT * FROM RC_BACKUP_SPFILE
--Details about SPFILE backups for Enterprise Manager
SELECT * FROM RC_BACKUP_SPFILE_DETAILS
--Summary of information about SPFILE backups for Enterprise Manager
SELECT * FROM RC_BACKUP_SPFILE_SUMMARY
--Deprecated in favor of RC_RESYNC
SELECT * FROM RC_CHECKPOINT
--Control file copies on disk
SELECT * FROM RC_CONTROLFILE_COPY
--Corrupt block ranges in datafile copies
SELECT * FROM RC_COPY_CORRUPTION
--Databases registered in the recovery catalog
SELECT * FROM RC_DATABASE
--Database blocks marked as corrupted in the most recent RMAN backup or copy
SELECT * FROM RC_DATABASE_BLOCK_CORRUPTION
--Database incarnations registered in the recovery catalog
SELECT * FROM RC_DATABASE_INCARNATION
--Datafiles registered in the recovery catalog
SELECT * FROM RC_DATAFILE
--Datafile copies on disk
SELECT * FROM RC_DATAFILE_COPY
--Online redo log history indicating when log switches occurred
SELECT * FROM RC_LOG_HISTORY
--Offline ranges for datafiles
SELECT * FROM RC_OFFLINE_RANGE
--Output FROM RMAN commands for use in Enterprise Manager
SELECT * FROM RC_RMAN_OUTPUT
--Output FROM RMAN commands for use in Enterprise Manager
SELECT * FROM RC_REDO_LOG
--All redo threads for all incarnations of the database since the last catalog resynchronization
SELECT * FROM RC_REDO_THREAD
--Recovery catalog resynchronizations
SELECT * FROM RC_RESYNC
--Details about backup jobs for Enterprise Manager
SELECT * FROM RC_RMAN_BACKUP_JOB_DETAILS
--Details about backup subjobs for Enterprise Manager
SELECT * FROM RC_RMAN_BACKUP_SUBJOB_DETAILS
--Used internally by Enterprise Manager
SELECT * FROM RC_RMAN_BACKUP_TYPE
--RMAN configuration settings
SELECT * FROM RC_RMAN_CONFIGURATION
--Historical status information about RMAN operations
SELECT * FROM RC_RMAN_STATUS
--Names of scripts stored in the recovery catalog
SELECT * FROM RC_STORED_SCRIPT
--Contents of the scripts stored in the recovery catalog
SELECT * FROM RC_STORED_SCRIPT_LINE
--All tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old incarnations
SELECT * FROM RC_TABLESPACE
--All tempfiles registered in the recovery catalog
SELECT * FROM RC_TEMPFILE
--Unusable backup files registered in the recovery catalog
SELECT * FROM RC_UNUSABLE_BACKUPFILE_DETAILS