Re: Rollback of Query Cancellation

[Abdul Rahman <abr_ora@xxxxxxxxx>]

Welcome Jcasanov,

Here is the output of the log files:

2009-01-27 09:24:18 FATAL:  the database system is starting up
2009-01-27 09:24:19 LOG:  database system was shut down at 2009-01-26 18:34:53
2009-01-27 09:24:19 LOG:  checkpoint record is at 0/1B9F92C8
2009-01-27 09:24:19 LOG:  redo record is at 0/1B9F92C8; undo record is at 0/0; shutdown TRUE
2009-01-27 09:24:19 LOG:  next transaction ID: 0/335372; next OID: 19380
2009-01-27 09:24:19 LOG:  next MultiXactId: 1; next MultiXactOffset: 0
2009-01-27 09:24:19 LOG:  database system is ready
2009-01-27 18:52:43 LOG:  received fast shutdown request
2009-01-27 18:52:44 LOG:  shutting down
2009-01-27 18:52:44 LOG:  database system is shut down
2009-01-27 18:52:44 LOG:  logger shutting down

and

2009-01-28 09:42:14 FATAL:  the database system is starting up
2009-01-28 09:42:14 LOG:  database system was shut down at 2009-01-27 18:52:44
2009-01-28 09:42:14 LOG:  checkpoint record is at 0/1B9F9368
2009-01-28 09:42:14 LOG:  redo record is at 0/1B9F9368; undo record is at 0/0; shutdown TRUE
2009-01-28 09:42:14 LOG:  next transaction ID: 0/336490; next OID: 19380
2009-01-28 09:42:14 LOG:  next MultiXactId: 1; next MultiXactOffset: 0
2009-01-28 09:42:15 LOG:  database system is ready
2009-01-28 09:42:15 FATAL:  the database system is starting up