V$PROXY_DATAFILE
contains descriptions of datafile and control file backups that are taken with Proxy Copy. Each row represents a backup of one database file.
Column | Datatype | Description |
---|---|---|
|
|
Proxy copy record ID |
|
|
Proxy copy record stamp |
|
|
Type of the device on which the copy resides |
|
|
Proxy copy handle identifies the copy for restore |
|
|
Comment returned by the operating system or storage subsystem. This value is informational only. It is not needed for restore. |
|
|
Name of the media on which the copy resides. This value is informational only. It is not needed for restore. |
|
|
Media pool in which the copy resides. This is the same value that was entered in the |
|
|
Proxy copy tag |
|
|
Status of the backup set:
|
|
|
Indicates whether this record has been deleted ( |
|
|
Absolute datafile number, or 0 if this is a control file backup |
|
|
Datafile creation change number |
|
|
Datafile creation Timestamp |
|
|
Resetlogs change number of the datafile when the copy was made |
|
|
Resetlogs timestamp of the datafile when the copy was made |
|
|
Checkpoint change number of the datafile when the copy was made |
|
|
Checkpoint timestamp of the datafile when the copy was made |
|
|
Highest change in any block of the file, if known |
|
|
Highest change written to the file by media recovery |
|
|
Timestamp of the highest change written to the file by media recovery |
|
|
If this backup is part of an incremental backup strategy, then 0. Otherwise null. |
|
|
Indicates whether this copy was made after a crash or offline immediate (or is a copy of a copy which was taken improperly while the database was open) ( |
|
|
Indicates whether this is a copy taken using the |
|
|
Size of the copy (in blocks). Also the size of the datafile when the copy was made. |
|
|
Block size of the datafile |
|
|
If the file number is |
|
|
Starting time |
|
|
Completion time |
|
|
Number of elapsed seconds |
|
|
Type of control file:
|
|
|
Indicates whether this backup set has a retention policy that is different than the value for the configure retention policy ( |
|
|
If specified, then this is the date after which the backup becomes obsolete. If this column is NULL, then the backup never expires. |
|
|
Additional retention options for this backup set:
|
|
|
Owning |
|
|
Owning |
|
|
Foreign DBID of the database from which this datafile was transported. The value is |
|
|
Indicates whether this is a proxy copy of a transported read-only foreign file ( |
|
|
SCN at which the foreign datafile was transported into the database. The value is |
|
|
SCN of the |
|
|
Time of the |
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
Recovery Manager (RMAN) allows a PDB to be backed up in two ways. The value in this column indicates how the PDB backup was taken:
|