启动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...
请各位给出解决办法,多谢.
解决方案 »
- 送分40分:ORACLE10G有没有象SQL SERVER的企业管理器一样的工具,可以直接查看数据库表中的数据内容
- 如何通过Sql语句将一个数值型字段转化为日期类型
- 求。。。oracle9i与c++应用开发实例
- Oracle SQL问题,请教各位大侠!
- 一个诡异的存储过程
- 日期格式中怎么样去掉分以后的了??
- 如何在oem中创建job!!
- oracle中怎样将字段建成象SQL2000中的ID自动+1的字段
- 关于Oracle Enterprise Manager与Configuration Asistant配置问题?
- ★★★★★救急啊!!!ora_01013:user requested cancel of current operation是怎么回事??ODBC连接Oracle数据库。Open表的时候出错。
- 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;