Database Backup and Recovery (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center