当前位置：首页 -> 基础 -> 数据库编程

ora-4193/4194故障处理一则(二)

2014-11-24 09:16:54 · 作者: · 浏览: 3
标签: ora-4193/4194 故障 处理 一则
1 09:50:53 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0
Mem# 0 errs 0: /oracle/oradata/lixora/redo01.log
Block recovery completed at rba 2.76.16, scn 0.5650685
Doing block recovery for file 2 block 105
Block recovery from logseq 2, block 73 to scn 5650895
Mon Oct 21 09:50:53 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0
Mem# 0 errs 0: /oracle/oradata/lixora/redo01.log
Block recovery completed at rba 2.350.16, scn 0.5650896
Mon Oct 21 09:51:07 2013
Errors in file /oracle/admin/lixora/udump/lixora_ora_8410.trc:
ORA-00600: internal error code, arguments: [4194], [21], [28], [], [], [], [], []
Mon Oct 21 09:51:07 2013
Errors in file /oracle/admin/lixora/udump/lixora_ora_8408.trc:
ORA-00600: internal error code, arguments: [4193], [1620], [1623], [], [], [], [], []
Mon Oct 21 09:51:12 2013
Doing block recovery for file 2 block 172
----尝试直接设置了下面参数，数据库就意外的open成功，这位朋友比较幸运
undo_tablespace=SYSTEM
undo_management=MANUAL
既然库已经open，然后新建undo空间，删除出问题的undo，做如下修改，数据库恢复完成
undo_tablespace=新undo
undo_management=AUTO
如果出现极端的情况可能需要做如下处理:
1.使用_offline_rollback_segments和_corrupted_rollback_segments屏蔽掉有问题的undo segment
2.继续可能出现ora-600[2662]，需要推进scn 
SQL> create pfile='/tmp/pfile.ora'  from spfile;
File created.
SQL>






 shutdown immediate
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [3393], [3397], [], [], [],
[], []

SQL> shutdow abort
ORACLE instance shut down.
SQL> startup pfile='/tmp/pfile.ora'
ORACLE instance started.
Total System Global Area  583008256 bytes
Fixed Size                  2022504 bytes
Variable Size             184550296 bytes
Database Buffers          394264576 bytes
Redo Buffers                2170880 bytes
Database mounted.
Database opened.
SQL> 
SQL> 
SQL> 
SQL> select * from dual;
D
-
X

-----创建新的undo 表空间 undotbs02 
SQL> create undo tablespace undotbs02
  2  datafile '/oracle/oradata/lixora/undotbs02.dbf'   
  3  size 50M
  4   EXTENT MANAGEMENT local;
Tablespace created.
SQL> alter system set undo_tablespace=undotbs02;    ------------注意这里不能直接设置，因为使用的是pfile
alter system set undo_tablespace=undotbs02
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-30014: operation only supported in Automatic Undo Management mode

SQL> alter system set undo_tablespace=undotbs02 scope=spfile;
alter system set undo_tablespace=undotbs02 scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup

SQL> shutdwon immediate
SP2-0734: unknown command beginning "shutdwon i..." - rest of line ignored.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

---编辑pfile
[oracle@localhost lixora]$ vi /tmp/pfile.ora
lixora.__db_cache_size=394264576
lixora.__java_pool_size=4194304
lixora.__large_pool_size=4194304
lixora.__shared_pool_size=171966464
lixora.__streams_pool_size=4194304
#*._allow_resetlogs_corruption=TRUE
*.audit_file_dest='/oracle/admin/lixora/adump'
*.background_dump_dest='/oracle/admin/lixora/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/oracle/oradata/lixora/control01.ctl','/oracle/oradata/lixora/control02.ct