Loading...

CommCellOracleBackupInfo

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.

Last modified: 1/30/2018 3:45:25 PM