RC_BACKUP_SET |
VALID |
05/12/2002 |
05/12/2002 |
|
|
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)
RMAN |
RC_DATABASE_BLOCK_CORRUPTION |
VIEW |
0 |
RMAN |
DBMS_RCVMAN |
PACKAGE BODY |
0 |
Total: 2 used by reference(s)
OLAPSYS |
DBA$OLAP2_DIM_LEVELS |
VIEW |
1 |
OLAPSYS |
DBA$OLAP_DIM_LEVELS |
VIEW |
1 |
Total: 2 use reference(s)
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
List of views