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).
Received on Thu Jun 12 2003 - 10:58:38 CDT
