RE: ORA600 [2103] [0] [0] [1] [900]

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sun, 15 Jun 2003 08:39:01 -0700
Message-ID: <F001.005B1EDD.20030615081918@fatcity.com>

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]

Try writing the backup to another location alter database backup controlfile to '/tmp/cntrlfilebk.dbf'
Try it again with the reuse clause
Is the file system '/hot_backup/siebelp1' local or NFS mounted ?

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

alert

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)

2003-06-12 02:49:08.500
SESSION ID:(137.947) 2003-06-12 02:49:08.463

TIMEOUT ON CONTROL FILE ENQUEUE mode=X, type=0, wait=1, eqt=900

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

--------------------------------------------------------------------- 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). 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
---------------------------------------------------------------------
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