How do I view backup details of NFS mounts?

illllm

ADSM.ORG Member
Joined
Jan 9, 2018
Messages
153
Reaction score
2
Points
0
PREDATAR Control23

Hi All,

I am trying to create a backup report that shows the following:

I have NFS shares mounted on our backup server. They are backed up under a node name "NFS-Backups"

i have defined each share as a domain

domain /share1
domain /share2
domain /share/dir1

how do i get a report of each domain that was backed up and how much data was backed up?
 
PREDATAR Control23

i know i can do a dsmc q ba with querysummary but is it possible in SQL statements ?
 
PREDATAR Control23

So this is what I am trying to achieve...

Filespace name | last full backup | amount of data backed up
 
PREDATAR Control23

select node_name, filespace_name, backup_date, actual_size from backups WHERE filespace_name='/dev_exadata_bkup' AND backup_date>=current_timestamp-24 hours

this is working but i need it to group under a filespace name

select node_name, filespace_name, backup_date, actual_size from backups WHERE filespace_name='/dev_exadata_bkup' AND backup_date>=current_timestamp-24 hours group by node_name

this is not working
 
PREDATAR Control23

got it

select filespace_name, backup_start, backup_end from filespaces where node_name= ' '
 
Top