SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 8201
Session ID: 502 Serial number: 3
---------------------------
(Not logged on)
---------------------------
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
---------------------------
OK
---------------------------下面是 alert 日志:
License high water = 16
USER (ospid: 11060): terminating the instance
Instance terminated by USER, pid = 11060
Mon Feb 06 18:54:48 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =220
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /var/local/oracle/product/11.2.0/db_1/dbs/spfileorcl.ora
System parameters with non-default values:
processes = 1000
sessions = 2000
memory_target = 6464M
memory_max_target = 6464M
control_files = "/var/local/oracle/oradata/orcl/control01.ctl"
control_files = "/var/local/oracle/flash_recovery_area/orcl/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "location=/data/assyfile/arch"
db_recovery_file_dest = "/var/local/oracle/flash_recovery_area"
db_recovery_file_dest_size= 3882M
_allow_resetlogs_corruption= TRUE
undo_tablespace = "UNDOTBS1"
undo_retention = 300
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
local_listener = ""
result_cache_mode = "AUTO"
result_cache_max_size = 200M
audit_file_dest = "/var/local/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 1000
control_management_pack_access= "none"
diagnostic_dest = "/var/local/oracle"
Mon Feb 06 18:54:51 2012
PMON started with pid=2, OS id=11152
Mon Feb 06 18:54:51 2012
VKTM started with pid=3, OS id=11154 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Feb 06 18:54:51 2012
GEN0 started with pid=4, OS id=11158
Mon Feb 06 18:54:51 2012
DIAG started with pid=5, OS id=11160
Mon Feb 06 18:54:51 2012
DBRM started with pid=6, OS id=11162
Mon Feb 06 18:54:51 2012
PSP0 started with pid=7, OS id=11164
Mon Feb 06 18:54:51 2012
DIA0 started with pid=8, OS id=11166
Mon Feb 06 18:54:51 2012
MMAN started with pid=9, OS id=11168
Mon Feb 06 18:54:51 2012
DBW0 started with pid=10, OS id=11170
Mon Feb 06 18:54:51 2012
DBW1 started with pid=11, OS id=11172
Mon Feb 06 18:54:51 2012
LGWR started with pid=12, OS id=11174
Mon Feb 06 18:54:51 2012
CKPT started with pid=13, OS id=11176
Mon Feb 06 18:54:51 2012
SMON started with pid=14, OS id=11178
Mon Feb 06 18:54:51 2012
RECO started with pid=15, OS id=11180
Mon Feb 06 18:54:51 2012
MMON started with pid=16, OS id=11182
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Feb 06 18:54:51 2012
MMNL started with pid=17, OS id=11184
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /var/local/oracle
Mon Feb 06 18:54:51 2012
ALTER DATABASE MOUNT
Mon Feb 06 18:54:54 2012
Sweep [inc][296202]: completed
Sweep [inc2][296202]: completed
Successful mount of redo thread 1, with mount id 1302324347
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Mon Feb 06 18:54:55 2012
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 15 processes
Started redo scan
Completed redo scan
read 731 KB redo, 124 data blocks need recovery
Started redo application at
Thread 1: logseq 10, block 343
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0
Mem# 0: /var/local/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_1_7lytw23d_.log
Completed redo application of 0.62MB
Completed crash recovery at
Thread 1: logseq 10, block 1806, scn 35604785526
124 data blocks read, 124 data blocks written, 731 redo k-bytes read
LGWR: STARTING ARCH PROCESSES
Mon Feb 06 18:54:57 2012
ARC0 started with pid=36, OS id=11226
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thread 1 advanced to log sequence 11 (thread open)
Mon Feb 06 18:54:58 2012
ARC1 started with pid=37, OS id=11228
Mon Feb 06 18:54:58 2012
ARC2 started with pid=38, OS id=11230
ARC1: Archival started
Mon Feb 06 18:54:58 2012
ARC3 started with pid=39, OS id=11232
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Thread 1 opened at log sequence 11
Current log# 2 seq# 11 mem# 0: /var/local/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_7lytw2np_.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Archived Log entry 10 added for thread 1 sequence 10 ID 0x4d9f7c79 dest 1:
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 AL32UTF8
No Resource Manager plan active
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_smon_11178.trc (incident=304206):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /var/local/oracle/diag/rdbms/orcl/orcl/incident/incdir_304206/orcl_smon_11178_i304206.trc
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_11194.trc (incident=304254):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /var/local/oracle/diag/rdbms/orcl/orcl/incident/incdir_304254/orcl_ora_11194_i304254.trc
ORA-00308: cannot open archived log '/data/assyfile/arch/1_1_774539777.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_smon_11178.trc:
ORA-00308: cannot open archived log '/data/assyfile/arch/1_1_774539777.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Doing block recovery for file 39 block 307067
Resuming block recovery (PMON) for file 39 block 307067
Block recovery from logseq 11, block 187 to scn 35604785863
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /var/local/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_7lytw2np_.log
Block recovery stopped at EOT rba 11.190.16
Block recovery completed at rba 11.190.16, scn 8.1245047493
Doing block recovery for file 3 block 144
Resuming block recovery (PMON) for file 3 block 144
Block recovery from logseq 11, block 187 to scn 35604785859
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /var/local/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_7lytw2np_.log
Block recovery completed at rba 11.188.16, scn 8.1245047492
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_smon_11178.trc:
ORA-01595: error freeing extent (14) of rollback segment (2))
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Trace dumping is performing id=[cdmp_20120206185500]
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_11194.trc:
ORA-00308: cannot open archived log '/data/assyfile/arch/1_1_774539777.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_11194.trc:
ORA-00308: cannot open archived log '/data/assyfile/arch/1_1_774539777.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Doing block recovery for file 39 block 303985
Resuming block recovery (PMON) for file 39 block 303985
Block recovery from logseq 11, block 188 to scn 35604785866
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /var/local/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_7lytw2np_.log
Block recovery stopped at EOT rba 11.190.16
Block recovery completed at rba 11.190.16, scn 8.1245047493
Doing block recovery for file 3 block 272
Resuming block recovery (PMON) for file 3 block 272
Block recovery from logseq 11, block 188 to scn 35604785860
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /var/local/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_7lytw2np_.log
Block recovery completed at rba 11.190.16, scn 8.1245047493
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Mon Feb 06 18:55:01 2012
QMNC started with pid=40, OS id=11241
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x3DCA1244] [PC:0x2297724, kgegpa()+40] [flags: 0x0, count: 1]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x3DCA1244] [PC:0x229594F, kgebse()+279] [flags: 0x2, count: 2]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x3DCA1244] [PC:0x229594F, kgebse()+279] [flags: 0x2, count: 2]
Starting background process SMCO
Mon Feb 06 18:55:01 2012
SMCO started with pid=41, OS id=11244
Mon Feb 06 18:55:01 2012
Trace dumping is performing id=[cdmp_20120206185501]
Mon Feb 06 18:55:01 2012
db_recovery_file_dest_size of 3882 MB is 1.29% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Feb 06 18:55:03 2012
Doing block recovery for file 39 block 303985
Resuming block recovery (PMON) for file 39 block 303985
Block recovery from logseq 11, block 188 to scn 35604785866
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /var/local/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_7lytw2np_.log
Block recovery completed at rba 11.190.16, scn 8.1245047501
Doing block recovery for file 3 block 272
Resuming block recovery (PMON) for file 3 block 272
Block recovery from logseq 11, block 188 to scn 35604785873
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /var/local/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_7lytw2np_.log
Block recovery completed at rba 11.192.16, scn 8.1245047506
Mon Feb 06 18:55:03 2012
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_11248.trc (incident=304255):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /var/local/oracle/diag/rdbms/orcl/orcl/incident/incdir_304255/orcl_m000_11248_i304255.trc
Mon Feb 06 18:55:04 2012
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_m001_11256.trc (incident=304430):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /var/local/oracle/diag/rdbms/orcl/orcl/incident/incdir_304430/orcl_m001_11256_i304430.trc
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_11248.trc:
ORA-00308: cannot open archived log '/data/assyfile/arch/1_1_774539777.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_11248.trc:
ORA-00308: cannot open archived log '/data/assyfile/arch/1_1_774539777.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Doing block recovery for file 13 block 331624
Resuming block recovery (PMON) for file 13 block 331624
Block recovery from logseq 11, block 224 to scn 35604785900
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /var/local/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_7lytw2np_.log
Block recovery stopped at EOT rba 11.228.16
Block recovery completed at rba 11.228.16, scn 8.1245047531
Doing block recovery for file 3 block 344
Resuming block recovery (PMON) for file 3 block 344
Block recovery from logseq 11, block 224 to scn 35604785894
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /var/local/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_7lytw2np_.log
Block recovery completed at rba 11.226.16, scn 8.1245047527
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_11248.trc (incident=304256):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /var/local/oracle/diag/rdbms/orcl/orcl/incident/incdir_304256/orcl_m000_11248_i304256.trc
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_m001_11256.trc:
ORA-00308: cannot open archived log '/data/assyfile/arch/1_1_774539777.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Flush retried for xcb 0x1f1f17090, pmd 0x1d7489f38
Doing block recovery for file 13 block 402021
No block recovery was needed
Exception [type: SIGBUS, Non-existent physical address] [ADDR:0x7E0D3F5D] [PC:0x2297724, kgegpa()+40] [flags: 0x0, count: 1]
Exception [type: SIGBUS, Non-existent physical address] [ADDR:0x7E0D3F5D] [PC:0x229594F, kgebse()+279] [flags: 0x2, count: 2]
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_11248.trc:
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Flush retried for xcb 0x1f1f17090, pmd 0x1d7489f38
Doing block recovery for file 13 block 402021
No block recovery was needed
Trace dumping is performing id=[cdmp_20120206185505]
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_pmon_11152.trc (incident=304110):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /var/local/oracle/diag/rdbms/orcl/orcl/incident/incdir_304110/orcl_pmon_11152_i304110.trc
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_pmon_11152.trc:
ORA-00308: cannot open archived log '/data/assyfile/arch/1_1_774539777.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_pmon_11152.trc:
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
PMON (ospid: 11152): terminating the instance due to error 472
Instance terminated by PMON, pid = 11152
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
--重点是这句,ora-600[4193] 是因为redo 和undo 的块不一致造成。楼主可以尝试重建一下undo 表空间。
2.1 方法一,使用system segment。
在Blog:
Oracle undo 表空间管理
http://blog.csdn.net/tianlesoftware/archive/2010/07/11/5689558.aspx
提到了一种方法,就是使用SYSTEM 的回滚段, 步骤如下:
(1)用spfile 创建pfile,然后修改参数:
#*.undo_tablespace='UNDOTBS1'
#*.undo_management='AUTO'
#*.undo_tablespace
#*.undo_retention
undo_management='MANUAL'
rollback_segments='SYSTEM'
(2)用修改之后的pfile,重启DB
SQL> STARTUP MOUNT pfile='F:/initorcl.ora' ;
(3)删除原来的表空间,创建新的UNDO 表空间
SQL> drop tablespace undotbs;
SQL> create undo tablespace undotbs1 datafile '/u01/oradata/undotbs1.dbf' size 10M;
(4)关闭数据库,修改pfile参数,然后用新的pfile创建spfile,在正常启动数据库。
*.undo_tablespace='UNDOTBS1'
*.undo_management='AUTO'
#undo_management='MANUAL'
#rollback_segments='SYSTEM'具体参考:
Current online Redo 和 Undo 损坏的处理方法
http://blog.csdn.net/tianlesoftware/article/details/6261475