restore and recovery - threads having same sequence
Hi Experts,
We are restoring 2 node rac to single node. We are trying to find a sequence until which we will recover.
This restore is critical to us.
1) As per the note RMAN: RAC Backup, Restore and Recovery using RMAN ( Doc ID 243760.1 ), We are checking to find the maximium sequence that can be recovered.
When we run the below queries,it returns same sequence for thread 1 and thread 2. Can you advice which sequence should we take.
RMAN> select sequence#, thread#, first_change#, next_change#
from v$archived_log L, v$database D
where L.resetlogs_change# = D.resetlogs_change# and