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来修复。
Leave a Reply