-- Database
select * from RCAT.RC_DATABASE where DB_KEY = NNNN;
-- Contorl File
select * from RCAT.RC_CONTROLFILE_COPY where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_CONTROLFILE where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_CONTROLFILE_DETAILS where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_CONTROLFILE_SUMMARY where DB_KEY = NNNN;
-- Image Copy
select * from RCAT.RC_BACKUP_COPY_DETAILS where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_COPY_SUMMARY where DB_KEY = NNNN;
-- Data file
select * from RCAT.RC_DATAFILE where DB_KEY = NNNN;
select * from RCAT.RC_DATAFILE_COPY where DB_KEY = NNNN;
-- Backup Data file
select * from RCAT.RC_BACKUP_DATAFILE where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_DATAFILE_DETAILS where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_DATAFILE_SUMMARY where DB_KEY = NNNN;
-- Spfile
select * from RCAT.RC_BACKUP_SPFILE where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_SPFILE_DETAILS where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_SPFILE_SUMMARY where DB_KEY = NNNN;
-- Redo Logs
select * from RCAT.RC_REDO_THREAD where DB_KEY = NNNN;
select * from RCAT.RC_REDO_LOG where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_REDOLOG where DB_KEY = NNNN;
-- Archive Log
select * from RCAT.RC_ARCHIVED_LOG where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_ARCHIVELOG_DETAILS where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_ARCHIVELOG_SUMMARY where DB_KEY = NNNN;
-- Backup Set
select * from RCAT.RC_BACKUP_SET where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_SET_DETAILS where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_SET_SUMMARY where DB_KEY = NNNN;
-- Tablespace
select * from RCAT.RC_TABLESPACE where DB_KEY = NNNN;
-- Tempfiles
select * from RCAT.RC_TEMPFILE where DB_KEY = NNNN;
-- Backup Piece
select * from RCAT.RC_BACKUP_PIECE where DB_KEY = NNNN;
select * from RCAT.RC_BACKUP_PIECE_DETAILS where DB_KEY = NNNN;
select * from RCAT.RC_CHECKPOINT where DB_KEY = NNNN;
select * from RCAT.RC_COPY_CORRUPTION where DB_KEY = NNNN;
select * from RCAT.RC_DATABASE_BLOCK_CORRUPTION where DB_KEY = NNNN;
select * from RCAT.RC_DATABASE_INCARNATION where DB_KEY = NNNN;
select * from RCAT.RC_LOG_HISTORY where DB_KEY = NNNN;
select * from RCAT.RC_RESYNC where DB_KEY = NNNN;
select * from RCAT.RC_RMAN_STATUS where DB_KEY = NNNN;
select * from RCAT.RC_RMAN_BACKUP_JOB_DETAILS where DB_KEY = NNNN;
select * from RCAT.RC_RMAN_BACKUP_SUBJOB_DETAILS where DB_KEY = NNNN;
select * from RCAT.RC_RMAN_CONFIGURATION where DB_KEY = NNNN;
select * from RCAT.RC_RMAN_OUTPUT where DB_KEY = NNNN order by stamp;
select * from RCAT.RC_BACKUP_CORRUPTION where DB_KEY = NNNN;
Thanks
Adarsh Kumar
AK Technosoft Corp.
www.aktechnosoft.com