RC_BACKUP_PIECE |
VALID |
05/12/2002 |
05/12/2002 |
|
|
DB_KEY |
NUMBER |
|
|
|
|
N |
|
|
NO |
NO |
NO |
|
DB_ID |
NUMBER |
|
|
|
|
N |
|
|
NO |
NO |
NO |
|
BP_KEY |
NUMBER |
|
|
|
|
N |
|
|
YES |
YES |
YES |
|
RECID |
NUMBER |
|
|
|
|
N |
|
|
YES |
YES |
YES |
|
STAMP |
NUMBER |
|
|
|
|
N |
|
|
YES |
YES |
YES |
|
BS_KEY |
NUMBER |
|
|
|
|
N |
|
|
NO |
NO |
NO |
|
SET_STAMP |
NUMBER |
|
|
|
|
N |
|
|
NO |
NO |
NO |
|
SET_COUNT |
NUMBER |
|
|
|
|
N |
|
|
NO |
NO |
NO |
|
BACKUP_TYPE |
VARCHAR2 |
1 |
|
|
|
Y |
|
|
NO |
NO |
NO |
|
INCREMENTAL_LEVEL |
NUMBER |
|
|
|
|
Y |
|
|
NO |
NO |
NO |
|
PIECE# |
NUMBER |
|
|
|
|
N |
|
|
YES |
YES |
YES |
|
COPY# |
NUMBER |
|
|
|
|
N |
|
|
YES |
YES |
YES |
|
DEVICE_TYPE |
VARCHAR2 |
255 |
|
|
|
N |
|
|
YES |
YES |
YES |
|
HANDLE |
VARCHAR2 |
1024 |
|
|
|
N |
|
|
YES |
YES |
YES |
|
COMMENTS |
VARCHAR2 |
255 |
|
|
|
Y |
|
|
YES |
YES |
YES |
|
MEDIA |
VARCHAR2 |
80 |
|
|
|
Y |
|
|
YES |
YES |
YES |
|
MEDIA_POOL |
NUMBER |
|
|
|
|
Y |
|
|
YES |
YES |
YES |
|
CONCUR |
VARCHAR2 |
3 |
|
|
|
Y |
|
|
NO |
NO |
NO |
|
TAG |
VARCHAR2 |
32 |
|
|
|
Y |
|
|
YES |
YES |
YES |
|
START_TIME |
DATE |
7 |
|
|
|
N |
|
|
YES |
YES |
YES |
|
COMPLETION_TIME |
DATE |
7 |
|
|
|
N |
|
|
YES |
YES |
YES |
|
ELAPSED_SECONDS |
NUMBER |
|
|
|
|
Y |
|
|
NO |
NO |
NO |
|
STATUS |
VARCHAR2 |
1 |
|
|
|
N |
|
|
YES |
YES |
YES |
Total: 23 column(s)
RMAN |
DBMS_RCVMAN |
PACKAGE BODY |
0 |
Total: 1 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_PIECE" ("DB_KEY", "DB_ID", "BP_KEY", "RECID", "STAMP", "BS_KEY", "SET_STAMP", "SET_COUNT", "BACKUP_TYPE", "INCREMENTAL_LEVEL", "PIECE#", "COPY#", "DEVICE_TYPE", "HANDLE", "COMMENTS", "MEDIA", "MEDIA_POOL", "CONCUR", "TAG", "START_TIME", "COMPLETION_TIME", "ELAPSED_SECONDS", "STATUS") AS
select db.db_key,
db.db_id,
bp.bp_key,
bp.bp_recid recid,
bp.bp_stamp stamp,
bs.bs_key,
bs.set_stamp,
bs.set_count,
bs.bck_type backup_type,
bs.incr_level incremental_level,
bp.piece#,
bp.copy#,
bp.device_type,
bp.handle,
bp.comments,
bp.media,
bp.media_pool,
decode(bp.concur, 'N', 'NO', 'Y', 'YES', '?') concur,
bp.tag,
bp.start_time,
bp.completion_time,
((bp.completion_time - bp.start_time) * 86400) elapsed_seconds,
bp.status
from db, bs, bp
where db.db_key = bs.db_key
and bs.bs_key = bp.bs_key
List of views