You start up the database and receive the following error message:
SQL> startup
ORACLE instance started.
Total System Global Area 252478536 bytes
Fixed Size 279624 bytes
Variable Size 167772160 bytes
Database Buffers 83886080 bytes
Redo Buffers 540672 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
No background processes are started.
ORA-01092: Oracle instance terminated. Disconnection forced
Cause: The instance connected to was terminated abnormally, probably
due to a SHUTDOWN ABORT. The current process was forced to
disconnect from the instance.
Action: Contact the database administrator to determine when the
instance is restarted. Attempt to reconnect after the instance
is running again.
Solution Description
--------------------
In the alert.log file there is additional information on the error context:
SMON: enabling cache recovery
Thu Aug 2 14:19:45 2001
Errors in file /ora/ora901/admin/V901/udump/v901_ora_21863.trc:
ORA-30012: undo tablespace 'UNDO1' does not exist or of wrong type
Thu Aug 2 14:19:45 2001
Error 30012 happened during db open, shutting down database
USER: terminating instance due to error 30012
Instance terminated by USER, pid = 21863
ORA-1092 signalled during: ALTER DATABASE OPEN...
You have three options to resolve this issue:
1. If an UNDO tablespace currently exists in the database, edit the
init.ora file to set the UNDO_TABLESPACE parameter to the name of the
existing UNDO tablespace and restart the database.
- OR -
2. If no UNDO tablespace exists, edit the init.ora file to comment out
the UNDO_MANAGEMENT parameter: the default value for UNDO_MANAGEMENT is
MANUAL.
Then, after starting the database, do one of the following:
A. Create a non UNDO tablespace with at least one online rollback
segment.
The instance can work this way.
-OR-
B. Create a new UNDO tablespace.
If you want the instance to work under Automatic Undo Management,
a. Set the UNDO_MANAGEMENT back to AUTO
b. Set the UNDO_TABLESPACE parameter to the name of the new UNDO
tablespace
c. Restart the database
Explanation
-----------
The database is using Automatic Undo Management (AUM). In the init.ora
file, the parameter UNDO_MANAGEMENT is set to AUTO and UNDO_TABLESPACE to a
tablespace that does not exist or is not an UNDO type tablespace.
References
----------Managing Rollback/Undo Segments in AUM (Automatic Undo
Management)9i: ORA-01552 Though Non-System Rollback Segments can be
Onlined
@ DEFAULT NAME FOR UNDO TABLESPACE SHOULD BE TAKEN FROM
@ PARAMETER UNDO_TABLESPACE
Search Words
------------
ORA-1092[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24214296/viewspace-1035286/,如需转载,请注明出处,否则将追究法律责任。