| Oracle9i Recovery Manager Reference Release 2 (9.2) Part Number A96565-01  | 
  | 
This chapter contains descriptions of recovery catalog views. You can only access these views if you have created a recovery catalog. For a summary of the recovery catalog views, refer to "Summary of RMAN Recovery Catalog Views".
| 
 Note: These views are not normalized, but are optimized for RMAN usage. Hence, most catalog views have redundant values that result from joining of several underlying tables.  | 
The following table provides a functional summary of RMAN recovery catalog views.
| Recovery Catalog View | Corresponding V$ View | Catalog View Describes ... | 
|---|---|---|
|  
 
  | 
 
 Archived and unarchived redo logs  | 
|
|  
 
  | 
 
 Control files in backup sets  | 
|
|  
 
  | 
 
 Corrupt block ranges in datafile backups  | 
|
|  
 
  | 
 
 Datafiles in backup sets  | 
|
|  
 
  | 
 
 Backup pieces  | 
|
|  
 
  | 
 
 Archived redo logs in backup sets  | 
|
|  
 
  | 
 
 Backup sets for all incarnations of the database  | 
|
|  
 
  | 
 
 Server parameter files in backups  | 
|
|  
 Deprecated in favor of RC_RESYNC  | 
||
|  
 
  | 
 
 Control file copies on disk  | 
|
|  
 
  | 
 
 Control file copies on disk  | 
|
|  
 
  | 
 
 Databases registered in the recovery catalog  | 
|
|  
 
  | 
 
 Database blocks marked as corrupted in the most recent RMAN backup or copy  | 
|
|  
 
  | 
 
 Database incarnations registered in the recovery catalog  | 
|
|  
 
  | 
 
 Datafiles registered in the recovery catalog  | 
|
|  
 
  | 
 
 Datafile copies on disk  | 
|
|  
 
  | 
 
 Online redo log history indicating when log switches occurred  | 
|
|  
 
  | 
 
 Offline ranges for datafiles  | 
|
|  
 
  | 
 
 Control file backups that were taken using the proxy copy functionality  | 
|
|  
 
  | 
 
 Datafile backups that were taken using the proxy copy functionality  | 
|
|  
 
  | 
 
 Online redo logs for all incarnations of the database since the last catalog resynchronization  | 
|
|  
 
  | 
 
 All redo threads for all incarnations of the database since the last catalog resynchronization  | 
|
|  
 n/a  | 
 
 Recovery catalog resynchronizations  | 
|
|  
 
  | 
 
 RMAN configuration settings  | 
|
|  
 n/a  | 
 
 Names of scripts stored in the recovery catalog  | 
|
|  
 n/a  | 
 
 Contents of the scripts stored in the recovery catalog  | 
|
|  
 
  | 
 
 All tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old incarnations  | 
  | 
![]() Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved.  | 
  |