Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA600 [2103] [0] [0] [1] [900]
So, did you get the same error when writing the backup to /tmp as well ?
And also if you delete the previous backup and create a backup without the
REUSE ?
If the problem is really a Control File Enqueue timeout, is the server
really that busy ?
How about trying the controlfile backup at a time when the server is "less
busy" --- to
verify the "busy"ness being the cause of the Control File Enqueue
Hemant
At 11:44 PM 12-06-03 -0800, you wrote:
It is a local filesystem
Kind Regards,
Hatzistavrou Yannis
-----Original Message-----
From: Hemant K Chitale [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 7:15 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA600 [2103] [0] [0] [1] [900]
Hemant
At 02:45 AM 12-06-03 -0800, you wrote:
Dear All,
I have encountered the following message during alter database backup controlfile to && reuse after a hot backup.
We have opened a tar but still waiting. The strange think is that our Oracle versions range from 8.1.7.3 to 8.1.7.4 which according to what I have read resolved this problem. Another strange fact is that this happened concurrently on three clusters of Sun Solaris 8.
Attached please find extracts from alert and trace files
hread 1 advanced to log sequence 41062
Thu Jun 12 02:33:43 2003
ARC1: Beginning to archive log# 1 seq# 41061
Thu Jun 12 02:33:43 2003
Current log# 2 seq# 41062 mem# 0:
/be/prod/crm_oss/oracle/siebel/redo_logs/sbl_redo_2A.log
Current log# 2 seq# 41062 mem# 1:
/be/prod/crm_oss/oracle/siebel/redo_logs/sbl_redo_2B.log
Thu Jun 12 02:33:44 2003
Completed: alter database backup controlfile to trace
Thu Jun 12 02:33:44 2003
alter database backup controlfile to '/hot_backup/siebelp1/control01.bak' reuse
Thu Jun 12 02:49:10 2003
Errors in file
/be/prod/crm/siebel/oracle/siebelp1/admin/bdump/siebelp1_arc1_16563.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [2103] [0] [0] [1] [900]
Thu Jun 12 02:49:12 2003
Errors in file
/be/prod/crm/siebel/oracle/siebelp1/admin/bdump/siebelp1_arc1_16563.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [2103] [0] [0] [1] [900]
Thu Jun 12 02:49:12 2003
ARC1: terminating instance due to error 600
Instance terminated by ARC1, pid = 16563
Thu Jun 12 02:49:47 2003
Starting ORACLE instance (normal)
b) trace
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
ORACLE_HOME = /oracle_home/product/8.1.7
System name: SunOS
Node name: apps01-n01
Release: 5.8
Version: Generic_108528-21
Machine: sun4u
Instance name: siebelp1
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 16563, image: [EMAIL PROTECTED] (ARC1)
SYSTEM STATE
System global information:
Number of NUMA instances : 1
processes: base 9010fe44, size 250, cleanup 90110864
allocation: free sessions(0) 90174724, free calls(0) 1
control alloc errors: 0 (process), 0 (session), 0 (call)
system statistics:
0 47997 logons cumulative
0 1052 logons current
0 1649040 opened cursors cumulative
0 41528 opened cursors current
0 1311839 user commits
0 7201 user rollbacks
0 30519546 user calls
0 22909587 recursive calls
0 1827715 recursive cpu usage
0 1553098488 session logical reads
0 0 session stored procedure space
0 6209740 CPU used when call started
0 143359357 CPU used by this session
8236 791247589 session connect time
8236 791247589 process last non-idle time
1020 304666384 session uga memory
Has anybody encountered such problem before? How can it be resolved?
Kind Regards,
Hatzistavrou Yannis
Database Administrator
SchlumbergerSema
Phone ext. 478
Email:
<mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:
Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services
-- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing
list and web hosting services
--------------------------------------------------------------------- ToREMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Sun Jun 15 2003 - 10:39:01 CDT
![]() |
![]() |