The CommCellOracleBackupInfo view provides a summary of the Oracle backup jobs.
|
Column |
Description |
|---|---|
|
jobId |
The unique ID of the backup job. |
|
appId |
The subclient ID. |
|
jobinitfrom |
The job initiation. |
|
clientname |
The name of the client used in the backup. |
|
idataagent |
The iDataAgent used for the backup ("Oracle"). |
|
instance |
The instance name used in the backup. |
|
backupset |
The backupset name. |
|
backuplevelInt |
The backup level initialization. |
|
backuplevel |
The backup type that was selected. Backup types can be Full, Incremental, Differential or Synthetic Full. |
|
incrlevel |
The storage policy copy name. |
|
jobstatusInt |
The job status in numerical form. |
|
jobstatus |
The status of the job (Success, Killed, Failed, or Failed to Start). |
|
jobfailedreason |
If the job failed, this is the reason it did. |
|
startdateunixsec |
The UNIX start date and time of the backup job. This time represents the number of seconds that have elapsed since 1970. |
|
startdate |
The date the job started. |
|
enddate |
The date the job ended. |
|
durationunixsec |
The job duration in Unix seconds. This time represents the number of seconds that have elapsed since 1970. |
|
duration |
The job duration. |
|
numstreams |
The number of streams used for the job. |
|
numbytesuncomp |
The number of bytes that were backed up without being compressed. |
|
numobjects |
The number of database objects that were backed up. |
|
isAged |
The IS aged. |
|
isAgedStr |
The IS aged string. |
|
xmljobOptioins |
The configured options for the backup job in XML format, |
|
retentiondays |
The number of retention days. |
|
systemStateBackup |
Indicates if system state was backed up during the operation. |
|
nextSCN |
The next System Change Number (SCN) for the backup. |
|
CopyName |
The name of the storage policy copy. |
|
CopyPrecedence |
The copy storage policy precedence. |