Skip to Content
0
Jan 10, 2011 at 07:58 AM

Large Core Dumps after DB Backup Control File

118 Views

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.