Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle server is down during a COLD backup
I searched on metalink on the exact phrase +ACI-ALTER DATABASE CLOSE NORMAL+ACI- and
all the words: +ACI-ksedmp: internal or fatal error+ACI- and received 18 bug
reports. I think you will need to open an iTAR and upload the trace file to
get help from support narrowing down the issue.
Stopping the database using a +ACI-shutdown immediate+ACI- is a pretty normal task so, no your cold backup is not the root cause of the error. The problem occurred while the database was being shutdown. This could be a space leak issue. As long as the database starts cleanly you can probably live with it.
If your database is 8.1.7.0 you should consider trying to upgrade to the terminal release for the version which is at least 8.1.7.4.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce+AEA-freelists.org
+AFs-mailto:oracle-l-bounce+AEA-freelists.org+AF0-On Behalf Of Nguyen, David M
Sent: Thursday, December 23, 2004 1:01 PM
To: oracle-l+AEA-freelists.org
Subject: Oracle server is down during a COLD backup
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
+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
location type point (? means dubious value) -------------------- -------- -------------------- ----------------------------
calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ----------------------------
calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ----------------------------
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 23 2004 - 12:21:02 CST
![]() |
![]() |