| Not writing into REDO LOG File [message #612785] |
Thu, 24 April 2014 14:15  |
 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
