ORA-01157 ORA-01110 ORA-01548 Oracle误删undo数据文件-白红宇的个人博客

发布日期：2021-05-14 17:50:55 浏览次数：21 分类：精选文章

本文共 2707 字，大约阅读时间需要 9 分钟。

��3��undo��

��o1_mf_undotbs1_cvdwnl7t_.dbf��DBWR trace��

��

��

SQL> SELECT OPEN_MODE FROM V$DATABASE;

��

��

��

SQL> ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/SYD/datafile/o1_mf_undotbs1_cvdwnl7t_.dbf' OFFLINE;

��

��undo��

��undo��undo��"/u01/app/oracle/oradata/SYD/datafile/undotbs01"��undo��

SQL> CREATE UNDO TABLESPACE "UNDOTBS2" DATAFILE '/u01/app/oracle/oradata/SYD/datafile/undotbs01' SIZE 10m autoextend on;

��undo��undo��

SQL> ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS2 SCOPE=both;

��Equivalent��undo��

��undo��

��undo��

SQL> DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;

��

��
```
SQL> SELECT SEGMENT_NAME, TABLESPACE_NAME, STATUS FROM DBA_ROLLBACK_SEGS;
```

��

��

SQL> STARTUP;

Database mounted subsequentement��

��undo��

上一篇：合理控制oracle数据库具有DBA权限的用户

下一篇：oracle11g建库后创建EM

关于作者

喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！

-- 愿君每日到此一游！