系统UNDO表空间的重建

来源：互联网发布：java消息队列视频教程编辑：程序博客网时间：2024/04/29 08:56

--1. 创建新的UNDO表空间
CREATE UNDO TABLESPACE "UNDOTEMP"
DATAFILE 'G:/ORACLE/ORADATA/HOME/UNDOTEMP.ora' SIZE 5M
/

--2. 在OEM控制台修改系统默认的UNDO表空间名, 由UNDOTBS改为UNDOTEMP, 或通过下面的命令修改默认UNDO表空间的标识
ALTER SYSTEM SET UNDO_TABLESPACE = UNDOTEMP
/

--3. 删除原来的系统默认UNDO表空间, 并重建UNDOTBS
DROP TABLESPACE "UNDOTBS" INCLUDING CONTENTS AND DATAFILES
/

CREATE UNDO TABLESPACE "UNDOTBS"
DATAFILE 'G:/ORACLE/ORADATA/HOME/UNDOTBS01.DBF' SIZE 200M
AUTOEXTEND ON NEXT 4096K MAXSIZE 500M
/

--4. 在OEM控制台修改系统默认的UNDO表空间名, 由 UNDOTEMP 改为 UNDOTBS, 改回原有的UNDO表空间标识
ALTER SYSTEM SET UNDO_TABLESPACE = UNDOTBS
/

--5. 删除临时创建的UNDO表空间UNDOTEMP
DROP TABLESPACE "UNDOTEMP" INCLUDING CONTENTS AND DATAFILES
/

ALTER SYSTEM SET UNDO_TABLESPACE = UNDOTBS2;
DROP TABLESPACE "UNDOTBS1" INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE "TEMP" INCLUDING CONTENTS AND DATAFILES;