[紧急求助]01092错误，datafile一直处于recover状态！

freebarque

SQL> alter system set undo_management = manual scope=both
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> alter database datafile  'YOUR/UNDO/PATH/FILE.dbf'  offline drop;
SQL> ALTER DATABASE OPEN;
SQL> DROP TABLESPACE UNDOTBS1;
SQL> create UNDO tablespace undotbs1 DATAFILE 'YOUR/NEW/UNDO/FILE.DBF'  SIZE=XXXM AUTOEXTENT ON ;
SQL> alter system set undo_management = AUTO SCOPE=spfile;
SQL> SHUTDOWN IMMEDIATE;
SQL>  STARTUP;