ORA-01092 error starting database (urgent, please) [message #101105] |
Tue, 04 May 2004 00:17 |
Giuseppe Garzotto
Messages: 8 Registered: November 2002
|
Junior Member |
|
|
Hello everybody,
Oracle 9i on Windows 2000 SP4.
Due to a scandisk, the undo tablespace's datafile
result corrupt and now it have size 0.
So, my Oracle Server doesn't start completely.
Looking for a solutions in various internet forums, I
perform the following action:
E:> sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown abort
SQL> startup
SQL> alter database datafile 'e:oracleora92orclundotbs01.dbf' offline drop;
SQL> shutdown
SQL> startup
At the end of startup, the database is mounted but I
get an ORA-01092: ORACLE instance terminated. Forced
disconnection error.
I try to recreate the undo tablespace with a command
similar to the one found in createdb.sql, but the
database is not open, so the command wasn't accepted.
I also try, after reading this,
http://www.dbasupport.com/oracle/ora9i/undo.shtml
to put undo_management=MANUAL and undo_tablespace=
in the init.ora file, but I get back the same error.
My question is: it is possible to start the database
without the undo tablespace, and then recreate the
undo tablespace when the database is started ?
Thanks a lot in advice
Giuseppe Garzotto
|
|
|
|
Re: ORA-01092 error starting database (urgent, please) [message #101347 is a reply to message #101105] |
Sat, 21 August 2004 14:34 |
Stephen
Messages: 26 Registered: January 2000
|
Junior Member |
|
|
I got the same trouble.
It took me about two days to bring
it back.
Here is the way.
1. recover the undo tablespace datafile . I was promp for log file options: filename,
auto, cancel. after try all of these I just
hit the return, I got recover completed.
After that I still got same error when I try to open the database.
I almost gived it up. Then I tried this.
startup mount
SQL> alter database datafile 'F:ORACLEORADATAMP415UNDOTBS01.DBF' online
Database altered.
SQL> select name, status from v$datafile;
NAME
---------------------------------------------------------------------------
STATUS
-------
F:ORACLEORADATAMP415SYSTEM01.DBF
SYSTEM
F:ORACLEORADATAMP415UNDOTBS01.DBF
ONLINE
........
11 rows selected.
SQL> alter database open;
Database altered.
If you have any question send me a email.
good luck!
|
|
|