Recovery in RAC

Questions relating to Oracle Real Application Clusters (RAC) and Clusterware.

Moderator: Tim...

Recovery in RAC

Postby sivakumarocp » Tue Nov 20, 2012 7:29 pm

Hi Tim,

if we are going for recovery in RAC database based on Log sequenc#, how do we do that.
if its a 3 node RAC we will be having 3 threads and each thread will not have same SEQ# in this situation how do we recover based on sequence#?
Posts: 256
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: Recovery in RAC

Postby Tim... » Tue Nov 20, 2012 8:06 pm


Essentially, all recoveries are SCN based. When you recover using an "until time" or a log sequence number, Oracle works out the associated SCN and does the recovery to that SCN. That way, log sequence numbers have no affect, since all this does is allow you to indirectly specify the SCN.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:
Site Admin
Posts: 17953
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Return to Oracle RAC and Clusterware

Who is online

Users browsing this forum: No registered users and 1 guest