V$BACKUP_DEVICE

V$BACKUP_DEVICE displays information about supported backup devices. If a device type does not support named devices, then one row with the device type and a null device name is returned for that device type. If a device type supports named devices then one row is returned for each available device of that type. The special device type DISK is not returned by this view because it is always available.

Column	Datatype	Description
DEVICE_TYPE	VARCHAR2(17)	Type of the backup device
DEVICE_NAME	VARCHAR2(513)	Name of the backup device

Note:

1.       Oracle errors related with V$BACKUP_DEVICE

Error:   ORA-27001 Text:    unsupported device type --------------------------------------------------------------------------- Cause:   the specified device type is NOT supported on this platform Action:  check V$BACKUP_DEVICE for supported device types

Error:   ORA-4350 Text:    unsupported device type --------------------------------------------------------------------------- Cause:   the specified device type is unsupported on this platform Action:  check V$BACKUP_DEVICE for supported device types

Error:   ORA-27020 Text:    named devices not supported --------------------------------------------------------------------------- Cause:   the platform or the specified device type does not support named devices Action:  do not specify device name or use a device type that supports named devices. Use           V$BACKUP_DEVICE view to see what device types and names (if any) are available.

2.       select * from v$backup_device;

SQL>  SELECT * FROM V$BACKUP_DEVICE; DEVICE_TYPE       DEVICE_NAM ----------------- ---------- SBT_TAPE

Oracle data dictionary views

Oracle dynamic performance views

Last updated: Monday, September 14, 2009

V$RECOVERY_AREA_USAGE

V$RECOVERY_AREA_USAGE displays usage information about recovery areas.

Column	Datatype	Description
FILE_TYPE	VARCHAR2(20)	File type: CONTROL FILE REDO LOG ARCHIVED LOG BACKUP PIECE IMAGE COPY FLASHBACK LOG REMOTE ARCHIVED LOG
PERCENT_SPACE_USED	NUMBER	Percent of the recovery area that is in use
PERCENT_SPACE_RECLAIMABLE	NUMBER	Percent of the recovery area that is reclaimable
NUMBER_OF_FILES	NUMBER	Number of files in the recovery area

Note:

1.       Replace V$FLASH_RECOVERY_AREA_USAGE in 11g.

2.       Query the V$RECOVERY_AREA_USAGE view to find out the percentage of the total disk quota used by different types of files. Also, you can determine how much space for each type of file can be reclaimed by deleting files that are obsolete, redundant, or already backed up to tape. For example, enter the following query (sample output included):

SELECT * FROM   V$RECOVERY_AREA_USAGE; FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES ------------ ------------------ ------------------------- --------------- CONTROLFILE                   0                         0               0 ONLINELOG                     2                         0              22 ARCHIVELOG                 4.05                      2.01              31 BACKUPPIECE                3.94                      3.86               8 IMAGECOPY                 15.64                     10.43              66 FLASHBACKLOG                .08                         0               1

Oracle data dictionary views

Oracle dynamic performance views

Last updated: Monday, September 14, 2009