7.101 V$BACKUP_SPFILE

RECID

NUMBER

Backup SPFILE record ID

STAMP

NUMBER

Backup SPFILE record stamp

SET_STAMP

NUMBER

Backup set stamp (of the set which contains this SPFILE backup)

SET_COUNT

NUMBER

Backup set count (of the set which contains this SPFILE backup)

MODIFICATION_TIME

DATE

Time when the SPFILE was last modified (this also includes creation time)

BYTES

NUMBER

Size of the SPFILE (in bytes)

COMPLETION_TIME

DATE

Time when the backup of the SPFILE completed

DB_UNIQUE_NAME

VARCHAR2(30)

Unique database name

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

• 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

• 1: This value is used for rows containing data that pertain to only the root

• n: Where n is the applicable container ID for the rows containing data

GUID^Foot 1

RAW(16)

The GUID of the PDB to which the backup belongs. This is useful after the PDB is dropped to identify which PDB the backup belongs to.