MOS中对ORA-01548问题进行分类讨论,感兴趣的读者可以仔细阅读 Master Note: Troubleshooting ORA-1548 error (文档 ID 1577988.1) 转到底部 In this Document PurposeTroubleshooting Steps What is ORA-1548 Case 1 : An active or dead transaction present in the Undo Segment. Case 2: Undo segment held by a...
ORA-01548: active rollback segment '_SYSSMU1_3780397527$' found, terminate dropping tablespace 错误原因: 删除undo表空间中的segment需要回复 解决方法: 删除回滚段信息 这是因为分布式事务没有提交导致的吗,看看表空间段的情况 SQL> Select segment_id,segment_name,status,tablespace_name from dba_rollback_se...
数据库装载完毕。 ORA-01157: 无法标识/锁定数据文件 2 - 请参阅 DBWR 跟踪文件 ORA-01110: 数据文件 2: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\HUICHE\UNDOTBS01.DBF' SYS@huiche>alterdatabase datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\HUICHE\UNDOTBS01.DBF' offline drop; 数据库已更改。 已用时...
1 create undo tablespace undotBS2 datafile 'D:oracleoradataPS30710UNDOTBS2.DBF' size 100m; alter system set undo_tablespace=undotBS2; drop tablespace undotbs1 including contents;(进行这部操作的时候会报下面的错): ORA-01548: 已找到活动回退段'_SYSSMU1$',终止删除表空间 2 修改文件init.ora.162...
* ERROR at line 1: ORA-01548:active rollback segment '_SYSSMU1_3780397527$' found, terminate dropping tablespace Elapsed: 00:00:00.05 2、通过spfile生成pfile 15:13:08 SYS@ prod>create pfile from spfile; File created. Elapsed: 00:00:00.11 ...
* ERROR at line 1: ORA-01548:active rollback segment '_SYSSMU1_3780397527$' found, terminate dropping tablespace Elapsed: 00:00:00.05 2、通过spfile生成pfile 15:13:08 SYS@ prod>create pfile from spfile; File created. Elapsed: 00:00:00.11 ...
ERROR at line 1: ORA-01548:active rollback segment '_SYSSMU1_3780397527$' found, terminate dropping tablespace Elapsed: 00:00:00.05 2、通过spfile生成pfile 15:13:08 SYS@ prod>create pfile from spfile; File created. Elapsed: 00:00:00.11 ...
出错现象:ORA-01548: active rollback segment '_SYSSMU124_3867542486$' found, terminate dropping tablespace 错误原因:删除undo表空间中的segment需要回复 解决方法:删除回滚段信息 select tablespace_name from dba_tablespaces; 空闲表空间大小:select tablespace_name, sum(bytes)/1024/1024 from dba_free_space ...
ORA-01548: active rollback segment '_SYSSMU10_3267518184$' found, terminate dropping tablespace 继续检查 SQL> select SEGMENT_NAME,TABLESPACE_NAME,STATUS from dba_rollback_segs; SEGMENT_NAME TABLESPACE_NAME STATUS --- --- --- SYSTEM SYSTEM ONLINE _SYSSMU10_3267518184$ UNDOTBS1 NEEDS RECOVERY _...
ORA-600[2662]: ORA-01548 active rollback segment http://inthirties.com:90/viewthread.jsp?tid=1345&frombbs=1 客户机器断电,重启Oracle以后,出现2662的错误, 这个错误处理的很多了,一般是断电或者异常关闭后,current的redo文件损坏,然后使用 _allow_resetlogs_curruption强制打开以后,scn不一致,从而...