View: RC_BACKUP_SET

Properties

Name: | RC_BACKUP_SET
Status: | VALID
Last modify: | 05/12/2002
Created: | 05/12/2002
Description: |

Columns

| Name | Type | Length | Nchar Length | Precision | Scale | NULL | Default | Comment | Updatable | Deletable | Insertable
| DB_KEY | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| DB_ID | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| BS_KEY | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| RECID | NUMBER |  |  |  |  | Y |  |  | YES | YES | YES
| STAMP | NUMBER |  |  |  |  | Y |  |  | YES | YES | YES
| SET_STAMP | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| SET_COUNT | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| BACKUP_TYPE | VARCHAR2 | 1 |  |  |  | Y |  |  | YES | YES | YES
| INCREMENTAL_LEVEL | NUMBER |  |  |  |  | Y |  |  | YES | YES | YES
| PIECES | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| START_TIME | DATE | 7 |  |  |  | Y |  |  | YES | YES | YES
| COMPLETION_TIME | DATE | 7 |  |  |  | Y |  |  | YES | YES | YES
| ELAPSED_SECONDS | NUMBER |  |  |  |  | Y |  |  | NO | NO | NO
| STATUS | VARCHAR2 | 1 |  |  |  | Y |  |  | YES | YES | YES
| CONTROLFILE_INCLUDED | VARCHAR2 | 7 |  |  |  | Y |  |  | YES | YES | YES
| INPUT_FILE_SCAN_ONLY | VARCHAR2 | 3 |  |  |  | Y |  |  | YES | YES | YES
| KEEP | VARCHAR2 | 3 |  |  |  | Y |  |  | NO | NO | NO
| KEEP_UNTIL | DATE | 7 |  |  |  | Y |  |  | YES | YES | YES
| KEEP_OPTIONS | VARCHAR2 | 10 |  |  |  | Y |  |  | NO | NO | NO

Total: 19 column(s)

Used by

Owner | Name | Type | Level
RMAN | RC_DATABASE_BLOCK_CORRUPTION | VIEW | 0
RMAN | DBMS_RCVMAN | PACKAGE BODY | 0

Total: 2 used by reference(s)

Uses

Owner | Name | Type | Level
OLAPSYS | DBA$OLAP2_DIM_LEVELS | VIEW | 1
OLAPSYS | DBA$OLAP_DIM_LEVELS | VIEW | 1

Total: 2 use reference(s)

DDL

CREATE OR REPLACE FORCE VIEW "RMAN"."RC_BACKUP_SET" ("DB_KEY", "DB_ID", "BS_KEY", "RECID", "STAMP", "SET_STAMP", "SET_COUNT", "BACKUP_TYPE", "INCREMENTAL_LEVEL", "PIECES", "START_TIME", "COMPLETION_TIME", "ELAPSED_SECONDS", "STATUS", "CONTROLFILE_INCLUDED", "INPUT_FILE_SCAN_ONLY", "KEEP", "KEEP_UNTIL", "KEEP_OPTIONS") AS
select db.db_key,
db.db_id,
bs.bs_key,
bs.bs_recid recid,
bs.bs_stamp stamp,
bs.set_stamp,
bs.set_count,
bs.bck_type backup_type,
bs.incr_level incremental_level,
bs.pieces,
bs.start_time,
bs.completion_time,
((bs.completion_time - bs.start_time) * 86400) elapsed_seconds,
bs.status,
bs.controlfile_included,
bs.input_file_scan_only,
decode(keep_options, 0, 'NO',
'YES') keep,
keep_until,
decode(keep_options, 256, 'LOGS',
512, 'NOLOGS',
1024, 'CONSISTENT',
NULL) keep_options
from db, bs
where db.db_key = bs.db_key

See Also

List of views