| DBW0: terminating instance due to error 1092 [message #127830] |
Wed, 13 July 2005 10:13  |
mcastill66
Messages: 4
Registered: July 2005
Location: USA
|
Junior Member |
|
|
Hello
A few weeks back we had an unexpected interruption which dropped our connect to our SAN. We then had to do several fsck's on several filesystems including '/u01'(oracle home).
We have scripts that run which drop the DB 'shutdown abort'these scripts which are for our 24X7 solution using timefinder(EMC software) were working fine before the fsck's.
My question is what is causing these errors and how if possible do I fix this? I have pasted the alert log entry for yesterday when the DB hangs.
Thanks In Advance
Mike
Tue Jul 12 04:05:27 2005
Thread 1 advanced to log sequence 14149
Current log# 2 seq# 14149 mem# 0: /u03/oradata/PROD/redo_PROD_02.log
Current log# 2 seq# 14149 mem# 1: /u30/oradata/PROD/redo_PROD_02.log
Tue Jul 12 04:05:27 2005
ARC0: Evaluating archive log 4 thread 1 sequence 14148
ARC0: Beginning to archive log 4 thread 1 sequence 14148
Creating archive destination LOG_ARCHIVE_DEST_1: '/u04/oradata/PROD/arch/S70_PROD_0000014148.arc'
ARC0: Completed archiving log 4 thread 1 sequence 14148
Tue Jul 12 04:05:28 2005
Shutting down instance (abort)
License high water mark = 369
Tue Jul 12 04:10:28 2005
DBW0: terminating instance due to error 1092
Tue Jul 12 04:10:29 2005
LGWR: terminating instance due to error 1092
Instance terminated by LGWR, pid = 129286
Tue Jul 12 05:51:41 2005
|
|
|
|
| Re: DBW0: terminating instance due to error 1092 [message #127843 is a reply to message #127830] |
Wed, 13 July 2005 11:23  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Did LGWR generate a trace file for you to examine?
I believe, but would have to research to double check, that if the database can't write redo information that it will shut itself down to prevent data from being lost. It is by design.
|
|
|
|
|
|
| Re: DBW0: terminating instance due to error 1092 [message #129039 is a reply to message #127830] |
Thu, 21 July 2005 12:19 |
mcastill66
Messages: 4
Registered: July 2005
Location: USA
|
Junior Member |
|
|
I am still getting these errors:
What could be causing this?
USER: terminating instance due to error 1092
Thu Jul 21 04:10:48 2005
USER: terminating instance due to error 1092
Thu Jul 21 04:10:49 2005
DBW0: terminating instance due to error 1092
Thu Jul 21 04:10:50 2005
USER: terminating instance due to error 1092
Thu Jul 21 04:10:50 2005
PMON: terminating instance due to error 1092
Thu Jul 21 04:10:51 2005
CKPT: terminating instance due to error 1092
Thu Jul 21 04:10:51 2005
LGWR: terminating instance due to error 1092
Thu Jul 21 04:10:54 2005
Instance terminated by PMON, pid = 198776
Thu Jul 21 05:00:02 2005
Instance terminated by USER, pid = 211292
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
