Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle server is down during a COLD backup

RE: Oracle server is down during a COLD backup

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 23 Dec 2004 14:22:28 -0500
Message-ID: <KNEIIDHFLNJDHOOCFCDKGEDNFNAA.mwf@rsiz.com>


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

location             type     point                (? means dubious =
value)
location             type     point                (? means dubious =
value)
location             type     point                (? means dubious =
value)
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 23 2004 - 13:23:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US