LGWR: terminating instance due to error 472 --> Need help DB is up - why this happened
Db had blocking session - I issue a alter system set events 'immediate trace name systemstate level 266'; and the db just crashed.
Now I need to make an explanation of this and I don't know why this happened.
Thu Nov 12 07:42:03 2009
Thread 1 advanced to log sequence 4362
Current log# 3 seq# 4362 mem# 0: /tbs/oradata/ora1/TBS6UAT/log/redo3A.log
Current log# 3 seq# 4362 mem# 1: /tbs/oradata/ora6/TBS6UAT/log/redo3B.log
Thu Nov 12 10:56:58 2009
OS Pid: 815240 executed alter system set events 'immediate trace name systemstat
e level 266'
Thu Nov 12 10:57:20 2009
LGWR: terminating instance due to error 472 ----------------->
Instance terminated by LGWR, pid = 663712
Now I need to make an explanation of this and I don't know why this happened.
Thu Nov 12 07:42:03 2009
Thread 1 advanced to log sequence 4362
Current log# 3 seq# 4362 mem# 0: /tbs/oradata/ora1/TBS6UAT/log/redo3A.log
Current log# 3 seq# 4362 mem# 1: /tbs/oradata/ora6/TBS6UAT/log/redo3B.log
Thu Nov 12 10:56:58 2009
OS Pid: 815240 executed alter system set events 'immediate trace name systemstat
e level 266'
Thu Nov 12 10:57:20 2009
LGWR: terminating instance due to error 472 ----------------->
Instance terminated by LGWR, pid = 663712
0