ORA-00376 ORA-01110

Question

SQL> show parameter undo;NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDO02
SQL> shutdown immediate;ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/oracle/app/oracle/oradata/orcl/undotbs01.dbf'
   undotbs01 我已经替换成undo02 了啊 怎么还报以上这个错误

Answer 1

    不能直接替换.
    应该先offline,删除undotbs01后，再创建undo02.