| database hang [message #60246] |
Tue, 27 January 2004 05:52  |
Giuseppe
Messages: 11
Registered: December 2001
|
Junior Member |
|
|
Hi,
I have a oracle database server Enterprice Edition 8.1.7 in replication mode.
Usually, twice a week I have a hang of DB and i must shotdown and restart it.
I haven't any message in alert.log file.
What are the cause then carrier db in hang state?
It is possible that this is a oracle bug?
Help me!!!!!
|
|
|
|
|
|
| Re: database hang [message #60249 is a reply to message #60248] |
Tue, 27 January 2004 06:09  |
Giuseppe
Messages: 11
Registered: December 2001
|
Junior Member |
|
|
Sorry,
What means "You might be running out of disk space"?
I thing that if the problem is archive log than I must every day have the same problem.
|
|
|
|
| Re: database hang [message #60250 is a reply to message #60249] |
Tue, 27 January 2004 06:30 |
Giuseppe
Messages: 11
Registered: December 2001
|
Junior Member |
|
|
This is a part of alert.log file:
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Fri Jan 02 00:36:06 2004
alter database "QAPROD" mount exclusive
Fri Jan 02 00:36:11 2004
Successful mount of redo thread 1, with mount id 2153396347.
Fri Jan 02 00:36:11 2004
Database mounted in Exclusive Mode.
Completed: alter database "QAPROD" mount exclusive
Fri Jan 02 00:36:11 2004
alter database open
Beginning crash recovery of 1 threads
Fri Jan 02 00:36:11 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 142 Reading mem 0
Mem# 0 errs 0: W:ORACLEORADATAQAPRODQAP_REDO03.LOG
Fri Jan 02 00:36:11 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 21 data blocks read, 21 data blocks written, 110 redo blocks read
Crash recovery completed successfully
Fri Jan 02 00:36:11 2004
Thread 1 advanced to log sequence 143
Thread 1 opened at log sequence 143
Current log# 1 seq# 143 mem# 0: W:ORACLEORADATAQAPRODQAP_REDO01.LOG
Successful open of redo thread 1.
Fri Jan 02 00:36:11 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Jan 02 00:36:12 2004
Completed: alter database open
Fri Jan 02 09:59:30 2004
Shutting down instance (abort)
License high water mark = 9
Instance terminated by USER, pid = 2656
Dump file w:OracleadminQAPRODbdumpqaprodALRT.LOG
Fri Jan 02 10:00:15 2004
ORACLE V8.1.7.4.1 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.4.1.
System parameters with non-default values:
|
|
|
|
| Re: database hang [message #60262 is a reply to message #60250] |
Wed, 28 January 2004 00:17 |
Giuseppe
Messages: 11
Registered: December 2001
|
Junior Member |
|
|
Another information:
Before hanging the gatabase return a wrong result in a various query.
thanks for support.
Giuseppe
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
