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]
1. Try writing the backup to another location
alter database backup controlfile to '/tmp/cntrlfilebk.dbf'
2. Try it again with the reuse clause
3. 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
a) 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: [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).