Offline backup Error

[Former Member]

Hi,

Offline and online backup we are usning Tivoli Storage Manager. It was going on fine. Suddenly Offline backup we got below error message. What could be the problem. how to resolve this one. kindly help me.

BR0280I BRBACKUP time stamp: 2010-07-09 12.04.15

BR0307I Shutting down database instance KBD ...

BR0278E Command output of '/oracle/KBD/102_64/bin/sqlplus /nolog < /oracle/KBD/sapbackup/.bedqceva.spi':

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jul 9 12:04:16 2010

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> Connected.

SQL>

SQL> ORA-00600: internal error code, arguments: [3708], [910], [], [], [], [], [],

[]

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

BR0280I BRBACKUP time stamp: 2010-07-09 12.21.42

BR0279E Return code from '/oracle/KBD/102_64/bin/sqlplus /nolog < /oracle/KBD/sapbackup/.bedqceva.spi': 0

BR0302E SQLPLUS call for database instance KBD failed

BR0309E Shutdown of database instance KBD failed

BR0280I BRBACKUP time stamp: 2010-07-09 12.21.42

BR0301E SQL error -1089 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-01089: immediate shutdown in progress - no operations are permitted

BR0310E Connect to database instance KBD failed

BR0056I End of database backup: bedqceva.aff 2010-07-09 12.21.42

BR0280I BRBACKUP time stamp: 2010-07-09 12.21.42

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2010-07-09 12.21.42

BR0291I BRARCHIVE will be started with options '-U -d util_file -cds -c force -u /'

BR0280I BRBACKUP time stamp: 2010-07-09 12.39.40

BR0292I Execution of BRARCHIVE finished with return code 5

kvl

[Former Member]

Without any more information, it's hard to say.....

Did you even search the formum and/or google for the ORA-00600 error with argument 3708 ?

Could be some kind of log writer problem.

During the shutdown a message is sent to the LGWR and it didn't respond within 910 seconds.

This matches the 15 minutes you have between start and end of the backup job.

Log disk full? Database and redologs on same disk?

Inspect the trace files from to get more information.

[Former Member]

Hi,

Thanx

There is enough sapce in disk. in alert log below message are there. kindly help me.

Fri Jul 9 12:04:18 2010

Shutting down instance: further logons disabled

Fri Jul 9 12:04:18 2010

Completed checkpoint up to RBA [0x333f.2.10], SCN: 135879580

Fri Jul 9 12:04:18 2010

Stopping background process CJQ0

Fri Jul 9 12:04:18 2010

Stopping background process QMNC

Fri Jul 9 12:04:22 2010

Stopping background process MMNL

Fri Jul 9 12:04:24 2010

Stopping background process MMON

Fri Jul 9 12:04:27 2010

Shutting down instance (immediate)

License high water mark = 31

Fri Jul 9 12:04:27 2010

Stopping Job queue slave processes

Fri Jul 9 12:04:27 2010

Job queue slave processes stopped

Fri Jul 9 12:04:32 2010

Process OS id : 884768 alive after kill

Errors in file

Fri Jul 9 12:05:43 2010

Incremental checkpoint up to RBA [0x333f.159b.0], current log tail at RBA [0x333f.15ab.0]

Fri Jul 9 12:06:17 2010

ALTER DATABASE CLOSE NORMAL

Fri Jul 9 12:06:17 2010

SMON: disabling tx recovery

SMON: disabling cache recovery

Fri Jul 9 12:06:20 2010

Shutting down archive processes

Archiving is disabled

Fri Jul 9 12:06:25 2010

ARCH shutting down

ARC1: Archival stopped

Fri Jul 9 12:06:30 2010

ARCH shutting down

ARC0: Archival stopped

Fri Jul 9 12:21:35 2010

Errors in file /oracle/KBD/saptrace/background/kbd_lgwr_1015978.trc:

Fri Jul 9 12:21:40 2010

Errors in file /oracle/KBD/saptrace/usertrace/kbd_ora_696408.trc:

ORA-00600: internal error code, arguments: [3708], [910], [], [], [], [], [], []

Fri Jul 9 12:21:42 2010

CLOSE: Error 600 during database close

Fri Jul 9 12:21:42 2010

SMON: enabling cache recovery

SMON: enabling tx recovery

Fri Jul 9 12:21:42 2010

ORA-600 signalled during: ALTER DATABASE CLOSE NORMAL...

Fri Jul 9 12:23:31 2010

Thread 1 closed at log sequence 13119

Successful close of redo thread 1

Fri Jul 9 12:26:42 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:26:43 2010

MMNL absent for 1393 secs; Foregrounds taking over

Fri Jul 9 12:26:43 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:26:44 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:26:45 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:26:46 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:26:56 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:27:06 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:27:16 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:27:26 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:27:36 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:27:46 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:27:56 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:28:06 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:28:16 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:28:26 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:28:36 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:28:46 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:28:56 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:29:06 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:29:16 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:29:26 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:29:36 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:29:46 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:29:56 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:30:06 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:30:16 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:30:26 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:30:36 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:30:46 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

ORA-01110: data file 1: '/oracle/KBD/sapdata1/system_1/system.data1'

Fri Jul 9 12:30:56 2010

Errors in file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 1 cannot be read at this time

kvl

[Former Member]

You need to check weather the file is ok or not.

logon as orakbd and run:

sqlplus /nolog

connect / as sysdba

select ONLINE_STATUS from dba_data_files where file_id = 1;

online/offline/recover ?

[Former Member]

Hi,

Thanx

it is showing online.

kvl

[Former Member]

The error you receive seems to be caused by an earlier error.

Have a look in the database alert log to see if there are any other errors there.

Also check the trace file /oracle/KBD/saptrace/background/kbd_smon_1036306.trc

to see if it can bring any light to the cause of the problem.