RC_DATABASE_BLOCK_CORRUPTION |
VALID |
05/12/2002 |
05/12/2002 |
|
|
DB_KEY |
NUMBER |
|
|
|
|
Y |
|
|
NO |
NO |
NO |
|
DBINC_KEY |
NUMBER |
|
|
|
|
Y |
|
|
NO |
NO |
NO |
|
FILE# |
NUMBER |
|
|
|
|
Y |
|
|
NO |
NO |
NO |
|
BLOCK# |
NUMBER |
|
|
|
|
Y |
|
|
NO |
NO |
NO |
|
BLOCKS |
NUMBER |
|
|
|
|
Y |
|
|
NO |
NO |
NO |
|
CORRUPTION_CHANGE# |
NUMBER |
|
|
|
|
Y |
|
|
NO |
NO |
NO |
|
CORRUPTION_TYPE |
VARCHAR2 |
9 |
|
|
|
Y |
|
|
NO |
NO |
NO |
Total: 7 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_DATABASE_BLOCK_CORRUPTION" ("DB_KEY", "DBINC_KEY", "FILE#", "BLOCK#", "BLOCKS", "CORRUPTION_CHANGE#", "CORRUPTION_TYPE") AS
select distinct
db_key, dbinc_key, file#, block#, blocks, corruption_change#,
corruption_type from
(select db_key, dbinc_key, file#, block#, blocks,
corruption_change#, copy_stamp stamp, corruption_type
from rc_copy_corruption union
select bs.db_key, dbinc_key, file#, block#, blocks,
corruption_change#, bs.stamp, corruption_type
from rc_backup_corruption bc, rc_backup_set bs
where bc.bs_key = bs.bs_key) outer
where not exists
(select 1
from rc_datafile_copy
where outer.db_key = db_key and
outer.dbinc_key = dbinc_key and
scanned = 'YES' and
outer.file# = file# and
outer.stamp < stamp
union
select 1
from rc_backup_datafile bdf, rc_backup_set bs
where bdf.bs_key = bs.bs_key and
outer.db_key = bdf.db_key and
outer.dbinc_key = bdf.dbinc_key and
outer.file# = file# and
outer.stamp < bs.stamp)
List of views