View: RC_BACKUP_CORRUPTION

Properties

Name: | RC_BACKUP_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 |  |  |  |  | N |  |  | NO | NO | NO
| DBINC_KEY | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| DB_NAME | VARCHAR2 | 8 |  |  |  | N |  |  | NO | NO | NO
| 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
| PIECE# | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| BDF_KEY | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| BDF_RECID | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| BDF_STAMP | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| FILE# | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| CREATION_CHANGE# | NUMBER |  |  |  |  | N |  |  | NO | NO | NO
| BLOCK# | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| BLOCKS | NUMBER |  |  |  |  | N |  |  | YES | YES | YES
| CORRUPTION_CHANGE# | NUMBER |  |  |  |  | Y |  |  | YES | YES | YES
| MARKED_CORRUPT | VARCHAR2 | 3 |  |  |  | Y |  |  | NO | NO | NO
| CORRUPTION_TYPE | VARCHAR2 | 9 |  |  |  | Y |  |  | YES | YES | YES

Total: 19 column(s)

Used by

Owner | Name | Type | Level
RMAN | RC_DATABASE_BLOCK_CORRUPTION | VIEW | 0
RMAN | DBMS_RCVCAT | 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_CORRUPTION" ("DB_KEY", "DBINC_KEY", "DB_NAME", "RECID", "STAMP", "BS_KEY", "SET_STAMP", "SET_COUNT", "PIECE#", "BDF_KEY", "BDF_RECID", "BDF_STAMP", "FILE#", "CREATION_CHANGE#", "BLOCK#", "BLOCKS", "CORRUPTION_CHANGE#", "MARKED_CORRUPT", "CORRUPTION_TYPE") AS
select dbinc.db_key,
dbinc.dbinc_key,
dbinc.db_name,
bcb.bcb_recid recid,
bcb.bcb_stamp stamp,
bs.bs_key,
bs.set_stamp,
bs.set_count,
bcb.piece#,
bdf.bdf_key,
bdf.bdf_recid,
bdf.bdf_stamp,
bdf.file#,
bdf.create_scn creation_change#,
bcb.block#,
bcb.blocks,
bcb.corrupt_scn corruption_change#,
decode(bcb.marked_corrupt,'N', 'NO', 'Y', 'YES', '?') marked_corrupt,
bcb.corruption_type
from dbinc, bs, bdf, bcb
where dbinc.dbinc_key = bdf.dbinc_key
and bs.bs_key = bdf.bs_key
and bdf.bdf_key = bcb.bdf_key

See Also

List of views