ORA-03113: end-of-file on communication channel
Process ID: 7920
Session ID: 170 Serial number: 5去alert_<instance>.log查了下7920的id,没发现什么问题。系统是windows2008 32bit,Oracle 11.1.0.6.0.
数据库基本都是空的,只要能连上做测试就行。网上google了很多,做了几步操作后又出来很多oracle memory size问题,折腾了很久又还原了。如果分不够再加。底下是7920的trace:Trace file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_7920.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.0 Service Pack 2
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:941M/2046M, Ph+PgF:2221M/4331M, VA:1195M/2047M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 18
Windows thread id: 7920, image: ORACLE.EXE (SHAD)
*** 2013-03-25 15:37:59.614
*** SESSION ID:(170.5) 2013-03-25 15:37:59.621
*** CLIENT ID:() 2013-03-25 15:37:59.621
*** SERVICE NAME:() 2013-03-25 15:37:59.621
*** MODULE NAME:(sqlplus.exe) 2013-03-25 15:37:59.621
*** ACTION NAME:() 2013-03-25 15:37:59.621
Successfully allocated 2 recovery slaves
Using 545 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 8, block 2, scn 73960475
cache-low rba: logseq 8, block 3
on-disk rba: logseq 8, block 79, scn 73960556
start recovery at logseq 8, block 3, scn 0
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 38Kb in 0.23s => 0.16 Mb/sec
Longest record: 0Kb, moves: 0/88 (0%)
Longest LWN: 9Kb, moves: 0/23 (0%), moved: 0Mb
Last redo scn: 0x0000.04688c6b (73960555)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 25/25 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 146/171 = 0.9
----------------------------------------------*** 2013-03-25 15:37:59.967
KCRA: start recovery claims for 25 data blocks*** 2013-03-25 15:37:59.971
KCRA: blocks processed = 25/25, claimed = 25, eliminated = 0*** 2013-03-25 15:38:00.061
Recovery of Online Redo Log: Thread 1 Group 2 Seq 8 Reading mem 0*** 2013-03-25 15:38:00.081
Completed redo application*** 2013-03-25 15:38:00.155
Completed recovery checkpoint
IR RIA: redo_size 38912 bytes, time_taken 25 ms
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 25/25 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 171/171 = 1.0
----------------------------------------------*** 2013-03-25 15:38:07.624
kwqmnich: current time:: 7: 38: 6
kwqmnich: instance no 0 check_only flag 1
kwqmnich: initialized job cache structure
Process ID: 7920
Session ID: 170 Serial number: 5去alert_<instance>.log查了下7920的id,没发现什么问题。系统是windows2008 32bit,Oracle 11.1.0.6.0.
数据库基本都是空的,只要能连上做测试就行。网上google了很多,做了几步操作后又出来很多oracle memory size问题,折腾了很久又还原了。如果分不够再加。底下是7920的trace:Trace file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_7920.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.0 Service Pack 2
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:941M/2046M, Ph+PgF:2221M/4331M, VA:1195M/2047M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 18
Windows thread id: 7920, image: ORACLE.EXE (SHAD)
*** 2013-03-25 15:37:59.614
*** SESSION ID:(170.5) 2013-03-25 15:37:59.621
*** CLIENT ID:() 2013-03-25 15:37:59.621
*** SERVICE NAME:() 2013-03-25 15:37:59.621
*** MODULE NAME:(sqlplus.exe) 2013-03-25 15:37:59.621
*** ACTION NAME:() 2013-03-25 15:37:59.621
Successfully allocated 2 recovery slaves
Using 545 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 8, block 2, scn 73960475
cache-low rba: logseq 8, block 3
on-disk rba: logseq 8, block 79, scn 73960556
start recovery at logseq 8, block 3, scn 0
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 38Kb in 0.23s => 0.16 Mb/sec
Longest record: 0Kb, moves: 0/88 (0%)
Longest LWN: 9Kb, moves: 0/23 (0%), moved: 0Mb
Last redo scn: 0x0000.04688c6b (73960555)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 25/25 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 146/171 = 0.9
----------------------------------------------*** 2013-03-25 15:37:59.967
KCRA: start recovery claims for 25 data blocks*** 2013-03-25 15:37:59.971
KCRA: blocks processed = 25/25, claimed = 25, eliminated = 0*** 2013-03-25 15:38:00.061
Recovery of Online Redo Log: Thread 1 Group 2 Seq 8 Reading mem 0*** 2013-03-25 15:38:00.081
Completed redo application*** 2013-03-25 15:38:00.155
Completed recovery checkpoint
IR RIA: redo_size 38912 bytes, time_taken 25 ms
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 25/25 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 171/171 = 1.0
----------------------------------------------*** 2013-03-25 15:38:07.624
kwqmnich: current time:: 7: 38: 6
kwqmnich: instance no 0 check_only flag 1
kwqmnich: initialized job cache structure
ALERT_ORCL.LOGTue Mar 26 12:23:23 2013
Starting ORACLE instance (normal)
Specified value of sga_max_size is too small, bumping to 536870912
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as c:\app\Administrator\product\11.1.0\db_1\RDBMS
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile C:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes = 150
sga_max_size = 512M
large_pool_size = 80M
dbwr_io_slaves = 2
backup_tape_io_slaves = TRUE
sga_target = 256M
memory_target = 1536M
control_files = "C:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL"
control_files = "C:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL02.CTL"
control_files = "C:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL03.CTL"
db_block_size = 8192
compatible = "11.1.0.0.0"
db_recovery_file_dest = "c:\app\Administrator\flash_recovery_area"
db_recovery_file_dest_size= 15G
_allow_resetlogs_corruption= TRUE
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
audit_file_dest = "C:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 300
diagnostic_dest = "C:\APP\ADMINISTRATOR"
Tue Mar 26 12:23:25 2013
PMON started with pid=2, OS id=7900
Tue Mar 26 12:23:25 2013
VKTM started with pid=3, OS id=4508 at elevated priority
VKTM running at (20)ms precision
Tue Mar 26 12:23:25 2013
DIAG started with pid=4, OS id=3252
Tue Mar 26 12:23:25 2013
DBRM started with pid=5, OS id=6796
Tue Mar 26 12:23:25 2013
PSP0 started with pid=6, OS id=6868
Tue Mar 26 12:23:25 2013
DSKM started with pid=7, OS id=7080
Tue Mar 26 12:23:25 2013
DIA0 started with pid=8, OS id=7548
Tue Mar 26 12:23:25 2013
MMAN started with pid=7, OS id=7740
Tue Mar 26 12:23:25 2013
DBW0 started with pid=9, OS id=8124
Tue Mar 26 12:23:25 2013
LGWR started with pid=10, OS id=6000
Tue Mar 26 12:23:25 2013
CKPT started with pid=11, OS id=7744
Tue Mar 26 12:23:25 2013
SMON started with pid=12, OS id=7452
Tue Mar 26 12:23:25 2013
RECO started with pid=13, OS id=7600
Tue Mar 26 12:23:25 2013
MMON started with pid=14, OS id=7040
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Mar 26 12:23:25 2013
MMNL started with pid=15, OS id=6668
starting up 1 shared server(s) ...
ORACLE_BASE from environment = c:\app\Administrator
Tue Mar 26 12:23:26 2013
ALTER DATABASE MOUNT
Tue Mar 26 12:23:29 2013
Sweep Incident[220972]: completed
Sweep Incident[220056]: completed
Sweep Incident[220048]: completed
Sweep Incident[220042]: completed
Sweep Incident[220041]: completed
Sweep Incident[220040]: completed
Sweep Incident[220032]: completed
Sweep Incident[220016]: completed
Sweep Incident[219995]: completed
Sweep Incident[219994]: completed
Sweep Incident[219913]: completed
Sweep Incident[219912]: completed
Sweep Incident[219884]: completed
Sweep Incident[219784]: completed
Setting recovery target incarnation to 7
Successful mount of redo thread 1, with mount id 1338902592
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Tue Mar 26 12:23:34 2013
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Started redo scan
Completed redo scan
3142 redo blocks read, 321 data blocks need recovery
Started redo application at
Thread 1: logseq 11, block 3
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Tue Mar 26 12:23:35 2013
Running KSFV I/O slave I101 os pid=6908
Tue Mar 26 12:23:35 2013
Running KSFV I/O slave I102 os pid=6480
Completed redo application
Completed crash recovery at
Thread 1: logseq 11, block 3145, scn 74041221
321 data blocks read, 321 data blocks written, 3142 redo blocks read
Tue Mar 26 12:23:35 2013
Thread 1 advanced to log sequence 12
Thread 1 opened at log sequence 12
Current log# 3 seq# 12 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Mar 26 12:23:35 2013
Running KSFV I/O slave I201 os pid=6504
Tue Mar 26 12:23:35 2013
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
Starting background process FBDA
Starting background process SMCO
Tue Mar 26 12:23:38 2013
FBDA started with pid=24, OS id=6576
Tue Mar 26 12:23:38 2013
SMCO started with pid=25, OS id=3532
replication_dependency_tracking turned off (no async multimaster replication found)
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smon_7452.trc (incident=221078):
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
Incident details in: c:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_221078\orcl_smon_7452_i221078.trc
Doing block recovery for file 3 block 408396
Block recovery from logseq 12, block 63 to scn 74041488
Starting background process QMNC
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Tue Mar 26 12:23:42 2013
QMNC started with pid=27, OS id=6980
Block recovery completed at rba 12.65.16, scn 0.74041489
Tue Mar 26 12:23:42 2013
Trace dumping is performing id=[cdmp_20130326122342]
Doing block recovery for file 3 block 25
Block recovery from logseq 12, block 63 to scn 74041485
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Block recovery completed at rba 12.64.16, scn 0.74041488
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smon_7452.trc:
ORA-01595: error freeing extent (1568) of rollback segment (2))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
Tue Mar 26 12:23:46 2013
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_7040.trc (incident=221094):
ORA-00600: internal error code, arguments: [4194], [31], [29], [], [], [], [], []
Incident details in: c:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_221094\orcl_mmon_7040_i221094.trc
Trace dumping is performing id=[cdmp_20130326122347]
Doing block recovery for file 3 block 411205
Block recovery from logseq 12, block 69 to scn 74041498
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Block recovery stopped at EOT rba 12.71.16
Block recovery completed at rba 12.71.16, scn 0.74041496
Doing block recovery for file 3 block 105
Block recovery from logseq 12, block 69 to scn 74041495
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Block recovery completed at rba 12.71.16, scn 0.74041496
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_7040.trc (incident=221095):
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
Incident details in: c:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_221095\orcl_mmon_7040_i221095.trc
Tue Mar 26 12:23:56 2013
Trace dumping is performing id=[cdmp_20130326122356]
Tue Mar 26 12:23:56 2013
Flush retried for xcb 0x2de9bfe4, pmd 0x2eb45060
Doing block recovery for file 3 block 408396
Block recovery from logseq 12, block 63 to scn 74041488
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Block recovery completed at rba 12.65.16, scn 0.74041489
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_7040.trc (incident=221096):
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
Incident details in: c:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_221096\orcl_mmon_7040_i221096.trc
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_7040.trc (incident=221097):
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
Incident details in: c:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_221097\orcl_mmon_7040_i221097.trc
Trace dumping is performing id=[cdmp_20130326122359]
Flush retried for xcb 0x2de9bfe4, pmd 0x2eb45060
Doing block recovery for file 3 block 408396
Block recovery from logseq 12, block 63 to scn 74041488
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Block recovery completed at rba 12.65.16, scn 0.74041489
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_7040.trc (incident=221098):
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
Incident details in: c:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_221098\orcl_mmon_7040_i221098.trc
Flush retried for xcb 0x2de9bfe4, pmd 0x2eb45060
Doing block recovery for file 3 block 408396
Block recovery from logseq 12, block 63 to scn 74041488
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Block recovery completed at rba 12.65.16, scn 0.74041489
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_7040.trc (incident=221099):
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
Flush retried for xcb 0x2de9bfe4, pmd 0x2eb45060
Block recovery completed at rba 12.65.16, scn 0.74041489
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_7040.trc (incident=222183):
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_7040.trc (incident=222184):
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-06512: at "SYS.DBMS_HA_ALERTS_PRVT", line 339
ORA-06512: at line 1
Incident details in: c:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_222184\orcl_mmon_7040_i222184.trc
Tue Mar 26 12:24:06 2013
Flush retried for xcb 0x2de9bfe4, pmd 0x2eb45060
Doing block recovery for file 3 block 408396
Block recovery from logseq 12, block 63 to scn 74041488
Tue Mar 26 12:24:06 2013
Trace dumping is performing id=[cdmp_20130326122406]
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Block recovery completed at rba 12.65.16, scn 0.74041489
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_7040.trc (incident=222185):
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-06512: at "SYS.DBMS_HA_ALERTS_PRVT", line 339
ORA-06512: at line 1
Tue Mar 26 12:24:07 2013
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_6256.trc (incident=221214):
ORA-00600: internal error code, arguments: [4194], [31], [29], [], [], [], [], []
Doing block recovery for file 3 block 411205
Block recovery from logseq 12, block 69 to scn 74041498
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Block recovery completed at rba 12.71.16, scn 0.74041500
Doing block recovery for file 3 block 408396
Block recovery from logseq 12, block 63 to scn 74041488
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Block recovery completed at rba 12.65.16, scn 0.74041489
Trace dumping is performing id=[cdmp_20130326122403]
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_7040.trc (incident=221100):
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
Flush retried for xcb 0x2de9bfe4, pmd 0x2eb45060
Doing block recovery for file 3 block 408396
Block recovery from logseq 12, block 63 to scn 74041488
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Block recovery completed at rba 12.65.16, scn 0.74041489
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_7040.trc (incident=221101):
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
Flush retried for xcb 0x2de9bfe4, pmd 0x2eb45060
Doing block recovery for file 3 block 408396
Block recovery from logseq 12, block 63 to scn 74041488
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Doing block recovery for file 3 block 105
Block recovery from logseq 12, block 69 to scn 74041518
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Block recovery completed at rba 12.89.16, scn 0.74041519
Tue Mar 26 12:24:10 2013
Flush retried for xcb 0x2de9bfe4, pmd 0x2eb45060
Doing block recovery for file 3 block 408396
Block recovery from logseq 12, block 63 to scn 74041488
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Block recovery completed at rba 12.65.16, scn 0.74041489
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_pmon_7900.trc (incident=220998):
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_pmon_7900.trc:
ORA-00600: internal error code, arguments: [4194], [14], [14], [], [], [], [], []
PMON (ospid: 7900): terminating the instance due to error 472
Tue Mar 26 12:24:11 2013
ORA-00472: PMON process terminated with error
Tue Mar 26 12:24:11 2013
ORA-00472: PMON process terminated with error
Tue Mar 26 12:24:11 2013
ORA-1092 : opidrv aborting process W000 ospid (4308_7628)
Tue Mar 26 12:24:11 2013
ORA-00472: PMON process terminated with error
Instance terminated by PMON, pid = 7900
Steps:SQL> connect / as sysdba;
Connected to an idle instance.
SQL> startup
ORACLE instance started.Total System Global Area 535678976 bytes
Fixed Size 1334320 bytes
Variable Size 209716176 bytes
Database Buffers 318767104 bytes
Redo Buffers 5861376 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 5288
Session ID: 170 Serial number: 5
Trace[orcl_ora_5288]Trace file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5288.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.0 Service Pack 2
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:951M/2046M, Ph+PgF:2357M/4357M, VA:1169M/2047M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 18
Windows thread id: 5288, image: ORACLE.EXE (SHAD)
*** 2011-07-20 14:33:24.321
*** SESSION ID:(170.5) 2011-07-20 14:33:24.321
*** CLIENT ID:() 2011-07-20 14:33:24.321
*** SERVICE NAME:() 2011-07-20 14:33:24.321
*** MODULE NAME:(sqlplus.exe) 2011-07-20 14:33:24.321
*** ACTION NAME:() 2011-07-20 14:33:24.321
Successfully allocated 2 recovery slaves
Using 545 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 25, block 2, scn 70288744
cache-low rba: logseq 25, block 3
on-disk rba: logseq 25, block 139, scn 70288899
start recovery at logseq 25, block 3, scn 0*** 2011-07-20 14:33:24.781
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 68Kb in 0.32s => 0.21 Mb/sec
Longest record: 3Kb, moves: 0/164 (0%)
Longest LWN: 16Kb, moves: 0/43 (0%), moved: 0Mb
Last redo scn: 0x0000.04308602 (70288898)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 55/55 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 275/330 = 0.8
----------------------------------------------*** 2011-07-20 14:33:24.812
KCRA: start recovery claims for 55 data blocks*** 2011-07-20 14:33:24.816
KCRA: blocks processed = 55/55, claimed = 55, eliminated = 0*** 2011-07-20 14:33:25.016
Recovery of Online Redo Log: Thread 1 Group 1 Seq 25 Reading mem 0*** 2011-07-20 14:33:25.037
Completed redo application*** 2011-07-20 14:33:25.449
Completed recovery checkpoint
IR RIA: redo_size 69632 bytes, time_taken 63 ms
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 55/55 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 330/330 = 1.0
----------------------------------------------*** 2011-07-20 14:33:43.606
kwqmnich: current time:: 6: 33: 43
kwqmnich: instance no 0 check_only flag 1 *** 2011-07-20 14:33:46.728
kwqmnich: initialized job cache structure
Trace file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5288.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.0 Service Pack 2
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:902M/2046M, Ph+PgF:2191M/4331M, VA:1126M/2047M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 18
Windows thread id: 5288, image: ORACLE.EXE (SHAD)
*** 2013-03-26 12:23:34.812
*** SESSION ID:(170.5) 2013-03-26 12:23:34.812
*** CLIENT ID:() 2013-03-26 12:23:34.812
*** SERVICE NAME:() 2013-03-26 12:23:34.812
*** MODULE NAME:(sqlplus.exe) 2013-03-26 12:23:34.812
*** ACTION NAME:() 2013-03-26 12:23:34.812
Successfully allocated 2 recovery slaves
Using 545 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 11, block 2, scn 74020780
cache-low rba: logseq 11, block 3
on-disk rba: logseq 11, block 3145, scn 74021221
start recovery at logseq 11, block 3, scn 0
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 1571Kb in 0.20s => 7.67 Mb/sec
Longest record: 4Kb, moves: 0/5301 (0%)
Longest LWN: 960Kb, moves: 0/74 (0%), moved: 0Mb
Last redo scn: 0x0000.04697964 (74021220)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 2
Average hash chain = 321/319 = 1.0
Max compares per lookup = 2
Avg compares per lookup = 10302/10551 = 1.0
----------------------------------------------*** 2013-03-26 12:23:35.093
KCRA: start recovery claims for 321 data blocks*** 2013-03-26 12:23:35.104
KCRA: blocks processed = 321/321, claimed = 321, eliminated = 0*** 2013-03-26 12:23:35.195
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0*** 2013-03-26 12:23:35.292
Completed redo application*** 2013-03-26 12:23:35.355
Completed recovery checkpoint
IR RIA: redo_size 1608704 bytes, time_taken 32 ms
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 2
Average hash chain = 321/319 = 1.0
Max compares per lookup = 2
Avg compares per lookup = 10556/10551 = 1.0
----------------------------------------------*** 2013-03-26 12:23:42.038
kwqmnich: current time:: 4: 23: 41
kwqmnich: instance no 0 check_only flag 1 *** 2013-03-26 12:23:42.627
kwqmnich: initialized job cache structure
SQL> show parameter memory_targetNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_target big integer 1536M
SQL> show parameter memory_max_targetNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big integer 1536M
求具体步骤,如何重做redo记录什么的?我不是dba,对这个实在不太了解。