Subject:
Ora-6
00
[3664
]
Doc
ID:
457212.1
Type:
PROBLEM
Modif
ied
Date
:
21-MAY-2008
Status:
PUBLISHED
In this Document
Symptoms
Changes
Cause
Solution
References
Applies to:
Oracle Server -
Enterprise Edition -
Version: 8.1.7.4 to 11.1
This problem can occur
on any platform.
Oracle RDBMS Server
Symptoms
The BEGIN BACKUP
command generates
ORA-00600 [3664]
The alert log will show
similar to the following
ALTER TABLESPACE "SYSTEM
" BEGIN BACKUP
Mon Sep 3 09:47:16 2007
Errors in file /opt/orac
le/app/oracle/admin/cspr
cpn1/udump/csprcpn1_ora_
17512.trc:
ORA-00600: internal erro
r code, arguments: [3664
], [1], [1], [5], [1925]
, [2201709226], [1925],
[2201714677]
Mon Sep 3 09:47:18 2007
ORA-600 signalled during
: ALTER TABLESPACE "SYST
EM" BEGIN BACKUP...
The tracefile will show
similar to the following
ksedmp: internal or fata
l error
ORA-00600: internal erro
r code, arguments: [3664
] [1] [1] [4] [1925]
Current SQL statement fo
r this session:
ALTER TABLESPACE "SYSTEM
" BEGIN BACKUP
----- Call Stack Trace -
----
ksedmp kgeriv kgesiv kse
sic7 kcvucp kcvbhb
atsdrv opiexe opiosq0 op
iodr ttcpip opitsk
opiino opiodr opidrv sou
2o main start
Changes
The above error occurs
while running the
hotbackup scripts , that
places the tablespace in
backup mode and then
copies the files.
Cause
The problem occurs
during following
sequence.
ALTER TABLESPACE <TBS_NA
ME> BEGIN BACKUP;
before the above command
completes, the end
backup is called.
ALTER TABLESPACE <TBS_NA
ME> END BACKUP;
As the END BACKUP
command completes prior
to the completion of
BEGIN BACKUP, this error
was thrown. And this is
harmless.
This issue is discussed
in following bug.
Bug 238579
Status: 84,Closed, not
feasible to fix
Abstract: ORA-600
[3664][102][1][4][0][356
88444][0][35688444] ON
HOT BACKUP
Solution
To avoid these errors,
the script needs to be
modified, so that it
waits for BEGIN BACKUP
command to complete,
before it issues the END
BACKUP command.
In otherwords this is
due to the slowness in
BEGIN BACKUP command.
Whenever the BEGIN
BACKUP is issued, oracle
initiates checkpoint to
those datafiles.
As the checkpoint
operation takes more
time and by the time END
BACKUP was called this
error occurs.
Resolving the slowness
associated with
checkpoint will also
help in that case.
References
Bug 238579 - ORA-600
[3664][102][1][4][0][356
88444][0][35688444] ON
HOT BACKUP
Help us improve our
service. Please email us
your comments for this
document. .
Gary Bowers
<gbowers AT ITRUS DOT CO
M> To
Sent by: "ADSM: ADSM-L AT VM.MARIST DOT EDU
Dist Stor cc
Manager"
<[email protected] Subject
.EDU> Re: [ADSM-L] Help on TDP_R3 Oracel
- AIX
08/21/2009 07:59
AM
Please respond to
"ADSM: Dist Stor
Manager"
<[email protected]
.EDU>
The alter tablespace command is an Oracle command, not a TSM command.
If you were getting error with the library manager (TSM), you would
see problems with allocating a channel. I would get with your DBA to
do some investigation on this table. The BRBACKUP command just issues
Oracle commands under the covers.
Gary
Itrus Technologies
On Aug 21, 2009, at 3:10 AM, Yudi Darmadi wrote:
> Dear TSM'ers
>
> I have a TDP_R3 Oracle on AIX V5.5.0.0 - and when
> I think this is not TSM issue, but i just wanna know does anyone had
> been
> experince this case?
>
>
> BR0280I BRCONNECT time stamp: 2009-08-21 08.43.17
> BR0301E SQL error -600 at location db_file_switch-11
> ORA-00600: internal error code, arguments: [3664], [3], [1], [4], [0],
> [1954909839], [0], [1954909839]
> BR0316E 'Alter tablespace PSAPWPR begin backup' failed
> BR0280I BRCONNECT time stamp: 2009-08-21 08.43.17
>
>
> Best Regards,
>
>
> Yudi Darmadi
> PT Niagaprima Paramitra
> Jl. KH Ahmad Dahlan No.25 Kebayoran Baru, Jakarta Selatan 12130
> Phone: 021-72799949; Fax: 021-72799950; Mobile: 081905530830
> http://www.niagaprima.com
|