on 04-06-2010 4:59 AM
Dear All,
I am getting below error in db check .please suggest how to solve it.
BR0280I BRCONNECT time stamp: 2010-04-06 07.01.58
BR0974I Checking database messages in J:\ORACLE\PRD\SAPTRACE\BACKGROUND\alert_prd.log ...
BR0976W Database message alert - level: ERROR, line: 778246, time: 201dump [UNKNOWN] [.jslvss_session_start??hot+5sion_start??ho
Regards,
Kumar
Hi,
BR0974I Checking database messages in J:\ORACLE\PRD\SAPTRACE\BACKGROUND\alert_prd.log ...
So what is in your alert log for this ?
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please find the log and this time the online backup is running
Incremental checkpoint up to RBA [0xa37.124a5.0], current log tail at RBA [0xa37.1257a.0]
Mon Apr 05 21:14:55 2010
Incremental checkpoint up to RBA [0xa37.130f2.0], current log tail at RBA [0xa37.132fc.0]
Mon Apr 05 21:44:56 2010
Incremental checkpoint up to RBA [0xa37.14f29.0], current log tail at RBA [0xa37.151d1.0]
Mon Apr 05 22:00:16 2010
Beginning log switch checkpoint up to RBA [0xa38.2.10], SCN: 671659262
Mon Apr 05 22:00:16 2010
Thread 1 advanced to log sequence 2616 (LGWR switch)
Current log# 4 seq# 2616 mem# 0: H:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF
Current log# 4 seq# 2616 mem# 1: K:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF
Mon Apr 05 22:00:21 2010
/* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO 'I:\oracle\PRD\sapbackup\CNTRLPRD.DBF'
Mon Apr 05 22:00:21 2010
Completed: /* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO 'I:\oracle\PRD\sapbackup\CNTRLPRD.DBF'
Mon Apr 05 22:00:27 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPEL701D" BEGIN BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPEL701D" BEGIN BACKUP
Mon Apr 05 22:00:40 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPEL701D" END BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPEL701D" END BACKUP
Mon Apr 05 22:00:40 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPEL701I" BEGIN BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPEL701I" BEGIN BACKUP
Mon Apr 05 22:01:28 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPEL701I" END BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPEL701I" END BACKUP
Mon Apr 05 22:01:28 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPPRD" BEGIN BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRD" BEGIN BACKUP
Mon Apr 05 22:03:16 2010
Beginning log switch checkpoint up to RBA [0xa39.2.10], SCN: 671730894
Mon Apr 05 22:03:16 2010
Thread 1 advanced to log sequence 2617 (LGWR switch)
Current log# 1 seq# 2617 mem# 0: H:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF
Current log# 1 seq# 2617 mem# 1: K:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF
Mon Apr 05 22:03:28 2010
Beginning log switch checkpoint up to RBA [0xa3a.2.10], SCN: 671734489
Mon Apr 05 22:03:28 2010
Thread 1 advanced to log sequence 2618 (LGWR switch)
Current log# 2 seq# 2618 mem# 0: H:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF
Current log# 2 seq# 2618 mem# 1: K:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF
Mon Apr 05 22:05:14 2010
Completed checkpoint up to RBA [0xa38.2.10], SCN: 671659262
Mon Apr 05 22:08:16 2010
Completed checkpoint up to RBA [0xa39.2.10], SCN: 671730894
Mon Apr 05 22:08:29 2010
Completed checkpoint up to RBA [0xa3a.2.10], SCN: 671734489
Mon Apr 05 22:14:58 2010
Incremental checkpoint up to RBA [0xa3a.cf34.0], current log tail at RBA [0xa3a.d670.0]
Mon Apr 05 22:44:58 2010
Incremental checkpoint up to RBA [0xa3a.10c06.0], current log tail at RBA [0xa3a.10cfe.0]
Mon Apr 05 23:11:26 2010
Beginning log switch checkpoint up to RBA [0xa3b.2.10], SCN: 672108964
Mon Apr 05 23:11:26 2010
Thread 1 advanced to log sequence 2619 (LGWR switch)
Current log# 3 seq# 2619 mem# 0: H:\ORACLE\PRD\ORIGLOGA\LOG_G13M1.DBF
Current log# 3 seq# 2619 mem# 1: K:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF
Mon Apr 05 23:14:59 2010
Incremental checkpoint up to RBA [0xa3a.120fd.0], current log tail at RBA [0xa3b.e966.0]
Mon Apr 05 23:16:29 2010
Completed checkpoint up to RBA [0xa3b.2.10], SCN: 672108964
Mon Apr 05 23:45:01 2010
Incremental checkpoint up to RBA [0xa3b.10d59.0], current log tail at RBA [0xa3b.10f66.0]
Tue Apr 06 00:00:27 2010
Beginning log switch checkpoint up to RBA [0xa3c.2.10], SCN: 672115259
Tue Apr 06 00:00:27 2010
Thread 1 advanced to log sequence 2620 (LGWR switch)
Current log# 4 seq# 2620 mem# 0: H:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF
Current log# 4 seq# 2620 mem# 1: K:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF
Tue Apr 06 00:05:31 2010
Completed checkpoint up to RBA [0xa3c.2.10], SCN: 672115259
Tue Apr 06 00:15:03 2010
Incremental checkpoint up to RBA [0xa3c.1161.0], current log tail at RBA [0xa3c.1238.0]
Tue Apr 06 00:45:04 2010
Incremental checkpoint up to RBA [0xa3c.4c81.0], current log tail at RBA [0xa3c.4ead.0]
Tue Apr 06 00:52:19 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPPRD" END BACKUP
Tue Apr 06 00:52:20 2010
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRD" END BACKUP
Tue Apr 06 00:52:20 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPPRD640" BEGIN BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRD640" BEGIN BACKUP
Tue Apr 06 01:15:06 2010
Incremental checkpoint up to RBA [0xa3c.58c2.0], current log tail at RBA [0xa3c.59a9.0]
Tue Apr 06 01:32:56 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPPRD640" END BACKUP
Tue Apr 06 01:32:57 2010
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRD640" END BACKUP
Tue Apr 06 01:32:57 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPPRD701" BEGIN BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRD701" BEGIN BACKUP
Tue Apr 06 01:45:09 2010
Incremental checkpoint up to RBA [0xa3c.69de.0], current log tail at RBA [0xa3c.6a73.0]
Tue Apr 06 02:15:17 2010
Incremental checkpoint up to RBA [0xa3c.72b3.0], current log tail at RBA [0xa3c.73c4.0]
Tue Apr 06 02:45:25 2010
Incremental checkpoint up to RBA [0xa3c.d1d9.0], current log tail at RBA [0xa3c.d294.0]
Tue Apr 06 03:00:21 2010
Errors in file i:\oracle\prd\saptrace\background\prd_000_6756.trc:
ORA-07445: exception encountered: core dump [UNKNOWN] [.jslvss_session_start??hot+5088] [PC:0x81D0560] [] [] []
Tue Apr 06 03:15:58 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPPRD701" END BACKUP
Tue Apr 06 03:15:58 2010
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRD701" END BACKUP
Tue Apr 06 03:15:59 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPPRDUSR" BEGIN BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRDUSR" BEGIN BACKUP
Tue Apr 06 03:18:17 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPPRDUSR" END BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPPRDUSR" END BACKUP
Tue Apr 06 03:18:17 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO" BEGIN BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO" BEGIN BACKUP
Tue Apr 06 03:18:27 2010
Incremental checkpoint up to RBA [0xa3c.dc1c.0], current log tail at RBA [0xa3c.dd8c.0]
Tue Apr 06 03:32:11 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO" END BACKUP
Tue Apr 06 03:32:11 2010
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO" END BACKUP
Tue Apr 06 03:32:11 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO2" BEGIN BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO2" BEGIN BACKUP
Tue Apr 06 03:41:26 2010
/* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO2" END BACKUP
Tue Apr 06 03:41:26 2010
Completed: /* BRBACKUP */ ALTER TABLESPACE "PSAPUNDO2" END BACKUP
Tue Apr 06 03:41:26 2010
/* BRBACKUP */ ALTER TABLESPACE "SYSAUX" BEGIN BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "SYSAUX" BEGIN BACKUP
Tue Apr 06 03:43:25 2010
/* BRBACKUP */ ALTER TABLESPACE "SYSAUX" END BACKUP
Tue Apr 06 03:43:25 2010
Completed: /* BRBACKUP */ ALTER TABLESPACE "SYSAUX" END BACKUP
Tue Apr 06 03:43:25 2010
/* BRBACKUP */ ALTER TABLESPACE "SYSTEM" BEGIN BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "SYSTEM" BEGIN BACKUP
Tue Apr 06 03:45:25 2010
/* BRBACKUP */ ALTER TABLESPACE "SYSTEM" END BACKUP
Completed: /* BRBACKUP */ ALTER TABLESPACE "SYSTEM" END BACKUP
Tue Apr 06 03:46:55 2010
Beginning log switch checkpoint up to RBA [0xa3d.2.10], SCN: 672128074
Tue Apr 06 03:46:55 2010
Thread 1 advanced to log sequence 2621 (LGWR switch)
Current log# 1 seq# 2621 mem# 0: H:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF
Current log# 1 seq# 2621 mem# 1: K:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF
Tue Apr 06 03:48:29 2010
Incremental checkpoint up to RBA [0xa3c.f186.0], current log tail at RBA [0xa3d.25c.0]
Tue Apr 06 03:52:04 2010
Completed checkpoint up to RBA [0xa3d.2.10], SCN: 672128074
Tue Apr 06 04:18:31 2010
Incremental checkpoint up to RBA [0xa3d.78e4.0], current log tail at RBA [0xa3d.7a15.0]
Tue Apr 06 04:47:21 2010
Beginning log switch checkpoint up to RBA [0xa3e.2.10], SCN: 672157698
Tue Apr 06 04:47:21 2010
Thread 1 advanced to log sequence 2622 (LGWR switch)
Current log# 2 seq# 2622 mem# 0: H:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF
Current log# 2 seq# 2622 mem# 1: K:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF
Tue Apr 06 04:48:31 2010
Incremental checkpoint up to RBA [0xa3d.12291.0], current log tail at RBA [0xa3e.1fc0.0]
Tue Apr 06 04:52:25 2010
Completed checkpoint up to RBA [0xa3e.2.10], SCN: 672157698
Tue Apr 06 05:18:32 2010
Incremental checkpoint up to RBA [0xa3e.9648.0], current log tail at RBA [0xa3e.976e.0]
Tue Apr 06 05:48:32 2010
Incremental checkpoint up to RBA [0xa3e.1197f.0],
Regards,
hi,
Yes you are right we have just upgrade our su=system from ecc5 to ecc6 ehp4.
And sorry this trc file and in this there is oracle trc files also
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 2200, 4 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:3M/16362M, Ph+PgF:42925M/75999M
Instance name: prd
Redo thread mounted by this instance: 1
Oracle process number: 98
Windows thread id: 6756, image: ORACLE.EXE (J000)
SERVICE NAME:(SYS$USERS) 2010-04-06 03:00:20.398
SESSION ID:(1356.8276) 2010-04-06 03:00:20.398
2010-04-06 03:00:20.398
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [UNKNOWN] [.jslvss_session_start??hot+5088] [PC:0x81D0560] [] [] []
check trace file e:\oracle\prd\102\rdbms\trace\prd_ora_0.trc for preloading .sym file messages
-
Call Stack Trace -
calling call entry argument values in hex
location type point (? means dubious value)
-
-
-
-
.jslvss_session_sta 0000000000000000
rt??hot+5088
.jslve_execute0??ho UNK .jslvss_session_sta
t2416 rt??hot5088
.jslve_execute??hot UNK .jslve_execute0??ho
672 t2416
.rpiswu2??hot+2160 UNK .jslve_execute??hot
+672
.kkjex1e1104 UNK .rpiswu2??hot2160
.kkjsexe??hot944 UNK .kkjex1e1104
.kkjrdp??hot1856 UNK .kkjsexe??hot944
.opirip??hot2224 UNK .kkjrdp??hot1856
.opidrv??hot1856 UNK .opirip??hot2224
.sou2o96 UNK .opidrv??hot1856
.opimai_real??hot6 UNK .sou2o96
56
.opimai??hot224 UNK .opimai_real??hot6
56
.BackgroundThreadSt UNK .opimai??hot+224
art+4048
0000000075A47AE0 UNK .BackgroundThreadSt
art+4048
2010-03-14 05:28:24.351
===== begin preloading .sym files
===== end preloading .sym files
Dump file e:\oracle\prd\102\rdbms\trace\prd_ora_0.trc
Mon Mar 22 03:50:44 2010
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 2200, 4 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:15235M/16362M, Ph+PgF:48922M/75999M
Instance name: prd
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Windows thread id: 3312, image: ORACLE.EXE
2010-03-22 03:50:44.976
===== begin preloading .sym files
===== end preloading .sym files
Dump file e:\oracle\prd\102\rdbms\trace\prd_ora_0.trc
Mon Mar 22 03:50:59 2010
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 2200, 4 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:15213M/16362M, Ph+PgF:48922M/75999M
Instance name: prd
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Windows thread id: 3496, image: ORACLE.EXE
2010-03-22 03:50:59.546
===== begin preloading .sym files
===== end preloading .sym files
Regards,
kumar
Hi,
Dump file e:\oracle\prd\102\rdbms\trace\prd_ora_0.trc
Mon Mar 22 03:50:59 2010
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 2200, 4 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:15213M/16362M, Ph+PgF:48922M/75999M
Instance name: prd
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Windows thread id: 3496, image: ORACLE.EXE
2010-03-22 03:50:59.546
===== begin preloading .sym files
===== end preloading .sym files
Regards,
Kumar
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.