View: RC_DATABASE_BLOCK_CORRUPTION

Properties

Name: | RC_DATABASE_BLOCK_CORRUPTION
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 |  |  |  |  | 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)

Used by

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

Total: 1 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_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)

See Also

List of views