Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deciding SCN/Sequence#&Thread# for incomplete recovery in RAC

user8860934Dec 8 2010 — edited Dec 9 2010

We have a 4 node RAC and we need to have a in-complete recovery for this DB, So How we can decide Sequence#&Thread# or SCN# for my incomplete recovery based on below information

SEQUENCE# THREAD# FIRST_CHANGE# NEXT_CHANGE#
---------- ---------- ---------------- -----------------
20481 1 28115344328 28117073183
18999 4 28115344285 28117073204
19207 3 28115344018 28117073239
19015 2 28115344272 28117073242

Do we need to choose to max(NEXT_CHANGE#) (ie) 28117073242 ? or

set until sequence 19015 thread 2?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2011

Added on Dec 8 2010

#performance-availability, #real-application-clusters

2 comments

598 views