ORA-01173

SQL> alter database open; 
alter database open 
* 
ERROR at line 1: 
ORA-01092: ORACLE instance terminated. Disconnection forced

And in the alert log: 


Wed Apr 23 13:08:13 2008 
Errors in file /strdv901/strdv9db/10.2.0/admin/STRDV9_soa048/udump/strdv9_ora_23033.trc: 
ORA-00704: bootstrap process failure 
ORA-00604: error occurred at recursive SQL level 2 
ORA-01173: data dictionary indicates missing data file from system tablespace 
Wed Apr 23 13:08:13 2008 
Error 704 happened during db open, shutting down database 
USER: terminating instance due to error 704 
Wed Apr 23 13:08:13 2008 
Errors in file /strdv901/strdv9db/10.2.0/admin/STRDV9_soa048/bdump/strdv9_mman_23015.trc: 
ORA-00704: bootstrap process failure 
Instance terminated by USER, pid = 23033 
ORA-1092 signalled during: alter database open...


Error:  ORA 1173 
Text:  data dictionary indicates missing data file from system tablespace
-------------------------------------------------------------------------------
Cause:  Either the database has been recovered to a point in time in the future of the control file or a datafile from the system tablespace was omitted from the create control file command previously issued.
Action: For the former problem you need to recover the database from a more recent control file. 
           For the latter problem, simply recreate the  control file checking to be sure that you include all the datafiles in the system tablespace.
SQL> alter database open; 
alter database open 
* 
ERROR at line 1: 
ORA-01092: ORACLE instance terminated. Disconnection forced

And in the alert log: 


Wed Apr 23 13:08:13 2008 
Errors in file /strdv901/strdv9db/10.2.0/admin/STRDV9_soa048/udump/strdv9_ora_23033.trc: 
ORA-00704: bootstrap process failure 
ORA-00604: error occurred at recursive SQL level 2 
ORA-01173: data dictionary indicates missing data file from system tablespace 
Wed Apr 23 13:08:13 2008 
Error 704 happened during db open, shutting down database 
USER: terminating instance due to error 704 
Wed Apr 23 13:08:13 2008 
Errors in file /strdv901/strdv9db/10.2.0/admin/STRDV9_soa048/bdump/strdv9_mman_23015.trc: 
ORA-00704: bootstrap process failure 
Instance terminated by USER, pid = 23033 
ORA-1092 signalled during: alter database open...


Error: ORA 1173 
Text: data dictionary indicates missing data file from system tablespace
-------------------------------------------------------------------------------
Cause: Either the database has been recovered to a point in time in the future of the control file or a datafile from the system tablespace was omitted from the create control file command previously issued.
Action: For the former problem you need to recover the database from a more recent control file. 
 For the latter problem, simply recreate the control file checking to be sure that you include all the datafiles in the system tablespace.

该ORA-01173错误也可能与UNDO损坏相关，需要专家手动Patch undo来修复。

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638   QQ号:47079569    邮箱：[email protected]