The scenario is I have a copy pool tape that was accidently damaged. I would like to know which primary pool tapes I would need to recreate this copypool tape. The first obvious way is to run a backup stgpool preview=yes command however that will ALSO show other volumes out of sync and doesn't really give me the mapping directly to the 1 volume.
Is there a select query I can run where the input is the copypool volume and it returns the primary pool volumes? I am pretty sure I used to have this query and can't located it now that I need it. Appreciate the help!
