If you are using a recovery catalog, you can query corresponding views
that contain the same information for each target database registered in the
recovery catalog database. The corresponding views have the same name, except
that the “V$” is replaced with “RC_”. Also, they are in the schema owned by the
recovery catalog owner. For example, the corresponding views in the recovery
catalog, showing the information are: RC_BACKUP_SET, RC_BACKUP_PIECE,
RC_DATAFILE_COPY, and RC_BACKUP_FILES.
In order to query the RC_BACKUP_FILES view, you must first execute the
following in the recovery catalog database:
SQL>
CALL DBMS_RCVMAN.SETDATABASE(null,null,null,<dbid>);
where <dbid> is the
database ID of a target database.
Query the following dynamic performance views in the target database to
obtain information about your backups:
•
V$BACKUP_SET: Backup sets created
•
V$BACKUP_PIECE: Backup pieces that exist
•
V$DATAFILE_COPY: Copies of data files on disk
•
V$BACKUP_FILES: Information about all files created
when creating backups
