miércoles, 26 de junio de 2013

Vistas de catálogo de RMAN txt

-- Archived and unarchived redo logs
-- RC_ARCHIVED_LOG

SELECT * FROM V$ARCHIVED_LOG;

-- Control files in backup sets
--RC_BACKUP_CONTROLFILE

SELECT * FROM V$BACKUP_DATAFILE ;

-- Corrupt block ranges in datafile backups
-- RC_BACKUP_CORRUPTION
SELECT * FROM V$BACKUP_CORRUPTION ;

-- Datafiles in backup sets
-- RC_BACKUP_DATAFILE

SELECT * FROM V$BACKUP_DATAFILE ;

-- RMAN backups and copies in the repository.
-- RC_BACKUP_FILES
SELECT * FROM V$BACKUP_FILES  ;

-- Backup pieces
--  RC_BACKUP_PIECE
SELECT * FROM V$BACKUP_PIECE ;

-- Archived logs in backups
-- RC_BACKUP_REDOLOG
SELECT * FROM V$BACKUP_REDOLOG   ;

-- Backup sets
-- RC_BACKUP_SET
SELECT * FROM V$BACKUP_SET  ;

-- Server parameter files in backup sets
-- RC_BACKUP_SPFILE
SELECT * FROM V$BACKUP_SPFILE ;

-- Control file copies on disk
-- RC_CONTROLFILE_COPY
SELECT * FROM V$DATAFILE_COPY  ;

-- Ejemplo: /export/home/oracle/rda/output/TMP_RDA/RDA_BR_T28903_01_control.tmp

-- Control file copies on disk
-- RC_COPY_CORRUPTION
SELECT * FROM V$COPY_CORRUPTION ;

-- Databases registered in the recovery catalog (RC_DATABASE) or information about the currently
-- RC_DATABASE
SELECT * FROM V$DATABASE ;

-- Database blocks marked as corrupt in the most recent RMAN backup or copy
-- mounted database (V$DATABASE)
-- RC_DATABASE_BLOCK_CORRUPTION
SELECT * FROM V$DATABASE_BLOCK_CORRUPTION ;

-- All database incarnations registered in the catalog
-- RC_DATABASE_INCARNATION
SELECT * FROM V$DATABASE_INCARNATION ;

-- All datafiles registered in the recovery catalog
-- RC_DATAFILE
SELECT * FROM V$DATAFILE ;

-- Datafile image copies
-- RC_DATAFILE_COPY
SELECT * FROM V$DATAFILE_COPY ;

-- Historical information about online redo logs
-- RC_LOG_HISTORY
SELECT * FROM V$LOG_HISTORY ;

-- Offline ranges for datafiles
-- RC_OFFLINE_RANGE
SELECT * FROM V$OFFLINE_RANGE ;

-- Archived log backups created by proxy copy
-- RC_PROXY_ARCHIVEDLOG
SELECT * FROM V$PROXY_ARCHIVEDLOG ;

-- Control file backups created by proxy copy
-- RC_PROXY_CONTROLFILE
SELECT * FROM V$PROXY_DATAFILE ;

-- Datafile backups created by proxy copy
-- RC_PROXY_DATAFILE
SELECT * FROM V$PROXY_DATAFILE ;

-- Online redo logs for all incarnations of the database since the last catalog resynchronization
-- RC_REDO_LOG
-- V$LOG and V$LOGFILE
SELECT * FROM v$log  ;
SELECT * FROM v$logfile;

-- All redo threads for all incarnations of the database since the last catalog resynchronization
-- RC_RESYNC
-- RC_REDO_THREAD
SELECT * FROM V$THREAD;
-- n/a

-- Recovery catalog resynchronizations
-- RC_RMAN_CONFIGURATION
SELECT * FROM V$RMAN_CONFIGURATION;

-- RMAN persistent configuration settings
-- RC_TABLESPACE
SELECT * FROM V$TABLESPACE ;

No hay comentarios: