Get last record or...

From: eAddict <eaddict_at_gmail.com>
Date: Wed, 2 Dec 2009 11:09:39 -0800 (PST)
Message-ID: <83a94bba-5544-4f3c-b547-016dc030cf50_at_e31g2000vbm.googlegroups.com>

I have a database that was cloned a bit ago. I was looking at v $log_history on the Data Guard side of things and found some wierd stuff.

     RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# RESETLOGS_CHANGE# RESETLOGS ---------- ---------- ---------- ---------- ------------- ---------

------------ ----------------- ---------
         1  697091099          1      51477    2.5076E+10 08-SEP-09
2.5076E+10                 1 08-AUG-00
         2  697091109          1      51478    2.5076E+10 08-SEP-09
2.5077E+10                 1 08-AUG-00
         3  697091310          1          1    2.5089E+10 09-SEP-09
2.5089E+10        2.5089E+10 09-SEP-09
         4  697092131          1          2    2.5089E+10 09-SEP-09
2.5089E+10        2.5089E+10 09-SEP-09
         5  697092803          1          3    2.5089E+10 09-SEP-09
2.5090E+10        2.5089E+10 09-SEP-09

.
.
.

      2518  704544170          1       2516    2.6956E+10 02-DEC-09
2.6956E+10        2.5089E+10 09-SEP-09
      2519  704544171          1       2517    2.6956E+10 02-DEC-09
2.6956E+10        2.5089E+10 09-SEP-09
      2520  704544203          1       2518    2.6956E+10 02-DEC-09
2.6956E+10        2.5089E+10 09-SEP-09

2520 rows selected.

So when I go to see the last log that was applied I see 51478 and NOT 2520.
So, how can I do any of the following:
(a) remove the erroneous records from v$log_history (b) set up a query so I get the correct result (ie 2520)

Thanks!
Vince Received on Wed Dec 02 2009 - 13:09:39 CST