Recall offsite volumes for restore by date

oguinna

ADSM.ORG Member
Joined
Feb 9, 2009
Messages
12
Reaction score
0
Points
0
PREDATAR Control23

Hello,

We are doing a psuedo DR exercise in which I'm being asked to restore from our offsite copies. I'd like to recall the volumes for the node from a specific date for the restore.

I have found this statement works well but I need assistance in also adding a specific date since I really don't want to recall all offsite copy volumes.

select distinct volume_name, stgpool_name from volumeusage where stgpool_name='<COPYPOOL NAME>' and node_name='<NODE_NAME>' group by stgpool_name, volume_name

Any help is greatly appreciated.

Thanks!
 
PREDATAR Control23

I decided I will simply recall the volumes that were ejected for the dates in questions unless someone has a better solution.

Thank you
 
PREDATAR Control23

You could do:
query nodedata {nodename} stgpool={copypool name}

It won't give you the date, but at least you will only have those from that nde.
 
PREDATAR Control23

I decided I will simply recall the volumes that were ejected for the dates in questions unless someone has a better solution.
Thank you

If I understand what you need, try to filter by column "ACCESS" from table "MEDIA" and look at the column "LRD"...
 
Top