ora-01219 数据库未打开:仅允许在固定的表/视图查询 问题如题,前几天上班数据库还是好好的,今天来了就出现这个问题。上网搜了下解决方案,都没有找到合适的解决途径~~ 望高手指点 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 数据库没开,即不在OPEN状态吧。 先shutdown immediate再startup 你的database中的某个表空间肯定出问题了。看看alert.log里边的详细提示信息 这是我的 alter.log 中的内容 看不出哪有问题~ Dump file d:\oracle\admin\orac\bdump\alert_orac.logTue Apr 08 09:47:48 2008ORACLE V9.2.0.6.0 - Production vsnsta=0vsnsql=12 vsnxtr=3Windows 2000 Version 5.1 Service Pack 2, CPU type 586Tue Apr 08 09:47:48 2008Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0SCN scheme 2Using log_archive_dest parameter default valueLICENSE_MAX_USERS = 0SYS auditing is disabledStarting up ORACLE RDBMS Version: 9.2.0.6.0.System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 109051904 large_pool_size = 58720256 java_pool_size = 109051904 control_files = D:\oracle\oradata\Orac\control01.ctl, D:\oracle\oradata\Orac\control02.ctl, D:\oracle\oradata\Orac\control03.ctl db_block_size = 8192 db_cache_size = 109051904 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 remote_login_passwordfile= EXCLUSIVE db_domain = instance_name = Orac dispatchers = (PROTOCOL=TCP) (SERVICE=OracXDB) job_queue_processes = 10 hash_join_enabled = TRUE background_dump_dest = D:\oracle\admin\Orac\bdump user_dump_dest = D:\oracle\admin\Orac\udump core_dump_dest = D:\oracle\admin\Orac\cdump sort_area_size = 524288 db_name = Orac open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 25165824 aq_tm_processes = 1PMON started with pid=2DBW0 started with pid=3LGWR started with pid=4CKPT started with pid=5SMON started with pid=6RECO started with pid=7CJQ0 started with pid=8QMN0 started with pid=9Tue Apr 08 09:47:51 2008starting up 1 shared server(s) ...starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...Tue Apr 08 09:47:51 2008alter database mount exclusive Tue Apr 08 09:47:56 2008Successful mount of redo thread 1, with mount id 918940807Tue Apr 08 09:47:56 2008Database mounted in Exclusive Mode.Completed: alter database mount exclusiveTue Apr 08 09:47:56 2008alter database openTue Apr 08 09:47:56 2008Beginning crash recovery of 1 threadsTue Apr 08 09:47:56 2008Started redo scanTue Apr 08 09:47:56 2008Errors in file d:\oracle\admin\orac\udump\orac_ora_1812.trc:ORA-00313: ??????? 2 (?? 1) ???ORA-00312: ???? 2 ?? 1: 'D:\ORACLE\ORADATA\ORAC\REDO02.LOG'ORA-27041: ??????OSD-04002: 无法打开文件O/S-Error: (OS 2) 系统找不到指定的文件。ORA-313 signalled during: alter database open...Tue Apr 08 09:48:45 2008alter database backup controlfile to traceCompleted: alter database backup controlfile to traceTue Apr 08 09:53:53 2008Restarting dead background process QMN0QMN0 started with pid=9Tue Apr 08 09:59:56 2008Restarting dead background process QMN0QMN0 started with pid=9Tue Apr 08 10:06:00 2008Restarting dead background process QMN0QMN0 started with pid=9Tue Apr 08 10:12:03 2008Restarting dead background process QMN0QMN0 started with pid=9Tue Apr 08 10:18:03 2008Restarting dead background process QMN0QMN0 started with pid=9Tue Apr 08 10:24:06 2008Restarting dead background process QMN0QMN0 started with pid=9Tue Apr 08 10:30:09 2008Restarting dead background process QMN0QMN0 started with pid=9Tue Apr 08 10:36:12 2008Restarting dead background process QMN0QMN0 started with pid=9Tue Apr 08 10:40:07 2008alter database openTue Apr 08 10:40:07 2008Beginning crash recovery of 1 threadsTue Apr 08 10:40:08 2008Started redo scanTue Apr 08 10:40:08 2008Errors in file d:\oracle\admin\orac\udump\orac_ora_2316.trc:ORA-00313: 无法打开日志组 2 (线程 1) 的成员ORA-00312: 联机日志 2 线程 1: 'D:\ORACLE\ORADATA\ORAC\REDO02.LOG'ORA-27041: 无法打开文件OSD-04002: 无法打开文件O/S-Error: (OS 2) 系统找不到指定的文件。ORA-313 signalled during: alter database open...Tue Apr 08 10:42:15 2008Restarting dead background process QMN0QMN0 started with pid=9Tue Apr 08 10:48:12 2008Restarting dead background process QMN0QMN0 started with pid=9 ORA-00312: 联机日志 2 线程 1: 'D:\ORACLE\ORADATA\ORAC\REDO02.LOG'ORA-27041: 无法打开文件OSD-04002: 无法打开文件 REDO02.LOG删掉,吧REDO01.LOG考过来,改名为REDO02.LOG,然后startup resetlog打开,操作前后对数据库进行备份!打开后备份好后就可以吧原来的归档日志全部删除!一定记住做好备份 oracle 要实现这样结果的sql语句应该怎么写 哪位达人能告诉我为什么两台配置一样的服务器同样的sql执行计划不一致? 如何查看已有表的分区条件? sql问题 在ASP中,如何存取大容量字符! 请教sql loader-direct path oracle xe 中文问题100分求助 not exists函数问题!!!!!!!!!!!!!!! 如果你想在SAPDBA中改组DB,应该运行在数据库的什么模式上? 怎样用sql语句drop表里的一个字段? 请在一个Oracle问题 dba_snapshotS中的意思?
这是我的 alter.log 中的内容 看不出哪有问题~
Dump file d:\oracle\admin\orac\bdump\alert_orac.log
Tue Apr 08 09:47:48 2008
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Tue Apr 08 09:47:48 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 109051904
large_pool_size = 58720256
java_pool_size = 109051904
control_files = D:\oracle\oradata\Orac\control01.ctl, D:\oracle\oradata\Orac\control02.ctl, D:\oracle\oradata\Orac\control03.ctl
db_block_size = 8192
db_cache_size = 109051904
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = Orac
dispatchers = (PROTOCOL=TCP) (SERVICE=OracXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\Orac\bdump
user_dump_dest = D:\oracle\admin\Orac\udump
core_dump_dest = D:\oracle\admin\Orac\cdump
sort_area_size = 524288
db_name = Orac
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
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
Tue Apr 08 09:47:51 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Apr 08 09:47:51 2008
alter database mount exclusive
Tue Apr 08 09:47:56 2008
Successful mount of redo thread 1, with mount id 918940807
Tue Apr 08 09:47:56 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Apr 08 09:47:56 2008
alter database open
Tue Apr 08 09:47:56 2008
Beginning crash recovery of 1 threads
Tue Apr 08 09:47:56 2008
Started redo scan
Tue Apr 08 09:47:56 2008
Errors in file d:\oracle\admin\orac\udump\orac_ora_1812.trc:
ORA-00313: ??????? 2 (?? 1) ???
ORA-00312: ???? 2 ?? 1: 'D:\ORACLE\ORADATA\ORAC\REDO02.LOG'
ORA-27041: ??????
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。ORA-313 signalled during: alter database open...
Tue Apr 08 09:48:45 2008
alter database backup controlfile to trace
Completed: alter database backup controlfile to trace
Tue Apr 08 09:53:53 2008
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Apr 08 09:59:56 2008
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Apr 08 10:06:00 2008
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Apr 08 10:12:03 2008
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Apr 08 10:18:03 2008
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Apr 08 10:24:06 2008
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Apr 08 10:30:09 2008
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Apr 08 10:36:12 2008
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Apr 08 10:40:07 2008
alter database open
Tue Apr 08 10:40:07 2008
Beginning crash recovery of 1 threads
Tue Apr 08 10:40:08 2008
Started redo scan
Tue Apr 08 10:40:08 2008
Errors in file d:\oracle\admin\orac\udump\orac_ora_2316.trc:
ORA-00313: 无法打开日志组 2 (线程 1) 的成员
ORA-00312: 联机日志 2 线程 1: 'D:\ORACLE\ORADATA\ORAC\REDO02.LOG'
ORA-27041: 无法打开文件
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。ORA-313 signalled during: alter database open...
Tue Apr 08 10:42:15 2008
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Apr 08 10:48:12 2008
Restarting dead background process QMN0
QMN0 started with pid=9
ORA-27041: 无法打开文件
OSD-04002: 无法打开文件