Oracle server is down during a COLD backup

From: Nguyen, David M <david.m.nguyen_at_xo.com>
Date: Thu, 23 Dec 2004 12:01:04 -0600
Message-ID: <963163702DB42A4D9D47941946B5705E06A095@TXPLANMAIL02.mail.inthosts.net>

I am running oracle8.1.7 on a linux server, the server was down last night during a shutting down to do a cold backup. I notice some errors in alert log and trace file but quite don't understand the root cause. Can someone look at errors and explain to me if my cold backup is a root cause that brought server down. I really appreciate your helps.

+ACoAKgAq-Alert log:

Thu Dec 23 01:01:01 2004
Shutting down instance (immediate)
License high water mark +AD0- 7
Thu Dec 23 01:01:01 2004
ALTER DATABASE CLOSE NORMAL
Thu Dec 23 01:01:01 2004
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Dec 23 01:01:01 2004
Thread 1 closed at log sequence 36120
Thu Dec 23 01:01:01 2004
Errors in file /u01/app/oracle/admin/insidera/udump/ora+AF8-31883.trc: Thu Dec 23 01:01:01 2004
Errors in file /u01/app/oracle/admin/insidera/udump/ora+AF8-31883.trc: Thu Dec 23 01:01:02 2004
Errors in file /u01/app/oracle/admin/insidera/udump/ora+AF8-31883.trc: Thu Dec 23 09:26:44 2004
Starting ORACLE instance (normal)
LICENSE+AF8-MAX+AF8-SESSION +AD0- 0
LICENSE+AF8-SESSIONS+AF8-WARNING +AD0- 0
+AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQ-

+ACoAKgAq- TRACE file:

+ACQ- cat /u01/app/oracle/admin/insidera/udump/ora+AF8-31883.trc

/u01/app/oracle/admin/insidera/udump/ora+AF8-31883.trc Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option
JServer Release 8.1.7.0.1 - Production
ORACLE+AF8-HOME +AD0- /u01/app/oracle/product/8.1.7 System name: Linux

Node name:      insidera
Release:        2.4.18-14smp
Version:        +ACM-1 SMP Wed Sep 4 12:34:47 EDT 2002
Machine:        i686

Instance name: inra
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 31883, image: oracle+AEA-insidera

+ACoAKgAq- SESSION ID:(8.8648) 2004-12-23 01:01:01.636
Exception signal: 11 (SIGSEGV)
+ACoAKgAq- 2004-12-23 01:01:01.715

ksedmp: internal or fatal error
Current SQL statement for this session:
ALTER DATABASE CLOSE NORMAL ----- Call Stack Trace -----

calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------

Exception signal: 11 (SIGSEGV)
+ACoAKgAq- 2004-12-23 01:01:01.891

ksedmp: internal or fatal error
Current SQL statement for this session:
ALTER DATABASE CLOSE NORMAL
----- Call Stack Trace -----

calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------

Exception signal: 11 (SIGSEGV)
+ACoAKgAq- 2004-12-23 01:01:02.067

ksedmp: internal or fatal error
Current SQL statement for this session:
ALTER DATABASE CLOSE NORMAL
----- Call Stack Trace -----

calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------

Shadow+AF8-Core+AF8-Dump +AD0- PARTIAL

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 23 2004 - 11:56:39 CST