Database Administration (MOSC)

MOSC Banner

LGWR: terminating instance due to error 472 --> Need help DB is up - why this happened

edited Nov 12, 2009 6:49AM in Database Administration (MOSC) 3 commentsAnswered ✓
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center