RA_POLLING_FILES

This view describes the set of files the Recovery Appliance backed up from the configured polling location.

Note that this view is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.

Column Data Type NULL Description

POLL_NAME

VARCHAR2(128)

The name of the polling policy.

POLL_KEY

NUMBER

NOT NULL

The unique identifier of the polling policy.

FILE_NAME

VARCHAR2(512)

The name of the file discovered in the configured polling location.

FILE_SIZE

NUMBER

The size of the file the last time it was scanned in the polling location.

STATUS

VARCHAR2(24)

The current state of processing of the file.

PROCESSING: file has just been recognized by Recovery Appliance as a candidate file.

COMPLETED: file was accepted by the Recovery Appliance.

DBID NOT IN POLICY database that created this file is not associate with the polling policy that is processing the file.

UNKNOWN FILE TYPE file type of file is not supported by the Recovery Appliance.

ERROR IN PROCESSING FILE an error was detected in processing the file. Check ra_incident_log for details.

INCOMPLETE FILE: file was never completed written by source database.

FILE DELETED BY ZDLRA: processing was completed and file was removed per polling policy.

LAST_PROCESSED

TIMESTAMP WITH TIME ZONE

The time stamp includes the time zone of when last processed..