Recovery in RAC

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

Moderator: Tim...

Posts: 260
Joined: Sat Jun 27, 2009 3:53 am
Location: India

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#?

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

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:

Return to “Oracle RAC and Clusterware”

Who is online

Users browsing this forum: No registered users and 3 guests