RE: Oracle server is down during a COLD backup
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <mark.powell@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Dec 2004 14:22:28 -0500
What Mark said, but in addition, I recommend that you do a startup =
restrict, shutdown normal before the cold backup (after shutting down =
however you want to shut down where resorting to immediate or abort is =
often the best way to pull the plug). Of course that may be problematic =
if you've interrupted a huge transaction that will take more than your =
backup window to roll back, but then you probably shouldn't have =
interrupted it in the first place.
Not really sure why you want a cold backup, but that's your business.
Regards,
mwf
-----Original Message-----
From: oracle-l-bounce+AEA-freelists.org
+AFs-mailto:oracle-l-bounce+AEA-freelists.org+AF0-On Behalf Of Powell, =
Mark D
Sent: Thursday, December 23, 2004 1:22 PM
To: oracle-l+AEA-freelists.org
Subject: 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
+AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9=
AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9AD0APQA9A=
D0APQA9AD0APQ-
+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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
