Home » Infrastructure » Windows » Not writing into REDO LOG File (Oracle RDBMS ver.10.2.)
Not writing into REDO LOG File [message #612785] Thu, 24 April 2014 14:15 Go to next message
praveenramaswamy
Messages: 34
Registered: December 2013
Member
Dear Experts

Need your guidance on the issue i'am trying to understand.

If you look at the below 2 queries, you can see the redo log file location on the database. However i notice in the windows server that the files arent being written, since FEB'2014. For example let say i update a table, the timestamp on the online redo log file doesnt get changed.

select * from v$logfile order by group#
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
1 ONLINE E:\ORACLE\LOGS\REDO01.LOG NO
1 ONLINE C:\COMIT\LOGS\REDO01.ORA NO
2 ONLINE C:\COMIT\LOGS\REDO02.ORA NO
2 ONLINE E:\ORACLE\LOGS\REDO02.LOG NO
3 ONLINE C:\COMIT\LOGS\REDO03.ORA NO
3 ONLINE E:\ORACLE\LOGS\REDO03.LOG NO

SELECT * FROM v$log
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
1 1 0 209715200 2 YES UNUSED 2451838447 4/24/2014 5:03:53 AM
2 1 11154 209715200 2 NO CURRENT 2451884277 4/24/2014 9:40:30 AM
3 1 0 209715200 2 YES UNUSED 2451824122 4/24/2014 5:02:11 AM
Re: Not writing into REDO LOG File [message #612788 is a reply to message #612785] Thu, 24 April 2014 15:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Do not trust Windows.

Re: Not writing into REDO LOG File [message #612992 is a reply to message #612788] Mon, 28 April 2014 09:13 Go to previous message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
The datestamp of an open windows file is usually not updated. It should be updated after the file is closed.

[Updated on: Mon, 28 April 2014 09:14]

Report message to a moderator

Previous Topic: Developer 10 with oracle database 11g
Next Topic: Error in CreateOUIProcess(): 1260
Goto Forum:
  


Current Time: Thu Mar 28 09:29:39 CDT 2024