重建undo tablespace
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE
'/data6/dmp2/undotbs01_01.dbf' SIZE 16384M AUTOEXTEND OFF,
'/data6/dmp2/undotbs01_02.dbf' SIZE 16384M AUTOEXTEND OFF
ONLINE
RETENTION NOGUARANTEE
BLOCKSIZE 8K
FLASHBACK ON
ALTER SYSTEM SET undo_tablespace='UNDOTBS1' SCOPE=MEMORY;
ALTER TABLESPACE UNDOTBS1A OFFLINE NORMAL;
DROP TABLESPACE undotbs1a including contents;
(整個數據庫重啟）
shutdown immediate; srvctl stop database -d trac2 -o immediate;
startup; srvctl startp database -d trac2 ;
Database Characterset is AL32UTF8
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23757700/viewspace-708924/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
mount 新建磁盘到指定目录
请登录后发表评论
登录
全部评论
