on 01-10-2011 7:58 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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]
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
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], [], [], [], [], [], [], []
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.
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
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
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.
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
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.
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?
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.