Question on list backup of archivelog
Hi,
I have few questions on RMAN commands for "list backup of archivelog" backed up to tape
1) The command "list backup of archivelog from time 'sysdate-1' until time 'sysdate' device type sbt_tape; " gives me information for both nodes of RAC(1 and 2). If I have to filter this to just one thread(either thread 1 or thread 2) what is the command? I tried putting "thread 1" in between command above and gives me error
2) I want to check if any archivelog sequence missing from tape backup from sysdate-10 to sysdate. With above query "list backup of archivelog from time 'sysdate-1' until time 'sysdate' device type sbt_tape;" it gives all sequence in order. I have to go through complete output and see if any sequence is missing.