cancel
Showing results for 
Search instead for 
Did you mean: 

Large Core Dumps after DB Backup Control File

Former Member
0 Kudos

Hi All,

Server Specs (it is the test server having no functional modules):

Windows 2003 64bit

Oracle 10.2.0.4 (Patched from 10.2.0.2)

Netweaver 2004s

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
ORA-00279: change 21375038 generated at 09/21/2007 20:12:47 needed for thread 1
ORA-00289: suggestion : /export/pspp/oracle/dbs/xxx_example_xxx.dbf
ORA-00280: change 21375038 for thread 1 is in sequence #4

Specify log: {=suggested | filename | AUTO | CANCEL}
/OraRedo/RedoLogFiles/xxx_example_xxx.dbf
Log applied.
Media recovery complete.

I was facing Control file inconsistence issues against 2 partitions. Issue was resolved by using above commands and Netweaver started successfully. Im now facing another problem, im getting huge tracefiles in SAPTRACE\BACKGROUND folder since its recovery. I deleted those tracefiles which were of approx. 86GB.

Current Tracefiles sizes are:

<drive>:\oracle\TST\saptrace\background\tst_m000_5188.trc (7MB) and it is getting double by each generation.

Here are tracefiles of today (old ones deleted by me coz it was consuming a hell of space, e.g: 86GB as mentioned):

tst_m000_5188.trc (7 MB) Latest

tst_j000_5316.trc (4MB)

Here is Initial info from alert_tst.txt file contained in same folder:

Dump file f:\oracle\tst\saptrace\background\alert_tst.log

Thu Sep 02 13:55:34 2010
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V5.2 Service Pack 1
CPU                 : 2 - type 8664, 1 Physical Cores
Process Affinity    : 0x0000000000000000
Memory (Avail/Total): Ph:2886M/4019M, Ph+PgF:19295M/20131M
Thu Sep 02 13:55:34 2010
Starting ORACLE instance (normal)
Thu Sep 02 13:55:35 2010
Specified value of sga_max_size is too small, bumping to 666894336
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
  processes                = 80
  sessions                 = 96
  event                    = 10191 trace name context forever, level 1
  sga_max_size             = 666894336
  shared_pool_size         = 318767104
  shared_pool_reserved_size= 31598837
  filesystemio_options     = setall
  control_files            = E:\ORACLE\TST\ORIGLOGA\CNTRL\CNTLRTST.DBF, E:\ORACLE\TST\ORIGLOGB\CNTRL\CNTRLTST.DBF, F:\ORACLE\TST\SAPDATA1\CNTRL\CNTRLTST.DBF
  control_file_record_keep_time= 30
  db_block_size            = 8192
  db_cache_size            = 318767104
  compatible               = 10.2.0
  log_archive_dest         = E:\oracle\TST\oraarch\TSTarch
  log_buffer               = 2061312
  log_checkpoint_interval  = 0
  db_files                 = 254
  log_checkpoints_to_alert = TRUE
  dml_locks                = 4000
  undo_management          = AUTO
  undo_tablespace          = PSAPUNDO
  undo_retention           = 43200
  recyclebin               = off
  remote_os_authent        = TRUE
  remote_login_passwordfile= EXCLUSIVE
  job_queue_processes      = 1
  background_dump_dest     = F:\ORACLE\TST\SAPTRACE\BACKGROUND
  user_dump_dest           = F:\ORACLE\TST\SAPTRACE\USERTRACE
  core_dump_dest           = F:\ORACLE\TST\SAPTRACE\BACKGROUND
  optimizer_features_enable= 10.2.0.1
  sort_area_size           = 2097152
  sort_area_retained_size  = 0
  db_name                  = TST
  open_cursors             = 800
  _optim_peek_user_binds   = FALSE
  pga_aggregate_target     = 421317836
  workarea_size_policy     = AUTO
  statistics_level         = typical
MMAN started with pid=4, OS id=2760
PMON started with pid=2, OS id=2748
DBW0 started with pid=5, OS id=712
LGWR started with pid=6, OS id=604
CKPT started with pid=7, OS id=1088
SMON started with pid=8, OS id=1164
RECO started with pid=9, OS id=2680
CJQ0 started with pid=10, OS id=2972
MMON started with pid=11, OS id=1816
MMNL started with pid=12, OS id=2904
PSP0 started with pid=3, OS id=2692

Please Review,

Thanks in Advance.

Best Regards.

Accepted Solutions (0)

Answers (1)

Answers (1)

volker_borowski2
Active Contributor
0 Kudos

Hi,

well, a couple of strange parameters for a 10.2.0.4 system. (You should check the parameter recommendation note)

shared_pool_size should be 450M minimum.

db_cache_size is rather small

automatic pga not enabled

optimizer_features_enable set to wrong value.

Controlfiles only on two diffrent drives (E: & F:), so if you have "issues" with two partitions, what was left intact?

Recovery clip shows unix style pathnames with non sap conform path environment.

How was that related to this system TST?

Showing us the startup from the alert log does not really help, when you have a later issue that writes a diffrent trace.

Would be better to show the alert-log-section aroud the timestamp when the error occurred.

Would be good to have at least part of the trace as well, possibly filtered for some kind of error code

like ORA-nnnnn / PLS-nnnnn / TNS-nnnnn or like that.

Sorry, but we need more information to help.

Volker

Former Member
0 Kudos

Continued Log:

CREATE DATABASE TST CONTROLFILE REUSE  MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXLOGHISTORY 1000 MAXDATAFILES 254 MAXINSTANCES 50 NOARCHIVELOG CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 DATAFILE 'E:\oracle\TST\sapdata1\system_1\system.data1' SIZE 500M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE 'E:\oracle\TST\sapdata1\temp_1\temp.data1' SIZE 1000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M UNDO TABLESPACE PSAPUNDO DATAFILE 'E:\oracle\TST\sapdata1\undo_1\undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M SYSAUX DATAFILE 'E:\oracle\TST\sapdata1\sysaux_1\sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
LOGFILE GROUP 1 ('E:\oracle\TST/origlogA/log_g11m1.dbf',
'E:\oracle\TST/mirrlogA/log_g11m2.dbf') SIZE 50M  REUSE ,
GROUP 2 ('E:\oracle\TST/origlogB/log_g12m1.dbf',
'E:\oracle\TST/mirrlogB/log_g12m2.dbf') SIZE 50M  REUSE ,
GROUP 3 ('E:\oracle\TST/origlogA/log_g13m1.dbf',
'E:\oracle\TST/mirrlogA/log_g13m2.dbf') SIZE 50M  REUSE ,
GROUP 4 ('E:\oracle\TST/origlogB/log_g14m1.dbf',
'E:\oracle\TST/mirrlogB/log_g14m2.dbf') SIZE 50M  REUSE

Thu Sep 02 13:55:40 2010
Database mounted in Exclusive Mode
Thu Sep 02 13:55:48 2010
Successful mount of redo thread 1, with mount id 1869855451
Assigning activation ID 1869855451 (0x6f73badb)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: E:\ORACLE\TST\ORIGLOGA\LOG_G11M1.DBF
  Current log# 1 seq# 1 mem# 1: E:\ORACLE\TST\MIRRLOGA\LOG_G11M2.DBF
Successful open of redo thread 1
Thu Sep 02 13:55:48 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Sep 02 13:55:48 2010
SMON: enabling cache recovery
Thu Sep 02 13:55:48 2010
Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.3.0]
Thu Sep 02 13:55:48 2010
create tablespace SYSTEM datafile  'E:\oracle\TST\sapdata1\system_1\system.data1' SIZE 500M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M 
  EXTENT MANAGEMENT LOCAL online

Thu Sep 02 13:55:55 2010
Completed: create tablespace SYSTEM datafile  'E:\oracle\TST\sapdata1\system_1\system.data1' SIZE 500M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M 
  EXTENT MANAGEMENT LOCAL online
Thu Sep 02 13:55:55 2010
create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)

Completed: create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
Thu Sep 02 13:55:59 2010
CREATE UNDO TABLESPACE PSAPUNDO DATAFILE  'E:\oracle\TST\sapdata1\undo_1\undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

Thu Sep 02 13:56:10 2010
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE PSAPUNDO DATAFILE  'E:\oracle\TST\sapdata1\undo_1\undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M 
Thu Sep 02 13:56:10 2010
create tablespace SYSAUX datafile  'E:\oracle\TST\sapdata1\sysaux_1\sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online

Completed: create tablespace SYSAUX datafile  'E:\oracle\TST\sapdata1\sysaux_1\sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
Thu Sep 02 13:56:13 2010
CREATE TEMPORARY TABLESPACE PSAPTEMP TEMPFILE  'E:\oracle\TST\sapdata1\temp_1\temp.data1' SIZE 1000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M 

Completed: CREATE TEMPORARY TABLESPACE PSAPTEMP TEMPFILE  'E:\oracle\TST\sapdata1\temp_1\temp.data1' SIZE 1000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M 
Thu Sep 02 13:56:13 2010
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP

Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP
Thu Sep 02 13:56:13 2010
ALTER DATABASE DEFAULT TABLESPACE SYSTEM

Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM 
Thu Sep 02 13:56:14 2010
SMON: enabling tx recovery
Thu Sep 02 13:56:14 2010
Beginning local checkpoint up to RBA [0x1.7509.10], SCN: 10382
Completed checkpoint up to RBA [0x1.7509.10], SCN: 10382
Threshold validation cannot be done before catproc is loaded.
replication_dependency_tracking turned off (no async multimaster replication found)
Thu Sep 02 13:56:16 2010
Errors in file f:\oracle\tst\saptrace\usertrace\tst_ora_656.trc:
ORA-00942: table or view does not exist

Former Member
0 Kudos

Continued Log:

Starting background process QMNC
QMNC started with pid=14, OS id=1408
Thu Sep 02 13:56:16 2010
Completed: CREATE DATABASE TST CONTROLFILE REUSE  MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXLOGHISTORY 1000 MAXDATAFILES 254 MAXINSTANCES 50 NOARCHIVELOG CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 DATAFILE 'E:\oracle\TST\sapdata1\system_1\system.data1' SIZE 500M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE 'E:\oracle\TST\sapdata1\temp_1\temp.data1' SIZE 1000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M UNDO TABLESPACE PSAPUNDO DATAFILE 'E:\oracle\TST\sapdata1\undo_1\undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M SYSAUX DATAFILE 'E:\oracle\TST\sapdata1\sysaux_1\sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
LOGFILE GROUP 1 ('E:\oracle\TST/origlogA/log_g11m1.dbf',
'E:\oracle\TST/mirrlogA/log_g11m2.dbf') SIZE 50M  REUSE ,
GROUP 2 ('E:\oracle\TST/origlogB/log_g12m1.dbf',
'E:\oracle\TST/mirrlogB/log_g12m2.dbf') SIZE 50M  REUSE ,
GROUP 3 ('E:\oracle\TST/origlogA/log_g13m1.dbf',
'E:\oracle\TST/mirrlogA/log_g13m2.dbf') SIZE 50M  REUSE ,
GROUP 4 ('E:\oracle\TST/origlogB/log_g14m1.dbf',
'E:\oracle\TST/mirrlogB/log_g14m2.dbf') SIZE 50M  REUSE

Thu Sep 02 13:56:35 2010
Beginning log switch checkpoint up to RBA [0x2.2.10], SCN: 38500
Thu Sep 02 13:56:35 2010
Thread 1 advanced to log sequence 2 (LGWR switch)
  Current log# 2 seq# 2 mem# 0: E:\ORACLE\TST\ORIGLOGB\LOG_G12M1.DBF
  Current log# 2 seq# 2 mem# 1: E:\ORACLE\TST\MIRRLOGB\LOG_G12M2.DBF
Thu Sep 02 13:57:03 2010
Beginning log switch checkpoint up to RBA [0x3.2.10], SCN: 68225
Thu Sep 02 13:57:03 2010
Thread 1 advanced to log sequence 3 (LGWR switch)
  Current log# 3 seq# 3 mem# 0: E:\ORACLE\TST\ORIGLOGA\LOG_G13M1.DBF
  Current log# 3 seq# 3 mem# 1: E:\ORACLE\TST\MIRRLOGA\LOG_G13M2.DBF
Thu Sep 02 13:57:28 2010
Beginning log switch checkpoint up to RBA [0x4.2.10], SCN: 85533
Thu Sep 02 13:57:28 2010
Thread 1 advanced to log sequence 4 (LGWR switch)
  Current log# 4 seq# 4 mem# 0: E:\ORACLE\TST\ORIGLOGB\LOG_G14M1.DBF
  Current log# 4 seq# 4 mem# 1: E:\ORACLE\TST\MIRRLOGB\LOG_G14M2.DBF
Thu Sep 02 13:58:41 2010
Completed checkpoint up to RBA [0x2.2.10], SCN: 38500
Thu Sep 02 13:58:51 2010
Beginning log switch checkpoint up to RBA [0x5.2.10], SCN: 106310
Thu Sep 02 13:58:51 2010
Thread 1 advanced to log sequence 5 (LGWR switch)
  Current log# 1 seq# 5 mem# 0: E:\ORACLE\TST\ORIGLOGA\LOG_G11M1.DBF
  Current log# 1 seq# 5 mem# 1: E:\ORACLE\TST\MIRRLOGA\LOG_G11M2.DBF

Will this log help? Now Im going to check the parameters u mentioned, and will reply back.

Thanks.

P.S: Im Currently reviewing: Note 830576 - Parameter recommendations for Oracle 10g

volker_borowski2
Active Contributor
0 Kudos

no, I suppose, none of the messages from the 2nd of Sep. will help dignosing your current problem.

I assume your problem is more recent.

So page on to a date that might be near your error.

Volker

Former Member
0 Kudos

All dispatchers and shared servers shutdown

Mon Jan 10 15:19:45 2011

ALTER DATABASE CLOSE NORMAL

Mon Jan 10 15:19:45 2011

SMON: disabling tx recovery

SMON: disabling cache recovery

Mon Jan 10 15:19:46 2011

Shutting down archive processes

Archiving is disabled

Mon Jan 10 15:19:51 2011

ARCH shutting down

ARC1: Archival stopped

Mon Jan 10 15:19:56 2011

ARCH shutting down

ARC0: Archival stopped

Mon Jan 10 15:19:57 2011

Thread 1 closed at log sequence 11

Successful close of redo thread 1

Mon Jan 10 15:19:59 2011

Completed: ALTER DATABASE CLOSE NORMAL

Mon Jan 10 15:19:59 2011

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Shutting down Data Guard Broker processes

Mon Jan 10 15:20:00 2011

Completed: Data Guard Broker shutdown

Mon Jan 10 15:20:02 2011

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Mon Jan 10 15:21:43 2011

Starting ORACLE instance (normal)

Mon Jan 10 15:21:43 2011

Specified value of sga_max_size is too small, bumping to 645922816

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

IMODE=BR

ILAT =10

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.4.0.

System parameters with non-default values:

processes = 80

sessions = 96

event = 10191 trace name context forever, level 1

sga_max_size = 645922816

shared_pool_size = 318767104

__java_pool_size = 4194304

java_pool_size = 4194304

shared_pool_reserved_size= 31598837

filesystemio_options = setall

control_files = E:\ORACLE\TST\ORIGLOGA\CNTRL\CNTLRTST.DBF, E:\ORACLE\TST\ORIGLOGB\CNTRL\CNTRLTST.DBF, F:\ORACLE\TST\SAPDATA1\CNTRL\CNTRLTST.DBF

control_file_record_keep_time= 30

db_block_size = 8192

db_cache_size = 318767104

compatible = 10.2.0

log_archive_dest = E:\oracle\TST\oraarch\TSTarch

log_buffer = 2061312

log_checkpoint_interval = 0

db_files = 254

log_checkpoints_to_alert = TRUE

dml_locks = 4000

undo_management = AUTO

undo_tablespace = PSAPUNDO

undo_retention = 43200

recyclebin = off

remote_os_authent = TRUE

remote_login_passwordfile= EXCLUSIVE

dispatchers = (PROTOCOL=TCP) (SERVICE=TSTXDB)

job_queue_processes = 1

background_dump_dest = F:\ORACLE\TST\SAPTRACE\BACKGROUND

user_dump_dest = F:\ORACLE\TST\SAPTRACE\USERTRACE

core_dump_dest = F:\ORACLE\TST\SAPTRACE\BACKGROUND

optimizer_features_enable= 10.2.0.1

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = TST

open_cursors = 800

optimpeek_user_binds = FALSE

pga_aggregate_target = 421317836

workarea_size_policy = AUTO

statistics_level = typical

dg_broker_start = TRUE

PMON started with pid=2, OS id=5108

PSP0 started with pid=3, OS id=3884

MMAN started with pid=4, OS id=3212

DBW0 started with pid=5, OS id=4508

LGWR started with pid=6, OS id=4124

CKPT started with pid=7, OS id=3684

SMON started with pid=8, OS id=3284

RECO started with pid=9, OS id=4360

CJQ0 started with pid=10, OS id=2128

MMON started with pid=11, OS id=3976

Mon Jan 10 15:21:43 2011

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=12, OS id=3444

Mon Jan 10 15:21:43 2011

starting up 1 shared server(s) ...

DMON started with pid=15, OS id=4136

Mon Jan 10 15:21:43 2011

ALTER DATABASE MOUNT

Mon Jan 10 15:21:48 2011

Setting recovery target incarnation to 4

Mon Jan 10 15:21:48 2011

Successful mount of redo thread 1, with mount id 1881221383

Mon Jan 10 15:21:48 2011

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Mon Jan 10 15:21:48 2011

ALTER DATABASE OPEN

Mon Jan 10 15:21:51 2011

Starting Data Guard Broker (DMON)

INSV started with pid=16, OS id=4264

Mon Jan 10 15:21:55 2011

LGWR: STARTING ARCH PROCESSES

ARC0 started with pid=18, OS id=4768

Mon Jan 10 15:21:55 2011

ARC0: Archival started

Mon Jan 10 15:21:55 2011

ARC1: Archival started

ARC1 started with pid=19, OS id=5288

LGWR: STARTING ARCH PROCESSES COMPLETE

Thread 1 opened at log sequence 11

Current log# 3 seq# 11 mem# 0: E:\ORACLE\TST\ORIGLOGA\LOG_G13M1.DBF

Current log# 3 seq# 11 mem# 1: E:\ORACLE\TST\MIRRLOGA\LOG_G13M2.DBF

Successful open of redo thread 1

Mon Jan 10 15:21:57 2011

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Mon Jan 10 15:21:57 2011

SMON: enabling cache recovery

Mon Jan 10 15:21:57 2011

ARC0: Becoming the 'no FAL' ARCH

ARC0: Becoming the 'no SRL' ARCH

Mon Jan 10 15:21:57 2011

ARC1: Becoming the heartbeat ARCH

Mon Jan 10 15:21:58 2011

Incremental checkpoint up to RBA [0xb.16b77.0], current log tail at RBA [0xb.16b77.0]

Mon Jan 10 15:21:59 2011

Successfully onlined Undo Tablespace 1.

Mon Jan 10 15:21:59 2011

SMON: enabling tx recovery

Mon Jan 10 15:21:59 2011

Database Characterset is UTF8

Opening with internal Resource Manager plan

where NUMA PG = 1, CPUs = 2

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=20, OS id=4156

Mon Jan 10 15:22:05 2011

Completed: ALTER DATABASE OPEN

Mon Jan 10 15:52:02 2011

Incremental checkpoint up to RBA [0xb.180ee.0], current log tail at RBA [0xb.1830a.0]

Mon Jan 10 15:52:16 2011

Shutting down instance: further logons disabled

Mon Jan 10 15:52:16 2011

Stopping background process CJQ0

Mon Jan 10 15:52:16 2011

Stopping background process QMNC

Mon Jan 10 15:52:17 2011

Background process QMNC not dead after 150 seconds

Mon Jan 10 15:52:17 2011

Stopping background process MMNL

Mon Jan 10 15:52:18 2011

Background process MMNL not dead after 10 seconds

Mon Jan 10 15:52:18 2011

Stopping background process MMON

Mon Jan 10 15:52:19 2011

Background process MMON not dead after 30 seconds

Mon Jan 10 15:52:19 2011

Shutting down instance (immediate)

License high water mark = 12

Mon Jan 10 15:52:19 2011

Stopping Job queue slave processes, flags = 7

Mon Jan 10 15:52:19 2011

Job queue slave processes stopped

Waiting for dispatcher 'D000' to shutdown

All dispatchers and shared servers shutdown

Mon Jan 10 15:52:24 2011

ALTER DATABASE CLOSE NORMAL

Mon Jan 10 15:52:24 2011

SMON: disabling tx recovery

SMON: disabling cache recovery

Mon Jan 10 15:52:25 2011

Shutting down archive processes

Archiving is disabled

Mon Jan 10 15:52:30 2011

ARCH shutting down

ARC1: Archival stopped

Mon Jan 10 15:52:35 2011

ARCH shutting down

ARC0: Archival stopped

Mon Jan 10 15:52:36 2011

Thread 1 closed at log sequence 11

Successful close of redo thread 1

Mon Jan 10 15:52:37 2011

Completed: ALTER DATABASE CLOSE NORMAL

Mon Jan 10 15:52:37 2011

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Shutting down Data Guard Broker processes

Mon Jan 10 15:52:38 2011

Completed: Data Guard Broker shutdown

Mon Jan 10 15:52:40 2011

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Mon Jan 10 15:53:28 2011

Starting ORACLE instance (normal)

Mon Jan 10 15:53:28 2011

Specified value of sga_max_size is too small, bumping to 645922816

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

IMODE=BR

ILAT =10

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.4.0.

System parameters with non-default values:

processes = 80

sessions = 96

event = 10191 trace name context forever, level 1

sga_max_size = 645922816

__shared_pool_size = 318767104

shared_pool_size = 318767104

__java_pool_size = 4194304

java_pool_size = 4194304

shared_pool_reserved_size= 31598837

filesystemio_options = setall

control_files = E:\ORACLE\TST\ORIGLOGA\CNTRL\CNTLRTST.DBF, E:\ORACLE\TST\ORIGLOGB\CNTRL\CNTRLTST.DBF, F:\ORACLE\TST\SAPDATA1\CNTRL\CNTRLTST.DBF

control_file_record_keep_time= 30

db_block_size = 8192

__db_cache_size = 318767104

db_cache_size = 318767104

compatible = 10.2.0

log_archive_dest = E:\oracle\TST\oraarch\TSTarch

log_buffer = 2061312

log_checkpoint_interval = 0

db_files = 254

log_checkpoints_to_alert = TRUE

dml_locks = 4000

undo_management = AUTO

undo_tablespace = PSAPUNDO

undo_retention = 43200

recyclebin = off

remote_os_authent = TRUE

remote_login_passwordfile= EXCLUSIVE

dispatchers = (PROTOCOL=TCP) (SERVICE=TSTXDB)

job_queue_processes = 1

background_dump_dest = F:\ORACLE\TST\SAPTRACE\BACKGROUND

user_dump_dest = F:\ORACLE\TST\SAPTRACE\USERTRACE

core_dump_dest = F:\ORACLE\TST\SAPTRACE\BACKGROUND

optimizer_features_enable= 10.2.0.1

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = TST

open_cursors = 800

optimpeek_user_binds = FALSE

pga_aggregate_target = 421317836

workarea_size_policy = AUTO

statistics_level = typical

dg_broker_start = TRUE

PMON started with pid=2, OS id=5296

PSP0 started with pid=3, OS id=4804

MMAN started with pid=4, OS id=3480

DBW0 started with pid=5, OS id=4312

LGWR started with pid=6, OS id=4036

CKPT started with pid=7, OS id=3372

SMON started with pid=8, OS id=5816

RECO started with pid=9, OS id=5240

CJQ0 started with pid=10, OS id=4524

MMON started with pid=11, OS id=6140

Mon Jan 10 15:53:28 2011

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=12, OS id=5680

Mon Jan 10 15:53:28 2011

starting up 1 shared server(s) ...

DMON started with pid=15, OS id=5308

Mon Jan 10 15:53:28 2011

ALTER DATABASE MOUNT

Mon Jan 10 15:53:32 2011

Setting recovery target incarnation to 4

Mon Jan 10 15:53:33 2011

Successful mount of redo thread 1, with mount id 1881229688

Mon Jan 10 15:53:33 2011

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Mon Jan 10 15:53:33 2011

ALTER DATABASE OPEN

Mon Jan 10 15:53:36 2011

Starting Data Guard Broker (DMON)

INSV started with pid=16, OS id=4536

Mon Jan 10 15:53:40 2011

LGWR: STARTING ARCH PROCESSES

ARC0 started with pid=18, OS id=5552

Mon Jan 10 15:53:40 2011

ARC0: Archival started

ARC1: Archival started

ARC1 started with pid=19, OS id=5312

LGWR: STARTING ARCH PROCESSES COMPLETE

Thread 1 opened at log sequence 11

Current log# 3 seq# 11 mem# 0: E:\ORACLE\TST\ORIGLOGA\LOG_G13M1.DBF

Current log# 3 seq# 11 mem# 1: E:\ORACLE\TST\MIRRLOGA\LOG_G13M2.DBF

Successful open of redo thread 1

Mon Jan 10 15:53:41 2011

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Mon Jan 10 15:53:41 2011

SMON: enabling cache recovery

Mon Jan 10 15:53:42 2011

ARC1: Becoming the 'no FAL' ARCH

ARC1: Becoming the 'no SRL' ARCH

Mon Jan 10 15:53:42 2011

ARC0: Becoming the heartbeat ARCH

Mon Jan 10 15:53:43 2011

Incremental checkpoint up to RBA [0xb.18403.0], current log tail at RBA [0xb.18403.0]

Mon Jan 10 15:53:44 2011

Successfully onlined Undo Tablespace 1.

Mon Jan 10 15:53:44 2011

SMON: enabling tx recovery

Mon Jan 10 15:53:44 2011

Database Characterset is UTF8

Opening with internal Resource Manager plan

where NUMA PG = 1, CPUs = 2

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=20, OS id=5776

Mon Jan 10 15:53:50 2011

Completed: ALTER DATABASE OPEN

Mon Jan 10 15:55:46 2011

Starting ORACLE instance (normal)

Mon Jan 10 16:00:56 2011

Errors in file f:\oracle\tst\saptrace\background\tst_j000_3228.trc:

Mon Jan 10 16:01:26 2011

Beginning log switch checkpoint up to RBA [0xc.2.10], SCN: 16865686

Mon Jan 10 16:01:26 2011

Thread 1 advanced to log sequence 12 (LGWR switch)

Current log# 4 seq# 12 mem# 0: E:\ORACLE\TST\ORIGLOGB\LOG_G14M1.DBF

Current log# 4 seq# 12 mem# 1: E:\ORACLE\TST\MIRRLOGB\LOG_G14M2.DBF

Mon Jan 10 16:03:54 2011

Errors in file f:\oracle\tst\saptrace\background\tst_m000_5396.trc:

ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], []

Mon Jan 10 16:04:01 2011

Errors in file f:\oracle\tst\saptrace\background\tst_m000_5396.trc:

ORA-00600: internal error code, arguments: [kcbgcur_3], [61846], [9], [4], [0], [], [], []

Mon Jan 10 16:04:07 2011

Errors in file f:\oracle\tst\saptrace\background\tst_m000_5396.trc:

ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], []

Mon Jan 10 16:06:30 2011

Completed checkpoint up to RBA [0xc.2.10], SCN: 16865686

Mon Jan 10 16:23:50 2011

Incremental checkpoint up to RBA [0xc.4e3a.0], current log tail at RBA [0xc.4f1f.0]

Mon Jan 10 16:53:57 2011

Incremental checkpoint up to RBA [0xc.55b9.0], current log tail at RBA [0xc.5726.0]

Mon Jan 10 17:00:01 2011

Errors in file f:\oracle\tst\saptrace\background\tst_j000_2516.trc:

Mon Jan 10 17:00:29 2011

Errors in file f:\oracle\tst\saptrace\background\tst_m000_6048.trc:

ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], []

Mon Jan 10 17:00:33 2011

Errors in file f:\oracle\tst\saptrace\background\tst_m000_6048.trc:

ORA-00600: internal error code, arguments: [kcbgcur_3], [61846], [9], [4], [0], [], [], []

Mon Jan 10 17:00:37 2011

Errors in file f:\oracle\tst\saptrace\background\tst_m000_6048.trc:

ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], []

Mon Jan 10 17:24:02 2011

Incremental checkpoint up to RBA [0xc.6125.0], current log tail at RBA [0xc.62ae.0]

Former Member
0 Kudos

The Date (January 1) when i recovered the DB:

================================

Sat Jan 01 09:37:32 2011

starting up 1 shared server(s) ...

DMON started with pid=16, OS id=4160

Sat Jan 01 09:37:33 2011

ALTER DATABASE MOUNT

Sat Jan 01 09:37:37 2011

Setting recovery target incarnation to 2

Sat Jan 01 09:37:37 2011

Successful mount of redo thread 1, with mount id 1880424413

Sat Jan 01 09:37:37 2011

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Sat Jan 01 09:37:37 2011

ALTER DATABASE OPEN

Sat Jan 01 09:37:40 2011

Starting Data Guard Broker (DMON)

INSV started with pid=15, OS id=3272

Sat Jan 01 09:37:45 2011

ORA-1122 signalled during: ALTER DATABASE OPEN...

Sat Jan 01 09:38:03 2011

Starting ORACLE instance (normal)

Sat Jan 01 10:29:54 2011

Shutting down instance: further logons disabled

Sat Jan 01 10:29:54 2011

Stopping background process CJQ0

Sat Jan 01 10:29:54 2011

Stopping background process MMNL

Sat Jan 01 10:29:56 2011

Background process MMNL not dead after 10 seconds

Sat Jan 01 10:29:56 2011

Stopping background process MMON

Sat Jan 01 10:29:57 2011

Background process MMON not dead after 30 seconds

Sat Jan 01 10:29:57 2011

Shutting down instance (immediate)

License high water mark = 2

Sat Jan 01 10:29:57 2011

Stopping Job queue slave processes, flags = 7

Sat Jan 01 10:29:57 2011

Job queue slave processes stopped

Waiting for dispatcher 'D000' to shutdown

All dispatchers and shared servers shutdown

Sat Jan 01 10:29:59 2011

ALTER DATABASE CLOSE NORMAL

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

Sat Jan 01 10:29:59 2011

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Shutting down Data Guard Broker processes

Sat Jan 01 10:30:01 2011

Completed: Data Guard Broker shutdown

Sat Jan 01 10:30:03 2011

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Sat Jan 01 10:33:04 2011

Starting ORACLE instance (normal)

Sat Jan 01 10:33:04 2011

Specified value of sga_max_size is too small, bumping to 645922816

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

IMODE=BR

ILAT =10

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.4.0.

System parameters with non-default values:

processes = 80

sessions = 96

event = 10191 trace name context forever, level 1

sga_max_size = 645922816

shared_pool_size = 318767104

__java_pool_size = 4194304

java_pool_size = 4194304

shared_pool_reserved_size= 31598837

filesystemio_options = setall

control_files = E:\ORACLE\TST\ORIGLOGA\CNTRL\CNTLRTST.DBF, E:\ORACLE\TST\ORIGLOGB\CNTRL\CNTRLTST.DBF, F:\ORACLE\TST\SAPDATA1\CNTRL\CNTRLTST.DBF

control_file_record_keep_time= 30

db_block_size = 8192

db_cache_size = 318767104

compatible = 10.2.0

log_archive_dest = E:\oracle\TST\oraarch\TSTarch

log_buffer = 2061312

log_checkpoint_interval = 0

db_files = 254

log_checkpoints_to_alert = TRUE

dml_locks = 4000

undo_management = AUTO

undo_tablespace = PSAPUNDO

undo_retention = 43200

recyclebin = off

remote_os_authent = TRUE

remote_login_passwordfile= EXCLUSIVE

dispatchers = (PROTOCOL=TCP) (SERVICE=TSTXDB)

job_queue_processes = 1

background_dump_dest = F:\ORACLE\TST\SAPTRACE\BACKGROUND

user_dump_dest = F:\ORACLE\TST\SAPTRACE\USERTRACE

core_dump_dest = F:\ORACLE\TST\SAPTRACE\BACKGROUND

optimizer_features_enable= 10.2.0.1

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = TST

open_cursors = 800

optimpeek_user_binds = FALSE

pga_aggregate_target = 421317836

workarea_size_policy = AUTO

statistics_level = typical

dg_broker_start = TRUE

PMON started with pid=2, OS id=5464

PSP0 started with pid=3, OS id=2176

MMAN started with pid=4, OS id=5396

DBW0 started with pid=5, OS id=5624

LGWR started with pid=6, OS id=6028

CKPT started with pid=7, OS id=3724

SMON started with pid=8, OS id=3952

RECO started with pid=9, OS id=3336

CJQ0 started with pid=10, OS id=2260

MMON started with pid=11, OS id=1060

Sat Jan 01 10:33:04 2011

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=12, OS id=5316

Sat Jan 01 10:33:04 2011

starting up 1 shared server(s) ...

DMON started with pid=15, OS id=4688

Sat Jan 01 10:33:37 2011

ALTER DATABASE RECOVER using backup controlfile

Sat Jan 01 10:33:37 2011

ORA-1507 signalled during: ALTER DATABASE RECOVER using backup controlfile ...

Shutting down instance: further logons disabled

Sat Jan 01 10:33:47 2011

Stopping background process CJQ0

Sat Jan 01 10:33:47 2011

Stopping background process MMNL

Sat Jan 01 10:33:48 2011

Background process MMNL not dead after 10 seconds

Sat Jan 01 10:33:48 2011

Stopping background process MMON

Sat Jan 01 10:33:49 2011

Background process MMON not dead after 30 seconds

Sat Jan 01 10:33:49 2011

Shutting down instance (normal)

License high water mark = 2

Sat Jan 01 10:33:49 2011

Stopping Job queue slave processes, flags = 2

Sat Jan 01 10:33:49 2011

Job queue slave processes stopped

Waiting for dispatcher 'D000' to shutdown

All dispatchers and shared servers shutdown

Sat Jan 01 10:33:51 2011

ALTER DATABASE CLOSE NORMAL

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

ARCH: Archival disabled due to shutdown: 1090

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Shutting down Data Guard Broker processes

ARCH: Archival disabled due to shutdown: 1090

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Sat Jan 01 10:34:00 2011

Starting ORACLE instance (normal)

Sat Jan 01 10:34:00 2011

Specified value of sga_max_size is too small, bumping to 645922816

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

IMODE=BR

ILAT =10

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.4.0.

System parameters with non-default values:

processes = 80

sessions = 96

event = 10191 trace name context forever, level 1

sga_max_size = 645922816

shared_pool_size = 318767104

__java_pool_size = 4194304

java_pool_size = 4194304

shared_pool_reserved_size= 31598837

filesystemio_options = setall

control_files = E:\ORACLE\TST\ORIGLOGA\CNTRL\CNTLRTST.DBF, E:\ORACLE\TST\ORIGLOGB\CNTRL\CNTRLTST.DBF, F:\ORACLE\TST\SAPDATA1\CNTRL\CNTRLTST.DBF

control_file_record_keep_time= 30

db_block_size = 8192

db_cache_size = 318767104

compatible = 10.2.0

log_archive_dest = E:\oracle\TST\oraarch\TSTarch

log_buffer = 2061312

log_checkpoint_interval = 0

db_files = 254

log_checkpoints_to_alert = TRUE

dml_locks = 4000

undo_management = AUTO

undo_tablespace = PSAPUNDO

undo_retention = 43200

recyclebin = off

remote_os_authent = TRUE

remote_login_passwordfile= EXCLUSIVE

dispatchers = (PROTOCOL=TCP) (SERVICE=TSTXDB)

job_queue_processes = 1

background_dump_dest = F:\ORACLE\TST\SAPTRACE\BACKGROUND

user_dump_dest = F:\ORACLE\TST\SAPTRACE\USERTRACE

core_dump_dest = F:\ORACLE\TST\SAPTRACE\BACKGROUND

optimizer_features_enable= 10.2.0.1

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = TST

open_cursors = 800

optimpeek_user_binds = FALSE

pga_aggregate_target = 421317836

workarea_size_policy = AUTO

statistics_level = typical

dg_broker_start = TRUE

PMON started with pid=2, OS id=5740

PSP0 started with pid=3, OS id=3004

MMAN started with pid=4, OS id=3008

DBW0 started with pid=5, OS id=5480

LGWR started with pid=6, OS id=5104

CKPT started with pid=7, OS id=5840

SMON started with pid=8, OS id=5844

RECO started with pid=9, OS id=5848

CJQ0 started with pid=10, OS id=5852

MMON started with pid=11, OS id=2332

Sat Jan 01 10:34:00 2011

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=12, OS id=4496

Sat Jan 01 10:34:00 2011

starting up 1 shared server(s) ...

DMON started with pid=15, OS id=4544

Sat Jan 01 10:34:00 2011

ALTER DATABASE MOUNT

Sat Jan 01 10:34:05 2011

Setting recovery target incarnation to 2

Sat Jan 01 10:34:05 2011

Successful mount of redo thread 1, with mount id 1880465944

Sat Jan 01 10:34:05 2011

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Sat Jan 01 10:34:08 2011

Starting Data Guard Broker (DMON)

INSV started with pid=16, OS id=5564

Sat Jan 01 10:40:50 2011

Shutting down instance: further logons disabled

Sat Jan 01 10:40:50 2011

Stopping background process CJQ0

Sat Jan 01 10:40:50 2011

Stopping background process MMNL

Sat Jan 01 10:40:51 2011

Background process MMNL not dead after 10 seconds

Sat Jan 01 10:40:51 2011

Stopping background process MMON

Sat Jan 01 10:40:51 2011

Shutting down instance (immediate)

License high water mark = 2

Sat Jan 01 10:40:51 2011

Stopping Job queue slave processes, flags = 7

Sat Jan 01 10:40:51 2011

Job queue slave processes stopped

Waiting for dispatcher 'D000' to shutdown

All dispatchers and shared servers shutdown

Sat Jan 01 10:40:53 2011

ALTER DATABASE CLOSE NORMAL

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

Sat Jan 01 10:40:53 2011

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Shutting down Data Guard Broker processes

Sat Jan 01 10:40:54 2011

Completed: Data Guard Broker shutdown

Former Member
0 Kudos

I think this is when i got the db recovered:

Sat Jan 01 15:49:11 2011
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=18, OS id=1644
ARC1 started with pid=19, OS id=3904
Sat Jan 01 15:49:11 2011
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: E:\ORACLE\TST\ORIGLOGA\LOG_G11M1.DBF
  Current log# 1 seq# 1 mem# 1: E:\ORACLE\TST\MIRRLOGA\LOG_G11M2.DBF
Successful open of redo thread 1
Sat Jan 01 15:49:12 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Jan 01 15:49:12 2011
SMON: enabling cache recovery
Sat Jan 01 15:49:13 2011
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Sat Jan 01 15:49:13 2011
ARC1: Becoming the heartbeat ARCH
Sat Jan 01 15:49:14 2011
Incremental checkpoint up to RBA [0x1.374.0], current log tail at RBA [0x1.374.0]
Sat Jan 01 15:49:15 2011
Successfully onlined Undo Tablespace 1.
Sat Jan 01 15:49:15 2011
SMON: enabling tx recovery
Sat Jan 01 15:49:16 2011
Database Characterset is UTF8
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 2
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=20, OS id=2044
Sat Jan 01 15:49:25 2011
Completed: ALTER DATABASE OPEN
Sat Jan 01 15:49:37 2011
Errors in file f:\oracle\tst\saptrace\background\tst_mmon_3516.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

Sat Jan 01 15:50:34 2011
Restarting dead background process MMON
MMON started with pid=41, OS id=5080
Sat Jan 01 15:54:07 2011
Errors in file f:\oracle\tst\saptrace\background\tst_mmon_5080.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

Sat Jan 01 15:54:12 2011
ORA-600 encountered when generating server alert SMG-4120
Sat Jan 01 15:54:15 2011
Errors in file f:\oracle\tst\saptrace\background\tst_mmon_5080.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

ORA-600 encountered when generating server alert SMG-4121
Sat Jan 01 15:54:21 2011
Errors in file f:\oracle\tst\saptrace\background\tst_mmon_5080.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

Sat Jan 01 15:54:24 2011
ORA-600 encountered when generating server alert SMG-4121
Sat Jan 01 15:59:07 2011
Errors in file f:\oracle\tst\saptrace\background\tst_mmon_5080.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

Sat Jan 01 15:59:08 2011
ORA-600 encountered when generating server alert SMG-4120
Sat Jan 01 15:59:11 2011
Errors in file f:\oracle\tst\saptrace\background\tst_mmon_5080.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

ORA-600 encountered when generating server alert SMG-4121
Sat Jan 01 15:59:15 2011
Errors in file f:\oracle\tst\saptrace\background\tst_mmon_5080.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

ORA-600 encountered when generating server alert SMG-4121
Sat Jan 01 15:59:49 2011
Errors in file f:\oracle\tst\saptrace\background\tst_mmon_5080.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

Sat Jan 01 15:59:52 2011
Errors in file f:\oracle\tst\saptrace\background\tst_m000_5860.trc:
ORA-00600: internal error code, arguments: [6002], [6], [0], [4], [0], [], [], []

Sat Jan 01 16:00:31 2011
Beginning log switch checkpoint up to RBA [0x2.2.10], SCN: 16367263
Sat Jan 01 16:00:31 2011
Thread 1 advanced to log sequence 2 (LGWR switch)
  Current log# 2 seq# 2 mem# 0: E:\ORACLE\TST\ORIGLOGB\LOG_G12M1.DBF
  Current log# 2 seq# 2 mem# 1: E:\ORACLE\TST\MIRRLOGB\LOG_G12M2.DBF
Sat Jan 01 16:00:32 2011
Errors in file f:\oracle\tst\saptrace\background\tst_j000_2068.trc:

Sat Jan 01 16:00:51 2011
Errors in file f:\oracle\tst\saptrace\background\tst_mmon_5080.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

Sat Jan 01 16:00:52 2011
ORA-600 encountered when generating server alert SMG-3503
Sat Jan 01 16:04:10 2011
Errors in file f:\oracle\tst\saptrace\background\tst_mmon_5080.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

Former Member
0 Kudos

Here is DRCTST.LOG (in same folder, e.g: oracle\TST\saptrace\background) file's recent text:

===============================

DG 2011-01-07-10:24:29 0 2 0 Protection Mode: Maximum Performance

DG 2011-01-07-10:24:29 0 2 0 Fast-Start Failover (FSFO): Disabled

DG 2011-01-07-10:24:29 0 2 0 Primary Database: TST (01010000)

DG 2011-01-07-10:24:29 0 2 0 DMON: DRC Boot strap complete

DG 2011-01-07-10:24:29 0 2 0 DMON: Entered rfm_release_chief_lock for CTL_BOOTSTRAP

DG 2011-01-08-11:27:18 0 2 0 DMON: Data Guard Broker shutting down

DG 2011-01-08-11:27:18 0 2 0 DMON: Terminating RSM processes

DG 2011-01-08-11:27:18 0 2 0 DMON: Terminating NetSlave processes

DG 2011-01-08-11:27:18 0 2 0 DMON: Freeing all task elements.

DG 2011-01-08-11:27:18 0 2 0 DMON: Terminating Instance Slave process

DG 2011-01-08-11:27:18 0 2 0 INSV: Shutting down

DG 2011-01-08-11:27:19 0 2 0 DMON: INSV successfully terminated

DG 2011-01-08-11:27:19 0 2 0 DMON: Zeroing metadata root pointer

DG 2011-01-08-11:27:19 0 2 0 DMON: Clearing Primary State

DG 2011-01-08-11:27:19 0 2 0 DMON: Freeing Broker SGA heap

DG 2011-01-08-11:27:19 0 2 0 DMON: Freeing PGA heap

DG 2011-01-08-11:27:19 0 2 0 DMON: Removing DMON's state object

DG 2011-01-08-11:27:19 0 2 0 DMON: Resetting DMON context structure

DG 2011-01-08-11:27:19 0 2 0 DMON: >> DMON Process Shutdown <<

DG 2011-01-08-14:51:35 0 2 0 DMON: >> Starting Data Guard Broker bootstrap <<

DG 2011-01-08-14:51:35 0 2 0 DMON: Attach state object

DG 2011-01-08-14:51:35 0 2 0 DMON: chief lock convert for bootstrap

DG 2011-01-08-14:51:35 0 2 0 DMON Registering service TST_DGB with listener(s)

DG 2011-01-08-14:51:35 0 2 0 Executing SQL [ALTER SYSTEM REGISTER]

DG 2011-01-08-14:51:35 0 2 0 SQL [ALTER SYSTEM REGISTER] Executed successfully

DG 2011-01-08-14:51:35 0 2 0 DMON: Broker Configuration DR

DG 2011-01-08-14:51:35 0 2 0 Metadata Version: 2.5 / UID = 620068945 (0x24f58051) / SEQ = 0 / MIV = 2

DG 2011-01-08-14:51:35 0 2 0 Protection Mode: Maximum Performance

DG 2011-01-08-14:51:35 0 2 0 Fast-Start Failover (FSFO): Disabled

DG 2011-01-08-14:51:35 0 2 0 Primary Database: TST (01010000)

DG 2011-01-08-14:51:35 0 2 0 DMON: DRC Boot strap complete

DG 2011-01-08-14:51:35 0 2 0 DMON: Entered rfm_release_chief_lock for CTL_BOOTSTRAP

DG 2011-01-08-14:54:39 0 2 739896879 DMON: MON_PROPERTY operation completed

DG 2011-01-08-15:16:51 0 2 0 DMON: Data Guard Broker shutting down

DG 2011-01-08-15:16:51 0 2 0 DMON: Terminating RSM processes

DG 2011-01-08-15:16:51 0 2 0 DMON: Terminating NetSlave processes

DG 2011-01-08-15:16:51 0 2 0 DMON: Freeing all task elements.

DG 2011-01-08-15:16:51 0 2 0 DMON: Terminating Instance Slave process

DG 2011-01-08-15:16:51 0 2 0 INSV: Shutting down

DG 2011-01-08-15:16:52 0 2 0 DMON: INSV successfully terminated

DG 2011-01-08-15:16:52 0 2 0 DMON: Zeroing metadata root pointer

DG 2011-01-08-15:16:52 0 2 0 DMON: Clearing Primary State

DG 2011-01-08-15:16:52 0 2 0 DMON: Freeing Broker SGA heap

DG 2011-01-08-15:16:52 0 2 0 DMON: Freeing PGA heap

DG 2011-01-08-15:16:52 0 2 0 DMON: Removing DMON's state object

DG 2011-01-08-15:16:52 0 2 0 DMON: Resetting DMON context structure

DG 2011-01-08-15:16:52 0 2 0 DMON: >> DMON Process Shutdown <<

DG 2011-01-08-15:23:17 0 2 0 DMON: >> Starting Data Guard Broker bootstrap <<

DG 2011-01-08-15:23:17 0 2 0 DMON: Attach state object

DG 2011-01-08-15:23:17 0 2 0 DMON: chief lock convert for bootstrap

DG 2011-01-08-15:23:17 0 2 0 DMON Registering service TST_DGB with listener(s)

DG 2011-01-08-15:23:17 0 2 0 Executing SQL [ALTER SYSTEM REGISTER]

DG 2011-01-08-15:23:17 0 2 0 SQL [ALTER SYSTEM REGISTER] Executed successfully

DG 2011-01-08-15:23:17 0 2 0 DMON: Broker Configuration DR

DG 2011-01-08-15:23:17 0 2 0 Metadata Version: 2.5 / UID = 620068945 (0x24f58051) / SEQ = 0 / MIV = 2

DG 2011-01-08-15:23:17 0 2 0 Protection Mode: Maximum Performance

DG 2011-01-08-15:23:17 0 2 0 Fast-Start Failover (FSFO): Disabled

DG 2011-01-08-15:23:17 0 2 0 Primary Database: TST (01010000)

DG 2011-01-08-15:23:17 0 2 0 DMON: DRC Boot strap complete

DG 2011-01-08-15:23:17 0 2 0 DMON: Entered rfm_release_chief_lock for CTL_BOOTSTRAP

DG 2011-01-08-15:24:39 0 2 739898679 DMON: MON_PROPERTY operation completed

DG 2011-01-08-15:49:52 0 2 0 DMON: Data Guard Broker shutting down

DG 2011-01-08-15:49:52 0 2 0 DMON: Terminating RSM processes

DG 2011-01-08-15:49:52 0 2 0 DMON: Terminating NetSlave processes

DG 2011-01-08-15:49:52 0 2 0 DMON: Freeing all task elements.

DG 2011-01-08-15:49:52 0 2 0 DMON: Terminating Instance Slave process

DG 2011-01-08-15:49:52 0 2 0 INSV: Shutting down

DG 2011-01-08-15:49:53 0 2 0 DMON: INSV successfully terminated

DG 2011-01-08-15:49:53 0 2 0 DMON: Zeroing metadata root pointer

DG 2011-01-08-15:49:53 0 2 0 DMON: Clearing Primary State

DG 2011-01-08-15:49:53 0 2 0 DMON: Freeing Broker SGA heap

DG 2011-01-08-15:49:53 0 2 0 DMON: Freeing PGA heap

DG 2011-01-08-15:49:53 0 2 0 DMON: Removing DMON's state object

DG 2011-01-08-15:49:53 0 2 0 DMON: Resetting DMON context structure

DG 2011-01-08-15:49:53 0 2 0 DMON: >> DMON Process Shutdown <<

DG 2011-01-10-11:20:23 0 2 0 DMON: >> Starting Data Guard Broker bootstrap <<

DG 2011-01-10-11:20:23 0 2 0 DMON: Attach state object

DG 2011-01-10-11:20:23 0 2 0 DMON: chief lock convert for bootstrap

DG 2011-01-10-11:20:23 0 2 0 DMON Registering service TST_DGB with listener(s)

DG 2011-01-10-11:20:23 0 2 0 Executing SQL [ALTER SYSTEM REGISTER]

DG 2011-01-10-11:20:23 0 2 0 SQL [ALTER SYSTEM REGISTER] Executed successfully

DG 2011-01-10-11:20:23 0 2 0 DMON: Broker Configuration DR

DG 2011-01-10-11:20:23 0 2 0 Metadata Version: 2.5 / UID = 620068945 (0x24f58051) / SEQ = 0 / MIV = 2

DG 2011-01-10-11:20:23 0 2 0 Protection Mode: Maximum Performance

DG 2011-01-10-11:20:23 0 2 0 Fast-Start Failover (FSFO): Disabled

DG 2011-01-10-11:20:23 0 2 0 Primary Database: TST (01010000)

DG 2011-01-10-11:20:23 0 2 0 DMON: DRC Boot strap complete

DG 2011-01-10-11:20:23 0 2 0 DMON: Entered rfm_release_chief_lock for CTL_BOOTSTRAP

DG 2011-01-10-15:19:59 0 2 0 DMON: Data Guard Broker shutting down

DG 2011-01-10-15:19:59 0 2 0 DMON: Terminating RSM processes

DG 2011-01-10-15:19:59 0 2 0 DMON: Terminating NetSlave processes

DG 2011-01-10-15:19:59 0 2 0 DMON: Freeing all task elements.

DG 2011-01-10-15:19:59 0 2 0 DMON: Terminating Instance Slave process

DG 2011-01-10-15:19:59 0 2 0 INSV: Shutting down

DG 2011-01-10-15:20:00 0 2 0 DMON: INSV successfully terminated

DG 2011-01-10-15:20:00 0 2 0 DMON: Zeroing metadata root pointer

DG 2011-01-10-15:20:00 0 2 0 DMON: Clearing Primary State

DG 2011-01-10-15:20:00 0 2 0 DMON: Freeing Broker SGA heap

DG 2011-01-10-15:20:00 0 2 0 DMON: Freeing PGA heap

DG 2011-01-10-15:20:00 0 2 0 DMON: Removing DMON's state object

DG 2011-01-10-15:20:00 0 2 0 DMON: Resetting DMON context structure

DG 2011-01-10-15:20:00 0 2 0 DMON: >> DMON Process Shutdown <<

DG 2011-01-10-15:21:51 0 2 0 DMON: >> Starting Data Guard Broker bootstrap <<

DG 2011-01-10-15:21:51 0 2 0 DMON: Attach state object

DG 2011-01-10-15:21:51 0 2 0 DMON: chief lock convert for bootstrap

DG 2011-01-10-15:21:51 0 2 0 DMON Registering service TST_DGB with listener(s)

DG 2011-01-10-15:21:51 0 2 0 Executing SQL [ALTER SYSTEM REGISTER]

DG 2011-01-10-15:21:51 0 2 0 SQL [ALTER SYSTEM REGISTER] Executed successfully

DG 2011-01-10-15:21:51 0 2 0 DMON: Broker Configuration DR

DG 2011-01-10-15:21:51 0 2 0 Metadata Version: 2.5 / UID = 620068945 (0x24f58051) / SEQ = 0 / MIV = 2

DG 2011-01-10-15:21:51 0 2 0 Protection Mode: Maximum Performance

DG 2011-01-10-15:21:51 0 2 0 Fast-Start Failover (FSFO): Disabled

DG 2011-01-10-15:21:51 0 2 0 Primary Database: TST (01010000)

DG 2011-01-10-15:21:51 0 2 0 DMON: DRC Boot strap complete

DG 2011-01-10-15:21:51 0 2 0 DMON: Entered rfm_release_chief_lock for CTL_BOOTSTRAP

DG 2011-01-10-15:52:37 0 2 0 DMON: Data Guard Broker shutting down

DG 2011-01-10-15:52:37 0 2 0 DMON: Terminating RSM processes

DG 2011-01-10-15:52:37 0 2 0 DMON: Terminating NetSlave processes

DG 2011-01-10-15:52:37 0 2 0 DMON: Freeing all task elements.

DG 2011-01-10-15:52:37 0 2 0 DMON: Terminating Instance Slave process

DG 2011-01-10-15:52:37 0 2 0 INSV: Shutting down

DG 2011-01-10-15:52:38 0 2 0 DMON: INSV successfully terminated

DG 2011-01-10-15:52:38 0 2 0 DMON: Zeroing metadata root pointer

DG 2011-01-10-15:52:38 0 2 0 DMON: Clearing Primary State

DG 2011-01-10-15:52:38 0 2 0 DMON: Freeing Broker SGA heap

DG 2011-01-10-15:52:38 0 2 0 DMON: Freeing PGA heap

DG 2011-01-10-15:52:38 0 2 0 DMON: Removing DMON's state object

DG 2011-01-10-15:52:38 0 2 0 DMON: Resetting DMON context structure

DG 2011-01-10-15:52:38 0 2 0 DMON: >> DMON Process Shutdown <<

DG 2011-01-10-15:53:36 0 2 0 DMON: >> Starting Data Guard Broker bootstrap <<

DG 2011-01-10-15:53:36 0 2 0 DMON: Attach state object

DG 2011-01-10-15:53:36 0 2 0 DMON: chief lock convert for bootstrap

DG 2011-01-10-15:53:36 0 2 0 DMON Registering service TST_DGB with listener(s)

DG 2011-01-10-15:53:36 0 2 0 Executing SQL [ALTER SYSTEM REGISTER]

DG 2011-01-10-15:53:36 0 2 0 SQL [ALTER SYSTEM REGISTER] Executed successfully

DG 2011-01-10-15:53:36 0 2 0 DMON: Broker Configuration DR

DG 2011-01-10-15:53:36 0 2 0 Metadata Version: 2.5 / UID = 620068945 (0x24f58051) / SEQ = 0 / MIV = 2

DG 2011-01-10-15:53:36 0 2 0 Protection Mode: Maximum Performance

DG 2011-01-10-15:53:36 0 2 0 Fast-Start Failover (FSFO): Disabled

DG 2011-01-10-15:53:36 0 2 0 Primary Database: TST (01010000)

DG 2011-01-10-15:53:36 0 2 0 DMON: DRC Boot strap complete

DG 2011-01-10-15:53:36 0 2 0 DMON: Entered rfm_release_chief_lock for CTL_BOOTSTRAP

=================

I dont know much about Oracle Administration.

Thanks in Advance,

Regards.

nirmal_konchada
Active Contributor
0 Kudos

Hi,

Run DBcheck from DB13 and revert with the log.

Nirmal.K

Former Member
0 Kudos

Hi Nirmal,

Below is the DB13 DB Check log:

Job log
Job started
Step 001 started (program RSDBAJOB, variant &0000000000052, user ID ZARSHAD)
Execute logical command BRCONNECT On host netwvr
Parameters: -u / -jid CHECK20110111111421 -c -f check
BR0801I BRCONNECT 7.00 (24)
BR0477I Oracle pfile E:\oracle\TST\102\database\initTST.ora created from spfile E:\oracle\TST\102\database\spfileTST.ora
BR0805I Start of BRCONNECT processing: ceezglvx.chk 2011-01-11 11.14.29
BR0484I BRCONNECT log file: F:\oracle\TST\sapcheck\ceezglvx.chk
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.41
BR0813I Schema owners found in database TST:
ANONYMOUS, DBSNMP, DIP, EXFSYS, MDSYS, MGMT_VIEW,OPS$NETWVR\SAPSERVICETST, OPS$NETWVR\TSTADM, ORACLE_OCM, ORDPLUGINS,
ORDSYS, OUTLN, SAPSR3*, SI_INFORMTN_SCHEMA, SYS, SYSMAN, SYSTEM, TSMSYS, TSTADM, XDB
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.44
BR0814I Number of tables in schema of owner SAPSR3: 16565
BR0836I Number of info cube tables found for owner SAPSR3: 93
BR0814I Number of tables/partitions in schema of owner SYS: 632/174
BR0814I Number of tables/partitions in schema of owner SYSTEM: 134/27
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.46
BR0815I Number of indexes in schema of owner SAPSR3: 21184
BR0815I Number of indexes/partitions in schema ofowner SYS: 682/185
BR0815I Number of indexes/partitions in schema ofowner SYSTEM: 175/32
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.52
BR0816I Number of segments in schema of owner DBSNMP: 25
BR0816I Number of segments in schema of owner EXFSYS: 28
BR0816I Number of segments in schema of owner MDSYS: 102
BR0816I Number of segments in schema of owner OPS$NETWVR\TSTADM: 1
BR0816I Number of segments in schema of owner ORDSYS: 8
BR0816I Number of segments in schema of owner OUTLN: 9
BR0816I Number of segments/LOBs in schema of owner SAPSR3: 40213/1232
BR0816I Number of segments/LOBs in schema of owner SYS: 1792/87
BR0816I Number of segments in schema of owner SYSMAN: 765
BR0816I Number of segments/LOBs in schema of owner SYSTEM: 353/22
BR0816I Number of segments in schema of owner TSMSYS: 4
BR0816I Number of segments in schema of owner XDB: 753
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.52
BR0961I Number of conditions found in DBCHECKORA:117
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.52
BR0818I Number of tables found in DBDIFF for owner SAPSR3: 2
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.53
BR0818I Number of tables found in DBSTATC for owner SAPSR3: 100
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.53
BR0807I Name of database instance: TST
BR0808I BRCONNECT action ID: ceezglvx
BR0809I BRCONNECT function ID: chk

BR0810I BRCONNECT function: check
BR0951I Number of active/inactive check conditions for database administration: 23/0
BR0952I Number of active/inactive check conditions for database operations: 8/2
BR0953I Number of active/inactive check conditions for database messages: 58/0
BR0954I Number of active/inactive check conditions for database profile: 26/0
BR0960I Last successful BRCONNECT check run: ceezcmhz.chk 2011-01-10 15.47.59
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.53
BR0969I Checking database administration...
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPSR3.GENSETC
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPSR3.SERVTYPE
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPSR3.GENSETC~0
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPSR3.SERVTYPE~0
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.53
BR0972I Checking database operations...
BR0973W Database operation alert - level: WARNING, operation: ceevcasy.sta, time: 2010-12-20 09.52.28, condition: Last successfu
BR0973W Database operation alert - level: WARNING, operation: beetgeck.and, time: 2010-12-10 16.09.34, condition: Last successfu
BR0973W Database operation alert - level: WARNING, operation: aeesmccu.sve, time: 2010-12-06 14.08.32, condition: Last successfu
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.53

Former Member
0 Kudos

Continued DBCheck log:

BR0974I Checking database messages in F:\ORACLE\TST\SAPTRACE\BACKGROUND\alert_tst.log ...
BR0976W Database message alert - level: ERROR, line: 90470, time: 2011-01-10 16.03.54, message:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], []
BR0976W Database message alert - level: ERROR, line: 90474, time: 2011-01-10 16.04.01, message:
ORA-00600: internal error code, arguments: [kcbgcur_3], [61846], [9], [4], [0], [], [], []
BR0976W Database message alert - level: ERROR, line: 90478, time: 2011-01-10 16.04.07, message:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], []
BR0976W Database message alert - level: ERROR, line: 90491, time: 2011-01-10 17.00.29, message:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], []
BR0976W Database message alert - level: ERROR, line: 90495, time: 2011-01-10 17.00.33, message:
ORA-00600: internal error code, arguments: [kcbgcur_3], [61846], [9], [4], [0], [], [], []
BR0976W Database message alert - level: ERROR, line: 90499, time: 2011-01-10 17.00.37, message:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], []
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.53
BR0977I Checking database profile...
BR0978W Database profile alert - level: WARNING, parameter: DB_BLOCK_CHECKSUM, value: TRUE (<> FALSE)
BR0978W Database profile alert - level: WARNING, parameter: PARALLEL_EXECUTION_MESSAGE_SIZE, value:2152 (>< 16384,4096)
BR0978W Database profile alert - level: ERROR, parameter: REPLICATION_DEPENDENCY_TRACKING, value: TRUE (<> FALSE)
BR0978W Database profile alert - level: WARNING, parameter: SHARED_POOL_SIZE, value: 318767104 (< 400 MB)
BR0978W Database profile alert - level: WARNING, parameter: STAR_TRANSFORMATION_ENABLED, value: FALSE (<> TRUE)
BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVEL, value: TYPICAL (set in parameter file)
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.53
BR0980I Number of changed database profile parameters: 0
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.54
BR0955I Number of signaled error/warning/exception alerts for database administration: 4/0/0
BR0956I Number of signaled error/warning/exception alerts for database operations: 0/3/0
BR0957I Number of signaled error/warning/exception alerts for database messages: 6/0/0
BR0958I Number of signaled error/warning/exception alerts for database profile: 1/5/0
BR0806I End of BRCONNECT processing: ceezglvx.chk2011-01-11 11.14.54
BR0280I BRCONNECT time stamp: 2011-01-11 11.14.54
BR0803I BRCONNECT completed successfully with warnings
External program terminated with exit code 1
BRCONNECT returned error status E
Job finished

Former Member
0 Kudos

Hi Volker,

Whenever i try to change the Oracle Parameters, I get the error message below:

BR0259I Program execution will be continued...

BR0370I Directory F:\oracle\TST\sapreorg\seezgmvd created

BR0202I Copying E:\oracle\TST\102\database\spfileTST.ora
BR0203I to F:\oracle\TST\sapreorg\seezgmvd\spfileTST.ora ...
BR0280I BRSPACE time stamp: 2011-01-11 11.26.34
BR0301E SQL error -2097 at location BrSqlExecute-1, SQL statement:
'/* BRSPACE */ alter system set shared_pool_size = 524288000 scope = both'
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool
BR1017E Execution of SQL statement 'alter system set shared_pool_size = 52428800
0 scope = both' failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to
repeat the last action

System's Main memory size is 4GB, how should i try to release the memory and distribute among the parameters, but i dont think this is paramter issue coz i never changed the numbers before or after the issue occured.

Thanks & Regards.

nirmal_konchada
Active Contributor
0 Kudos

Hi,

Try recreating your control file and check.

tune oracle with sap note 830576.

Regards,

Nirmal.K

volker_borowski2
Active Contributor
0 Kudos

Hi,

- Is the system up and runable right now? (assume "yes" because you can start a dbcheck)

- Do you still get any errors in the alertlog after a normal shutdown and a normal startup?

If yes, what are these? The ORA-600 [4097] ones?

So the basic question is, are the errors still there, or are these simply errors from an earlier timestamp.

I guess it would be a good idea to stop the system and rename the alert.log, so the next startup writes an

entirely new alert log, that does not contain any old messages. Check the new file for errors.

Do not create a new controlfile now, unless you are sure you need to do so.

I have seen more CREATE CONTROLFILE statements doing damage than ones that did help.

Volker

Former Member
0 Kudos

Thanks Volker,

I will check and reply back.

Regards.

Former Member
0 Kudos

As per: Metalink Note 397404.1

SHADOW_CORE_DUMP is a static parameter so the database must be restarted in order for the

parameter value to be enabled. Setting SHADOW_CORE_DUMP to NONE will block the generation of

core dumps from user (client) processes attached to the SGA. Setting this parameter has no impact on

core dumps being generated by background processes. It is not possible to set

BACKGROUND_CORE_DUMP to NONE. So this method will prevent core dumps from being generated by

user processes but will not prevent the generation of core dumps by background processes.

=====

>>>Done it, will reply back further after a review.

Former Member
0 Kudos

OK,

Here is the new alert log (Startup & Shutdown):


Fri Jan 14 12:26:58 2011
Starting ORACLE instance (normal)
Fri Jan 14 12:26:58 2011
Specified value of sga_max_size is too small, bumping to 645922816
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
  processes                = 80
  sessions                 = 96
  event                    = 10191 trace name context forever, level 1
  sga_max_size             = 645922816
  __shared_pool_size       = 318767104
  shared_pool_size         = 318767104
  __java_pool_size         = 4194304
  java_pool_size           = 4194304
  shared_pool_reserved_size= 31598837
  trace_enabled            = FALSE
  filesystemio_options     = setall
  control_files            = E:\ORACLE\TST\ORIGLOGA\CNTRL\CNTLRTST.DBF, E:\ORACLE\TST\ORIGLOGB\CNTRL\CNTRLTST.DBF, F:\ORACLE\TST\SAPDATA1\CNTRL\CNTRLTST.DBF
  control_file_record_keep_time= 30
  db_block_size            = 8192
  __db_cache_size          = 318767104
  db_cache_size            = 318767104
  compatible               = 10.2.0
  log_archive_dest         = E:\oracle\TST\oraarch\TSTarch
  log_buffer               = 2061312
  log_checkpoint_interval  = 0
  db_files                 = 254
  log_checkpoints_to_alert = TRUE
  dml_locks                = 4000
  undo_management          = AUTO
  undo_tablespace          = PSAPUNDO
  undo_retention           = 43200
  recyclebin               = off
  remote_os_authent        = TRUE
  remote_login_passwordfile= EXCLUSIVE
  dispatchers              = (PROTOCOL=TCP) (SERVICE=TSTXDB)
  job_queue_processes      = 1
  shadow_core_dump         = none
  background_dump_dest     = F:\ORACLE\TST\SAPTRACE\BACKGROUND
  user_dump_dest           = F:\ORACLE\TST\SAPTRACE\USERTRACE
  core_dump_dest           = F:\ORACLE\TST\SAPTRACE\BACKGROUND
  optimizer_features_enable= 10.2.0.1
  sort_area_size           = 2097152
  sort_area_retained_size  = 0
  db_name                  = TST
  open_cursors             = 800
  _optim_peek_user_binds   = FALSE
  pga_aggregate_target     = 421317836
  workarea_size_policy     = AUTO
  statistics_level         = typical
  dg_broker_start          = TRUE
PMON started with pid=2, OS id=2840
PSP0 started with pid=3, OS id=740
MMAN started with pid=4, OS id=3512
DBW0 started with pid=5, OS id=1896
LGWR started with pid=6, OS id=4380
CKPT started with pid=7, OS id=4656
SMON started with pid=8, OS id=1152
RECO started with pid=9, OS id=4776
CJQ0 started with pid=10, OS id=4588
MMON started with pid=11, OS id=492
Fri Jan 14 12:26:59 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=536
Fri Jan 14 12:26:59 2011
starting up 1 shared server(s) ...
DMON started with pid=16, OS id=1808
Fri Jan 14 12:26:59 2011
ALTER DATABASE   MOUNT
Fri Jan 14 12:27:05 2011
Setting recovery target incarnation to 4
Fri Jan 14 12:27:05 2011
Successful mount of redo thread 1, with mount id 1881536531
Fri Jan 14 12:27:05 2011
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Fri Jan 14 12:27:06 2011
ALTER DATABASE OPEN
Fri Jan 14 12:27:07 2011
Starting Data Guard Broker (DMON)
INSV started with pid=15, OS id=3352
Fri Jan 14 12:27:15 2011
Beginning crash recovery of 1 threads
 parallel recovery started with 2 processes
Fri Jan 14 12:27:19 2011
Started redo scan
Fri Jan 14 12:27:21 2011
Completed redo scan
 80 redo blocks read, 51 data blocks need recovery
Fri Jan 14 12:27:21 2011
Started redo application at
 Thread 1: logseq 18, block 12852
Fri Jan 14 12:27:21 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 18 Reading mem 0
  Mem# 0: E:\ORACLE\TST\ORIGLOGB\LOG_G12M1.DBF
  Mem# 1: E:\ORACLE\TST\MIRRLOGB\LOG_G12M2.DBF
Fri Jan 14 12:27:22 2011
Completed redo application
Fri Jan 14 12:27:22 2011
Completed crash recovery at
 Thread 1: logseq 18, block 12932, scn 17148061
 51 data blocks read, 51 data blocks written, 80 redo blocks read
Fri Jan 14 12:27:24 2011
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=20, OS id=3664
Fri Jan 14 12:27:24 2011
ARC0: Archival started
ARC1 started with pid=21, OS id=1416
Fri Jan 14 12:27:24 2011
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Fri Jan 14 12:27:25 2011
Thread 1 advanced to log sequence 19 (thread open)
Thread 1 opened at log sequence 19
  Current log# 3 seq# 19 mem# 0: E:\ORACLE\TST\ORIGLOGA\LOG_G13M1.DBF
  Current log# 3 seq# 19 mem# 1: E:\ORACLE\TST\MIRRLOGA\LOG_G13M2.DBF
Successful open of redo thread 1
Fri Jan 14 12:27:28 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jan 14 12:27:28 2011
SMON: enabling cache recovery
Fri Jan 14 12:27:29 2011
Incremental checkpoint up to RBA 0x13.3.0, current log tail at RBA 0x13.3.0
Fri Jan 14 12:27:30 2011
ARC1: Becoming the no FAL ARCH
ARC1: Becoming the no SRL ARCH
Fri Jan 14 12:27:30 2011
ARC0: Becoming the heartbeat ARCH
Fri Jan 14 12:27:35 2011
Successfully onlined Undo Tablespace 1.
Fri Jan 14 12:27:37 2011
SMON: enabling tx recovery
Fri Jan 14 12:27:38 2011
Database Characterset is UTF8
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 2
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=22, OS id=3784
Fri Jan 14 12:28:00 2011
Completed: ALTER DATABASE OPEN
Fri Jan 14 12:29:51 2011
Shutting down instance: further logons disabled
Fri Jan 14 12:29:51 2011
Stopping background process QMNC
Fri Jan 14 12:29:51 2011
Stopping background process CJQ0
Fri Jan 14 12:29:53 2011
Background process QMNC not dead after 150 seconds
Fri Jan 14 12:29:53 2011
Stopping background process MMNL
Fri Jan 14 12:29:54 2011
Background process MMNL not dead after 10 seconds
Fri Jan 14 12:29:54 2011
Stopping background process MMON
Fri Jan 14 12:29:55 2011
Background process MMON not dead after 30 seconds
Fri Jan 14 12:29:55 2011
Shutting down instance (immediate)
License high water mark = 10
Fri Jan 14 12:29:55 2011
Stopping Job queue slave processes, flags = 7
Fri Jan 14 12:29:55 2011
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Jan 14 12:30:00 2011
ALTER DATABASE CLOSE NORMAL
Fri Jan 14 12:30:00 2011
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Jan 14 12:30:03 2011
Shutting down archive processes
Archiving is disabled
Fri Jan 14 12:30:08 2011
ARCH shutting down
ARC1: Archival stopped
Fri Jan 14 12:30:13 2011
ARCH shutting down
ARC0: Archival stopped
Fri Jan 14 12:30:14 2011
Thread 1 closed at log sequence 19
Successful close of redo thread 1
Fri Jan 14 12:30:18 2011
Completed: ALTER DATABASE CLOSE NORMAL
Fri Jan 14 12:30:18 2011
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Shutting down Data Guard Broker processes
Fri Jan 14 12:30:20 2011
Completed: Data Guard Broker shutdown
Fri Jan 14 12:30:22 2011
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active

  • Another Thing, 2 core dump file are being genereted after every 1 hour (During SAP Instance up).

Why this code tag often does not work with log file?

Former Member
0 Kudos

Issue Unresolved.

Closing Thread.

-Regards.