Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
SELECT entity, cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as "GB",sum(affected) as "Number of files" FROM summary WHERE activity='RESTORE' AND end_time>current_timestamp-24 hours GROUP BY entity
Yes to all except the list of files.
Code:SELECT entity, cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as "GB",sum(affected) as "Number of files" FROM summary WHERE activity='RESTORE' AND end_time>current_timestamp-24 hours GROUP BY entity
Scratch that. I checked and I don't see any restore sessions during the VM backups my summary or summary_extended tables.VM incremental backups restores the control files (.CTL) from previous backup to determine what to backup.