PC單機最強魔人

1.資料庫莫名其妙關下來看到

Errors in file /oracle10g/admin/TEST/bdump/TEST_smon_10477.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [16], [2], [], [], [], [], []
Thu Apr 12 17:11:11 CST 2012
Errors in file /oracle10g/admin/TEST/bdump/TEST_j000_2117.trc:
ORA-00600: internal error code, arguments: [4194], [16], [2], [], [], [], [], []
Thu Apr 12 17:11:12 CST 2012
DEBUG: Replaying xcb 0xcd86b4d8, pmd 0xcdb090c8 for failed op 8
Doing block recovery for file 2 block 2096
Resuming block recovery (PMON) for file 2 block 2096
Block recovery from logseq 80, block 4082 to scn 3343591
Thu Apr 12 17:11:12 CST 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 80 Reading mem 0
  Mem# 0: /TEST01/redo/redo02.log
  Mem# 1: /TEST01/redo/redo02b.log
Block recovery completed at rba 80.4092.16, scn 0.3343592

2.沒想到UNDO ROLLBACK SEGMENST居然會corrupt

SQL> startup
ORACLE instance started.

Total System Global Area 1895825408 bytes
Fixed Size                  2097176 bytes
Variable Size             436211688 bytes
Database Buffers         1442840576 bytes
Redo Buffers               14675968 bytes
Database mounted.
Database opened.
SQL> create undo tablespace undotbs2 datafile '/TEST01/system/undotbs02.dbf' size 500m;

Tablespace created.


SQL> select TABLESPACE_NAME from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS
UNDOTBS2

6 rows selected.

SQL> alter system set undo_tablespace=undotbs2;

System altered.

SQL> drop tablespace undotbs1;

Tablespace dropped.

SQL>




SQL> select TABLESPACE_NAME from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
TEMP
USERS
UNDOTBS2

3.確認auto undo segment  都改成 UNDOTBS2

SQL> select segment_name,tablespace_name from dba_rollback_segs;

SEGMENT_NAME                   TABLESPACE_NAME
------------------------------ ------------------------------
SYSTEM                         SYSTEM
_SYSSMU41$                     UNDOTBS2
_SYSSMU42$                     UNDOTBS2
_SYSSMU43$                     UNDOTBS2
_SYSSMU34$                     UNDOTBS2
_SYSSMU35$                     UNDOTBS2
_SYSSMU36$                     UNDOTBS2
_SYSSMU37$                     UNDOTBS2
_SYSSMU38$                     UNDOTBS2
_SYSSMU39$                     UNDOTBS2
_SYSSMU40$                     UNDOTBS2

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1895825408 bytes
Fixed Size                  2097176 bytes
Variable Size             436211688 bytes
Database Buffers         1442840576 bytes
Redo Buffers               14675968 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

##記得pfile 改一下 免得開不起來

Errors in file /oracle10g/admin/TEST/udump/TEST_ora_28916.trc:
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Fri Apr 13 09:04:35 CST 2012
Error 30012 happened during db open, shutting down database
USER: terminating instance due to error 30012
Instance terminated by USER, pid = 28916
ORA-1092 signalled during: ALTER DATABASE OPEN..

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1    <-改成UNDOTBS2