oracle 数据表空间问题
oracle中的alert_orcl.log提示信息如下：ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Thu May 27 05:00:23 2010
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Thu May 27 06:00:24 2010
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Thu May 27 06:30:19 2010
Private_strands 3 at log switch
Thread 1 advanced to log sequence 13249
Current log# 3 seq# 13249 mem# 0: /Data1/orcl/redo03.log
Thu May 27 07:00:25 2010
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Thu May 27 09:00:28 2010
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
orcl_j000_17773.trc中的提示信息：
*** SERVICE NAME:(SYS$USERS) 2010-05-26 08:52:52.137
*** SESSION> Before in kgllkdl(), hd=80e80840.
Before in kgllkdl(), hd=80e97e38.
Before in kgllkdl(), hd=7ffc2680.
Before in kgllkdl(), hd=7ff640a8.
Before in kgllkdl(), hd=7ffba480.
Before in kgllkdl(), hd=80ecf140.
Before in kgllkdl(), hd=801fc8a0.
Before in kgllkdl(), hd=80f70800.
Before in kgllkdl(), hd=80ecf140.
Before in kgllkdl(), hd=80eaa8a0.
Before in kgllkdl(), hd=813e0b08.
Before in kgllkdl(), hd=813d6798.
Before in kgllkdl(), hd=80f4de90.
Before in kgllkdl(), hd=813e0b08.
Before in kgllkdl(), hd=813d6798.
Before in kgllkdl(), hd=80f70800.
Before in kgllkdl(), hd=80ecf140.
Before in kgllkdl(), hd=80eaa8a0.
Before in kgllkdl(), hd=80f4de90.
Before in kgllkdl(), hd=813f0190.
Before in kgllkdl(), hd=813d6798.
Before in kgllkdl(), hd=813da7f0.
Before in kgllkdl(), hd=80f70800.
Before in kgllkdl(), hd=80ecf140.
Before in kgllkdl(), hd=80f4de90.
Before in kgllkdl(), hd=813e0b08.
Before in kgllkdl(), hd=813d6798.
Before in kgllkdl(), hd=813da7f0.
Before in kgllkdl(), hd=80f70800.
Before in kgllkdl(), hd=80ecf140.
Before in kgllkdl(), hd=80eaa8a0.
Before in kgllkdl(), hd=80f4de90.
Before in kgllkdl(), hd=813d6798.
Before in kgllkdl(), hd=813da7f0.
Before in kgllkdl(), hd=80f70800.
Before in kgllkdl(), hd=80ecf140.
Before in kgllkdl(), hd=80eaa8a0.
Before in kgllkdl(), hd=80f4de90.
Before in kgllkdl(), hd=813d6798.
Before in kgllkdl(), hd=813da7f0.
Before in kgllkdl(), hd=80e73570.
Before in kgllkdl(), hd=7ff574c8.
Before in kgllkdl(), hd=80e73570.
解决：
发现临时表空间temp的数据文件已经丢失，通过重新创建临时表空间即可。
1.startup --启动数据库2.create temporary tablespace TEMP2 TEMPFILE ''/home2/oracle/oradata/sysmon/temp02.dbf''>3.alter database default temporary tablespace temp2;--改变缺省临时表空间 为刚刚创建的新临时表空间temp24.drop tablespace temp including contents and datafiles;--删除原来临时表空间5.create temporary tablespace TEMP TEMPFILE ''/home2/oracle/oradata/sysmon/temp01.dbf''>6.alter database default temporary tablespace temp;--重置缺省临时表空间为新建的temp表空间7.drop tablespace temp2 including contents and datafiles;--删除中转用临时表空间8.alter user roll temporary tablespace temp; --重新指定用户表空间为重建的临时表空间 也可以通过em图形界面来操作。
页:
[1]