Home » RDBMS Server » Backup & Recovery » Bad results from V$LOGMNR_LOGS!!
Bad results from V$LOGMNR_LOGS!! [message #129329] Sun, 24 July 2005 03:16
samizn
Messages: 7
Registered: March 2005
Junior Member
I submitted this question at another section of the forums but I think this is the right place to post it...

I am using Oracle 9.2.0.1 on PC.
I am querying the V$LOGMNR_LOGS to get the LOW_TIME and HIGH_TIME of the redo logs and I am getting bad results!!

select to_char(LOW_TIME,'YYYY-MM-DD HH24:MI:SS'),
to_char(HIGH_TIME,'YYYY-MM-DD HH24:MI:SS')
from V$LOGMNR_LOGS

TO_CHAR(LOW_TIME,'Y TO_CHAR(HIGH_TIME,'
------------------- -------------------
2005-07-11 12:04:25 2005-07-12 12:20:44
2005-07-12 12:20:44 2005-07-13 12:36:13
2005-07-13 12:36:13 1988-01-01 00:00:00


These results are not accurate... I can see in the logminer that it contains records with timestamp bigger than "2005-07-13 12:36:13"!!!
What wrong??!! it seems like this view is not being updated!!!

Note: I get the same behavior when using Oracle 10.1.0.1!!

[Updated on: Sun, 24 July 2005 03:17]

Report message to a moderator

Previous Topic: Live Tablespace restore/rollback to a old state
Next Topic: Restore database in another Server by Rman
Goto Forum:
  


Current Time: Thu Mar 28 07:36:59 CDT 2024