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.