解决方案 »
- 如何让oracle还原成刚安装完oracle的状态哈?之前不小心复制了一些sql现在oracle出问题了想恢复成刚安装的状态!求大神解答,在线等人气伺候着!!!
- sql优化
- 求MyEclipse连接Oracle9i的驱动
- 查询结果的顺序
- 根据现有字段select出新字段问题~,颇实用的,但是想不出哈哈~
- Oracle 如何快速查询 表里的数据? 急~~~~
- 如何使用PLSQL向ORACLE里插入图片?
- 数据集 结果替换
- 几组不同写法的SQL语句,大家来看看哪种执行快? 3ks
- 问高人存储过程每月执行一次,运用的是带参数的过程如何更改。特急!
- ora-01406:提取的列值被阶段
- Oracle存储过程
Online log /opt/oracle/oradata/ods/redo01.log: Thread 1 Group 1 was previously cleared
Online log /opt/oracle/oradata/ods/redo02.log: Thread 1 Group 2 was previously cleared
Online log /opt/oracle/oradata/ods/redo03.log: Thread 1 Group 3 was previously cleared
Thu Nov 20 00:23:37 2014
Setting recovery target incarnation to 2
Thu Nov 20 00:23:37 2014
Assigning activation ID 133490475 (0x7f4e72b)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /opt/oracle/oradata/ods/redo01.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Nov 20 00:23:37 2014
SMON: enabling cache recovery
Errors in file /opt/oracle/diag/rdbms/ods/ods/trace/ods_ora_8665.trc:
ORA-01173: data dictionary indicates missing data file from system tablespace
Errors in file /opt/oracle/diag/rdbms/ods/ods/trace/ods_ora_8665.trc:
ORA-01173: data dictionary indicates missing data file from system tablespace
Error 1173 happened during db open, shutting down database
USER (ospid: 8665): terminating the instance due to error 1173
Instance terminated by USER, pid = 8665
ORA-1092 signalled during: alter database open resetlogs...
opiodr aborting process unknown ospid (8665) as a result of ORA-1092
Thu Nov 20 00:23:39 2014
ORA-1092 : opitsk aborting process