启动oracle数据库时报错:SQL> startup;
ORACLE instance started.Total System Global Area 437749616 bytes
Fixed Size 730992 bytes
Variable Size 218103808 bytes
Database Buffers 218103808 bytes
Redo Buffers 811008 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced日志如下:Thu May 20 11:19:04 2010
Starting ORACLE instance (normal)
Thu May 20 11:19:04 2010
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 200
LICENSE_SESSIONS_WARNING = 200
SCN scheme 3
Using log_archive_dest parameter default value
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
processes = 200
sessions = 300
timed_statistics = TRUE
license_max_sessions = 200
license_sessions_warning = 200
shared_pool_size = 184549376
large_pool_size = 0
java_pool_size = 0
control_files = /opt/oracle/oradata/ora92/control01.ctl, /opt/oracle/oradata/ora92/control02.ctl, /opt/oracle/oradata/ora92/control03.ctl
db_block_size = 8192
db_cache_size = 218103808
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 0
undo_management = AUTO
undo_tablespace = UNDOTBS
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = ora92
session_cached_cursors = 200
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/ora92/bdump
user_dump_dest = /opt/oracle/admin/ora92/udump
core_dump_dest = /opt/oracle/admin/ora92/cdump
session_max_open_files = 200
sort_area_size = 524288
db_name = ora92
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 26214400
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Thu May 20 11:19:05 2010
Oracle Data Guard is not available in this edition of Oracle.
Thu May 20 11:19:05 2010
ALTER DATABASE MOUNT
Thu May 20 11:19:09 2010
Successful mount of redo thread 1, with mount id 2031455913
Thu May 20 11:19:09 2010
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu May 20 11:19:09 2010
ALTER DATABASE OPEN
Thu May 20 11:19:10 2010
Beginning crash recovery of 1 threads
Thu May 20 11:19:10 2010
Started recovery at
Thread 1: logseq 9, block 2, scn 0.345293
Thu May 20 11:19:10 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 9 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/ora92/redo02.log
Thu May 20 11:19:10 2010
Completed redo application
Thu May 20 11:19:10 2010
Ended recovery at
Thread 1: logseq 9, block 3, scn 0.365294
0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Thu May 20 11:19:10 2010
Thread 1 advanced to log sequence 10
Thread 1 opened at log sequence 10
Current log# 3 seq# 10 mem# 0: /opt/oracle/oradata/ora92/redo03.log
Successful open of redo thread 1
Thu May 20 11:19:10 2010
SMON: enabling cache recovery
Thu May 20 11:19:10 2010
Errors in file /opt/oracle/admin/ora92/udump/ora92_ora_1182.trc:
ORA-30012: undo tablespace 'UNDOTBS' does not exist or of wrong type
Thu May 20 11:19:10 2010
Error 30012 happened during db open, shutting down database
USER: terminating instance due to error 30012
Instance terminated by USER, pid = 1182
ORA-1092 signalled during: ALTER DATABASE OPEN...
请各位给出解决办法,多谢.
ORACLE instance started.Total System Global Area 437749616 bytes
Fixed Size 730992 bytes
Variable Size 218103808 bytes
Database Buffers 218103808 bytes
Redo Buffers 811008 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced日志如下:Thu May 20 11:19:04 2010
Starting ORACLE instance (normal)
Thu May 20 11:19:04 2010
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 200
LICENSE_SESSIONS_WARNING = 200
SCN scheme 3
Using log_archive_dest parameter default value
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
processes = 200
sessions = 300
timed_statistics = TRUE
license_max_sessions = 200
license_sessions_warning = 200
shared_pool_size = 184549376
large_pool_size = 0
java_pool_size = 0
control_files = /opt/oracle/oradata/ora92/control01.ctl, /opt/oracle/oradata/ora92/control02.ctl, /opt/oracle/oradata/ora92/control03.ctl
db_block_size = 8192
db_cache_size = 218103808
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 0
undo_management = AUTO
undo_tablespace = UNDOTBS
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = ora92
session_cached_cursors = 200
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/ora92/bdump
user_dump_dest = /opt/oracle/admin/ora92/udump
core_dump_dest = /opt/oracle/admin/ora92/cdump
session_max_open_files = 200
sort_area_size = 524288
db_name = ora92
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 26214400
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Thu May 20 11:19:05 2010
Oracle Data Guard is not available in this edition of Oracle.
Thu May 20 11:19:05 2010
ALTER DATABASE MOUNT
Thu May 20 11:19:09 2010
Successful mount of redo thread 1, with mount id 2031455913
Thu May 20 11:19:09 2010
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu May 20 11:19:09 2010
ALTER DATABASE OPEN
Thu May 20 11:19:10 2010
Beginning crash recovery of 1 threads
Thu May 20 11:19:10 2010
Started recovery at
Thread 1: logseq 9, block 2, scn 0.345293
Thu May 20 11:19:10 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 9 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/ora92/redo02.log
Thu May 20 11:19:10 2010
Completed redo application
Thu May 20 11:19:10 2010
Ended recovery at
Thread 1: logseq 9, block 3, scn 0.365294
0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Thu May 20 11:19:10 2010
Thread 1 advanced to log sequence 10
Thread 1 opened at log sequence 10
Current log# 3 seq# 10 mem# 0: /opt/oracle/oradata/ora92/redo03.log
Successful open of redo thread 1
Thu May 20 11:19:10 2010
SMON: enabling cache recovery
Thu May 20 11:19:10 2010
Errors in file /opt/oracle/admin/ora92/udump/ora92_ora_1182.trc:
ORA-30012: undo tablespace 'UNDOTBS' does not exist or of wrong type
Thu May 20 11:19:10 2010
Error 30012 happened during db open, shutting down database
USER: terminating instance due to error 30012
Instance terminated by USER, pid = 1182
ORA-1092 signalled during: ALTER DATABASE OPEN...
请各位给出解决办法,多谢.
解决方案 »
- ORA-12560错误
- Oracle中创建一个带条件查询的存储过程
- 关于MS SQL Server 2000的Enterprise版和Developer版
- DataTabel.PrimaryKey这样设置联合主键为什么不行?
- 在Oracle的一个表上创建一个触发器,在这个触发器中不能再读这个表吗?!!
- 数据导入导出问题
- ORACLE中空串的表示方法?
- oracle 程序连接时的报错,sqlnet.text显示内容
- 朋友需要一个跟oracle有关的用于论文的设计流程说明书,谁能帮我这个忙
- 基本操作问题
- ORACLE 8.1.7与VISTA个人版兼容吗?
- 在PLSQL Developer中用关联查询,找不到想要的资料,请高人帮忙看看
回滚表空间不存在或出错了
回滚表空间不存在或出错
SQL> startup nomount
SQL> alter database mount
SQL> exit2. rman target /
RMAN> restore tablespace undotbs;
RMAN> recover tablespace undotbs;前提是有backup
ORA-30012: undo tablespace 'UNDOTBS' does not exist or of wrong type重新创建UNDO 表空间, 并在初始化文件 pfile 里修改参数undo 参数,保持一致就可以了。 在用pfile 启动数据库就没有问题了。startup pfile=...
那先启动数据库吧
在sqlplus窗口模式下:sql>startup;