undodbs出现坏块

alte日志信息：
Mon Nov 26 09:20:20 2007
Errors in file /oracle/app/oracle/admin/orcl/bdump/orcl_smon_5611.trc:
ORA-01578: Message 1578 not found; No message file for product=RDBMS, facility=ORA; arguments: [2] [12767]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [2] [/oracle/oradata/orcl/undotbs01.dbf]

orcl_smon_5611.trc文件信息：
/oracle/app/oracle/admin/orcl/bdump/orcl_smon_5611.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/app/oracle/product/10.2.0/Database
System name: Linux
Node name: tonykorn97
Release: 2.6.9-42.ELsmp
Version: #1 SMP Wed Jul 12 23:27:17 EDT 2006
Machine: i686
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 5611, image: oracle@tonykorn97 (SMON)

*** 2007-11-23 13:29:14.152
*** SERVICE NAME:() 2007-11-23 13:29:14.152
*** SESSION ID:(164.1) 2007-11-23 13:29:14.152
Parallel Transaction recovery caught exception 1578
Parallel Transaction recovery caught error 1578
*** 2007-11-23 13:29:14.154
SMON: following errors trapped and ignored:
ORA-01578: Message 1578 not found; No message file for product=RDBMS, facility=ORA; arguments: [2] [12767]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [2] [/oracle/oradata/orcl/undotbs01.dbf]
*** 2007-11-23 13:34:18.002
Parallel Transaction recovery caught exception 1578
Parallel Transaction recovery caught error 1578
*** 2007-11-23 13:34:18.006

做chekcpoint:
Mon Nov 26 09:23:58 2007
Thread 1 cannot allocate new log, sequence 374
Private strand flush not complete
Current log# 3 seq# 373 mem# 0: /oracle/oradata/orcl/redo03.log
Thread 1 advanced to log sequence 374
Current log# 1 seq# 374 mem# 0: /oracle/oradata/orcl/redo01.log

创建一个新的undodbs:
create undo tablespace UNDOTBS2 datafile '/oracle/oradata/orcl/undotbs02.dbf' size 1024M;

调整默认dbs
alter system set undo_tablespace=UNDOTBS2;

drop tablespace undotbs1;

查看默认dbs
SQL> show parameter undo_tablespace

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_tablespace string UNDOTEMP

删除undotbs1
SQL> drop tablespace undotbs1;
drop tablespace undotbs1
*
ERROR at line 1:
ORA-30013: undo tablespace 'UNDOTBS1' is currently in use

SQL>

重启后删除报错：
SQL> drop tablespace undotbs1;
drop tablespace undotbs1
*
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU1$' found, terminate dropping
tablespace

SQL>

看到网上应该有9i这样的问题，需要添加参数。但是这个版本是10G的，不敢使用，exp导出后重建 。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/312079/viewspace-245810/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/312079/viewspace-245810/