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
Last updated: Monday, September 14, 2009 |
No comments:
Post a Comment