RMAN Important Views
select table_name from dict where table_name like 'V$%RMAN%';
V$RMAN_BACKUP_JOB_DETAILS è displays details about backup jobs.
V$RMAN_BACKUP_SUBJOB_DETAILS è merges similar operations within an RMAN session into a single row. For example, if there are four BACKUP DATAFILE <n> commands, three RECOVERY COPY OF DATAFILE commands, and one BACKUP RECOVERY AREA command, this view will contain three rows - one each for BACKUP, ROLLFORWARD, and COPY_DISK_TO_TAPE operation.
V$RMAN_BACKUP_TYPEè displays information about RMAN backup types.
SQL> select * from V$RMAN_BACKUP_TYPE;
WEIGHT INPUT_TYPE
---------- -------------
1 BACKUPSET
2 SPFILE
3 CONTROLFILE
4 ARCHIVELOG
5 DATAFILE INCR
6 DATAFILE FULL
7 DB INCR
8 RECVR AREA
9 DB FULL
V$RMAN_COMPRESSION_ALGORITHM : provides descriptions of supported compression algorithms. It is used by the RMAN client.
V$RMAN_CONFIGURATION : Information about RMAN persistent configuration settings.
V$RMAN_ENCRYPTION_ALGORITHMS : displays supported encryption algorithms. It is used by the RMAN client to validate user-requested algorithms. This view will list AES128, AES192, and AES256 encryption algorithms for the current release. The default algorithm is AES128.
V$RMAN_OUTPUT : displays messages reported by RMAN. This is an in-memory view and is not recorded in the controlfile. The view can hold 32768 rows.
V$RMAN_STATUS : displays the finished and on-going RMAN jobs. For on-going jobs, this view displays progress and status. The jobs which are in progress are stored only in memory while the finished jobs are stored in the controlfile
V$ARCHIVED_LOG : show which archives have been created, backed up, and cleared in the database.
V$BACKUP_CORRUPTION : shows which blocks have been found to be corrupt during a backup of a backup set
V$BACKUP_DATAFILE : useful for creating equal-sized backup sets by determining the number of blocks in each datafile. It can also help you find the number of corrupt blocks in the datafile
V$BACKUP_DEVICE : display information about supported backup devices. DISK is not returned because it is always available
V$BACKUP_FILES : display information about all RMAN backups (image copies and backup sets) and archived logs. The view simulates the LIST BACKUP and LIST COPYcommands
V$BACKUP_PIEC : show backup pieces created for backup sets
V$BACKUP_REDOLOG : show archived logs stored in backup sets
V$BACKUP_SET : show backup sets that have been created
V$BACKUP_SPFILE : display information about server parameter files in backup sets
V$COPY_CORRUPTION : show which blocks have been found to be corrupt during an image copy
V$DATABASE_BLOCK_CORRUPTION : list database blocks marked as corrupt during the most recent RMAN backup
V$RMAN_CONFIGURATION : list information about RMAN persistent configuration settings
V$PROXY_ARCHIVEDLOG, V$PROXY_DATAFILE : proxy settings for RMAN
V$BACKUP_ASYNC_IO, V$BACKUP_SYNC_IO : backup performance statistics
select table_name from dict where table_name like 'V$%RMAN%';
V$RMAN_BACKUP_JOB_DETAILS è displays details about backup jobs.
V$RMAN_BACKUP_SUBJOB_DETAILS è merges similar operations within an RMAN session into a single row. For example, if there are four BACKUP DATAFILE <n> commands, three RECOVERY COPY OF DATAFILE commands, and one BACKUP RECOVERY AREA command, this view will contain three rows - one each for BACKUP, ROLLFORWARD, and COPY_DISK_TO_TAPE operation.
V$RMAN_BACKUP_TYPEè displays information about RMAN backup types.
SQL> select * from V$RMAN_BACKUP_TYPE;
WEIGHT INPUT_TYPE
---------- -------------
1 BACKUPSET
2 SPFILE
3 CONTROLFILE
4 ARCHIVELOG
5 DATAFILE INCR
6 DATAFILE FULL
7 DB INCR
8 RECVR AREA
9 DB FULL
V$RMAN_COMPRESSION_ALGORITHM : provides descriptions of supported compression algorithms. It is used by the RMAN client.
V$RMAN_CONFIGURATION : Information about RMAN persistent configuration settings.
V$RMAN_ENCRYPTION_ALGORITHMS : displays supported encryption algorithms. It is used by the RMAN client to validate user-requested algorithms. This view will list AES128, AES192, and AES256 encryption algorithms for the current release. The default algorithm is AES128.
V$RMAN_OUTPUT : displays messages reported by RMAN. This is an in-memory view and is not recorded in the controlfile. The view can hold 32768 rows.
V$RMAN_STATUS : displays the finished and on-going RMAN jobs. For on-going jobs, this view displays progress and status. The jobs which are in progress are stored only in memory while the finished jobs are stored in the controlfile
V$ARCHIVED_LOG : show which archives have been created, backed up, and cleared in the database.
V$BACKUP_CORRUPTION : shows which blocks have been found to be corrupt during a backup of a backup set
V$BACKUP_DATAFILE : useful for creating equal-sized backup sets by determining the number of blocks in each datafile. It can also help you find the number of corrupt blocks in the datafile
V$BACKUP_DEVICE : display information about supported backup devices. DISK is not returned because it is always available
V$BACKUP_FILES : display information about all RMAN backups (image copies and backup sets) and archived logs. The view simulates the LIST BACKUP and LIST COPYcommands
V$BACKUP_PIEC : show backup pieces created for backup sets
V$BACKUP_REDOLOG : show archived logs stored in backup sets
V$BACKUP_SET : show backup sets that have been created
V$BACKUP_SPFILE : display information about server parameter files in backup sets
V$COPY_CORRUPTION : show which blocks have been found to be corrupt during an image copy
V$DATABASE_BLOCK_CORRUPTION : list database blocks marked as corrupt during the most recent RMAN backup
V$RMAN_CONFIGURATION : list information about RMAN persistent configuration settings
V$PROXY_ARCHIVEDLOG, V$PROXY_DATAFILE : proxy settings for RMAN
V$BACKUP_ASYNC_IO, V$BACKUP_SYNC_IO : backup performance statistics
No comments:
Post a Comment