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

最新推荐文章于 2021-08-08 12:25:59 发布
转载 最新推荐文章于 2021-08-08 12:25:59 发布 · 1k 阅读 · 1

本文详细记录了Oracle数据库启动时遇到30012错误的排查与解决过程，错误原因是Undo表空间配置不当。通过修改初始化参数文件中的Undo表空间设置，重启数据库后问题得到解决。
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/

cisiling8466
关注
create controlfile重建控制文件报 ORA-01503 ORA-01565 restore resetlogs cdb 后还可以继续recover pdb
jnrjian的博客
07-01 1784
-----常规方法恢复不了---------------------------------------------online redo的重要性----------resetlogs后不能flashback了， 已经recover pdb 是plug上去的------------------------数据文件全部删了试试-----------------------------如果delete obsolete copy 就可以了。------数据文件在的时候新建controlfile。
查oracle事务超时时间,ORA-24756: 事务处理不存在 分析
weixin_33419842的博客
04-03 1641
问题描述：河南在2009年4月28日早09：23出现柜面交易如CDM，FIX，CARDTLR等服务堵塞，且排队不断增加，后通过down掉FIX、CARDTLR服务后使资源得到释放，在事后的分析中，我们发现在出现异常堵塞时，产生了tuxedo和数据库通讯异常的日志，xa_NULL02232009.trc，查看日志内出现问题的pid,发现均为绿卡通的相关服务id日志内容是多个：092345.42108...
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
数据之路-忆梦前程
08-21 6411
记录一次 ORA-30012 ORA-01092错误 由于修改归档路径错了导致数据库startup的时候在spfile里读取LOG_ARCHIVE_DEST错误 ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORA-16032: parameter LOG_ARCHIVE_DEST de
DG方式迁移数据库时由于undo_tablespace参数问题引起的ORA-30012 undo tablespace does not exist or of wrong type
还不算晕的专栏
06-06 1197
DG方式进行数据库迁移切换后，启动数据库时出现报错：ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type 经分析为前一阶段有人为修改undo_tablespace指向的UNDO表空间名字，修改参数为ALTER SYSTEM SET undo_tablespace='UNDOTBS3' SCOPE=BOTH;导致在RAC环境这个修改的优化级是低于drdb1.undo_tablespace='UNDOTBS1'这样指定了实例名
BLOG_LHR_【故障处理】ORA-30012的解决过程.pdf
08-07
BLOG_LHR_【故障处理】ORA-30012的解决过程.pdfBLOG_LHR_【故障处理】ORA-30012的解决过程.pdf
undo表空间丢失ORA-30012
huoyan98的博客
09-03 620
换了一份数据 可以正常mount 但是打开数据库时提示ORA-30012: undo tablespace ‘UNDOTBS1’ does not exist or of wrong type 由于当前数据之前修改过undo表空间对应的数据文件 造成了新安装的Oracle不一致 解决方法 1.shutdown immediate 2.startup mount 3.show param...
ORA-30012 undo tablespace 'UNDOTBS3' does not exist or of wrong type
05-16 363
问题分析：根据错误提示内容为打开UNDO表空间是出错（发现UNDO表空间不存在或者类型错误），所以此时数据应该是可以启动到mount状态 SQL> startup mount; ORACLE instance st...
startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora' ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora ORA-15056: additional error message ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora ORA-15001: diskgroup "DATA" does not exist or is not mounted ORA-06512: at line 4
最新发布
10-18
ORA-15001: diskgroup "DATA" does not exist or is not mounted ``` #### 逐条解释： - `ORA-01078`: 启动数据库时无法处理系统参数 —— 通常是找不到或读取不了 spfile/pfile。 - `ORA-01565`: 识别指定的参数...
oracle ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
ORACLE-爬行
03-19 3411
在手工创建数据库的过程中遇到如下错误： SQL>  @/home/oracle/scripts/create.sql CREATE DATABASE PROD * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-01501: CREATE DATABASE failed
ORACLE建库错误ORA-30012
weixin_34413065的博客
04-07 258
      具体的说，应该是今天凌晨了。      在完成一个数据库的收工建库过程中，发生错误建库失败。检查跟踪文件发现如下错误。ORA-00604: error occurred at recursive SQL level 1ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong typeOffending statem...
ORA-30012错误
清风弄影
08-08 1144
拷贝了dataguard备机虚拟机作一个测试系统。 系统配置好后 SQL> alter database recover managed standby database finish SQL> alter database commit to switchover to primary with session shutdown SQL> shutdown immedaite SQL> startup; 结果遇到ORA-30012错误ORA-30012: undo tablesp
ORA-30012
m15217321304的博客
08-26 670
1、数据库启动报如下错误 SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 27 00:27:05 2018 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SP2-0310: unable to open fi...
关于undo表空间配置错误的ORA-30012
weixin_30580943的博客
05-18 246
版权声明：本文为博主原创文章，欢迎扩散，扩散请务必注明出处。 https://blog.youkuaiyun.com/robinson_0612/article/details/24454513 ...
Oracle undo 表空间不可用
a77687789的博客
06-28 277
　　 　　由于某次不小心操作，在切换表空间时没有成功，由于把undo的配置参数 undo_management值设置为MANUAL所以在启动数据库时没有报任何错误，但是给表插入数据时报错了，回滚段不可用的错误。然后查询了错误原因。 　　 　　1 首先看数据库中undo信息 　　 SQL> show parameter undo; NAME TYPE VALUE-----...
oracle-ora-30012报错 000851报错
heartsea2016's home
06-13 571
oracle-ora-30012报错 数据库startup启动报错，30012，于是有了下面的操作。 1 查询alter的日志位置。 show parameter background_dump_dest; 查询alter的日志 发现有正确的UNDOTBS2 2 找到pfile 文件夹 有一个带有一堆数字的ora的文件，mv 为 initorcl.ora 并且复制到$ORACLE_HOME/dbs下面 3 启动数据库 startup mount create spfile from pfile 4 修改 o
“ORA-30012"故障
cuanwuqian6695的博客
03-25 369
创建数据库时一直出现问题，多次检查和修改脚本都没用，最后google了很多案例，找到了答案。 SQL> @D:\oraclexe\app\oracle\admin\ora10g\create\create...
Enter user-name: system Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options DROP USER PLMEE CASCADE * ERROR at line 1: ORA-01918: user 'PLMEE' does not exist DROP TABLESPACE PLMEE_DATA INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS * ERROR at line 1: ORA-00959: tablespace 'PLMEE_DATA' does not exist DROP TABLESPACE PLMEE_TEMP INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS * ERROR at line 1: ORA-00959: tablespace 'PLMEE_TEMP' does not exist CREATE TABLESPACE PLMEE_DATA DATAFILE 'D:\Oracle\oradata\PLM_DATA' SIZE 100M AUTOEXTEND ON NEXT 10M * ERROR at line 1: ORA-01119: error in creating database file 'D:\Oracle\oradata\PLM_DATA' ORA-27038: created file already exists OSD-04010: <create> option specified, file already exists CREATE TEMPORARY TABLESPACE PLMEE_TEMP TEMPFILE 'D:\Oracle\oradata\PLM_TEMP' SIZE 100M AUTOEXTEND ON NEXT 10M * ERROR at line 1: ORA-01119: error in creating database file 'D:\Oracle\oradata\PLM_TEMP' ORA-27038: created file already exists OSD-04010: <create> option specified, file already exists ALTER TABLESPACE PLMEE_DATA ADD DATAFILE 'E:\app\dba\oradata\PLMEE01_data' SIZE 100M AUTOEXTEND ON NEXT 10M * ERROR at line 1: ORA-00959: tablespace 'PLMEE_DATA' does not exist ALTER TABLESPACE PLMEE_DATA ADD DATAFILE 'E:\app\dba\oradata\PLMEE02_data' SIZE 100M AUTOEXTEND ON NEXT 10M * ERROR at line 1: ORA-00959: tablespace 'PLMEE_DATA' does not exist ALTER TABLESPACE PLMEE_DATA ADD DATAFILE 'E:\app\dba\oradata\PLMEE03_data' SIZE 100M AUTOEXTEND ON NEXT 10M * ERROR at line 1: ORA-00959: tablespace 'PLMEE_DATA' does not exist ALTER TABLESPACE PLMEE_DATA ADD DATAFILE 'E:\app\dba\oradata\PLMEE04_data' SIZE 100M AUTOEXTEND ON NEXT 10M * ERROR at line 1: ORA-00959: tablespace 'PLMEE_DATA' does not exist ALTER TABLESPACE PLMEE_DATA ADD DATAFILE 'E:\app\dba\oradata\PLMEE05_data' SIZE 100M AUTOEXTEND ON NEXT 10M * ERROR at line 1: ORA-00959: tablespace 'PLMEE_DATA' does not exist CREATE USER PLMEE IDENTIFIED BY PLMEE DEFAULT TABLESPACE PLMEE_DATA TEMPORARY TABLESPACE PLMEE_TEMP * ERROR at line 1: ORA-00959: tablespace 'PLMEE_DATA' does not exist GRANT CONNECT,RESOURCE TO PLMEE * ERROR at line 1: ORA-01917: user or role 'PLMEE' does not exist ALTER USER PLMEE QUOTA UNLIMITED ON PLMEE_DATA * ERROR at line 1: ORA-01918: user 'PLMEE' does not exist ALTER USER PLMEE QUOTA UNLIMITED ON PLM_DATA * ERROR at line 1: ORA-01918: user 'PLMEE' does not exist ALTER USER PLMEE QUOTA UNLIMITED ON USERS * ERROR at line 1: ORA-01918: user 'PLMEE' does not exist old 1: CREATE OR REPLACE DIRECTORY DUMP_DIR AS '&1' new 1: CREATE OR REPLACE DIRECTORY DUMP_DIR AS 'D:\dbInit\' Directory created. GRANT READ,WRITE ON DIRECTORY DUMP_DIR TO PLMEE * ERROR at line 1: ORA-01917: user or role 'PLMEE' does not exist Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options create user and make directory finished...
08-28
ORA-00959: tablespace 'PLMEE_DATA' does not exist ``` ### 3. 文件已存在： ```sql ORA-01119: error in creating database file ORA-27038: created file already exists ``` --- ## ✅ 问题分析与解决方案 ...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符  | 博主筛选后可见
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值