ORA-30012: undo tablespace 'UNDO_TBS' does not exist or of wrong type

oracle applications clone不成功导致30012错误，具体原因还未能查明，解决步骤如下：[@more@]

[oraprod@erp ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Aug 27 13:56:31 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 599785472 bytes
Fixed Size 1262176 bytes
Variable Size 427822496 bytes
Database Buffers 159383552 bytes
Redo Buffers 11317248 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

alert中错误信息如下：

Errors in file /u01/oracle/PROD/db/tech_st/10.2.0/admin/PROD_erp/udump/prod_ora_4485.trc:
ORA-30012: undo tablespace 'UNDO_TBS' does not exist or of wrong type
Mon Aug 27 13:57:01 2007
Error 30012 happened during db open, shutting down database
USER: terminating instance due to error 30012
Instance terminated by USER, pid = 4485
ORA-1092 signalled during: ALTER DATABASE OPEN...

SQL> startup mount
ORACLE instance started.

Total System Global Area 599785472 bytes
Fixed Size 1262176 bytes
Variable Size 427822496 bytes
Database Buffers 159383552 bytes
Redo Buffers 11317248 bytes
Database mounted.
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/oracle/PROD/db/apps_st/data/system01.dbf
/u01/oracle/PROD/db/apps_st/data/system02.dbf
/u01/oracle/PROD/db/apps_st/data/system03.dbf
/u01/oracle/PROD/db/apps_st/data/system04.dbf
/u01/oracle/PROD/db/apps_st/data/system05.dbf
/u01/oracle/PROD/db/apps_st/data/ctxd01.dbf
/u01/oracle/PROD/db/apps_st/data/owad01.dbf
/u01/oracle/PROD/db/apps_st/data/a_queue02.dbf
/u01/oracle/PROD/db/apps_st/data/odm.dbf
/u01/oracle/PROD/db/apps_st/data/olap.dbf
/u01/oracle/PROD/db/apps_st/data/sysaux01.dbf

NAME
--------------------------------------------------------------------------------
/u01/oracle/PROD/db/apps_st/data/apps_ts_tools01.dbf
/u01/oracle/PROD/db/apps_st/data/system12.dbf
/u01/oracle/PROD/db/apps_st/data/a_txn_data04.dbf
/u01/oracle/PROD/db/apps_st/data/a_txn_ind06.dbf
/u01/oracle/PROD/db/apps_st/data/a_ref03.dbf
/u01/oracle/PROD/db/apps_st/data/a_int02.dbf
/u01/oracle/PROD/db/apps_st/data/sysaux02.dbf
/u01/oracle/PROD/db/apps_st/data/olap01.dbf
/u01/oracle/PROD/db/apps_st/data/system10.dbf
/u01/oracle/PROD/db/apps_st/data/system06.dbf
/u01/oracle/PROD/db/apps_st/data/portal01.dbf

NAME
--------------------------------------------------------------------------------
/u01/oracle/PROD/db/apps_st/data/system07.dbf
/u01/oracle/PROD/db/apps_st/data/system09.dbf
/u01/oracle/PROD/db/apps_st/data/system08.dbf
/u01/oracle/PROD/db/apps_st/data/system11.dbf
/u01/oracle/PROD/db/apps_st/data/undo01.dbf
/u01/oracle/PROD/db/apps_st/data/a_txn_data01.dbf
/u01/oracle/PROD/db/apps_st/data/a_txn_ind01.dbf
/u01/oracle/PROD/db/apps_st/data/a_ref01.dbf
/u01/oracle/PROD/db/apps_st/data/a_int01.dbf
/u01/oracle/PROD/db/apps_st/data/a_summ01.dbf
/u01/oracle/PROD/db/apps_st/data/a_nolog01.dbf

NAME
--------------------------------------------------------------------------------
/u01/oracle/PROD/db/apps_st/data/a_archive01.dbf
/u01/oracle/PROD/db/apps_st/data/a_queue01.dbf
/u01/oracle/PROD/db/apps_st/data/a_media01.dbf
/u01/oracle/PROD/db/apps_st/data/a_txn_data02.dbf
/u01/oracle/PROD/db/apps_st/data/a_txn_data03.dbf
/u01/oracle/PROD/db/apps_st/data/a_txn_ind02.dbf
/u01/oracle/PROD/db/apps_st/data/a_txn_ind03.dbf
/u01/oracle/PROD/db/apps_st/data/a_txn_ind04.dbf
/u01/oracle/PROD/db/apps_st/data/a_txn_ind05.dbf
/u01/oracle/PROD/db/apps_st/data/a_ref02.dbf

43 rows selected.

SQL> show parameter undo

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
undo_management string
AUTO
undo_retention integer
900
undo_tablespace string
UNDO_TBSSQL> select name from v$tablespace;

NAME
--------------------------------------------------------------------------------
SYSTEM
SYSAUX
CTXD
APPS_TS_TX_DATA
APPS_TS_TX_IDX
OWAPUB
APPS_TS_QUEUES
ODM
OLAP
APPS_TS_TOOLS
APPS_TS_SEED

NAME
--------------------------------------------------------------------------------
APPS_TS_INTERFACE
PORTAL
APPS_UNDOTS1APPS_TS_SUMMARY
APPS_TS_NOLOGGING
APPS_TS_ARCHIVE
APPS_TS_MEDIA
TEMP1
TEMP2

20 rows selected.

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

经检查得知undo表空间为APPS_UNDOTS1而不是UNDO_TBS

解决办法--修改init文件，将undo tablespace改为apps_undots1

重新启动数据库

SQL> startup
ORACLE instance started.

Total System Global Area 599785472 bytes
Fixed Size 1262176 bytes
Variable Size 427822496 bytes
Database Buffers 159383552 bytes
Redo Buffers 11317248 bytes
Database mounted.
Database opened.

ok

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

转载于:http://blog.itpub.net/594850/viewspace-966386/