Home > Oracle > 正文

Oracle ORA-1691的报错处理

写一个处理ORA-1691的处理步骤

首先看报错日志


Sun Sep 18 08:45:22 2016
ORA-1691: unable to extend lobsegment TRFF_APP.SYS_LOB0000075395C00004$$ by 128 in tablespace DT_VIO_IMG
ORA-1691: unable to extend lobsegment TRFF_APP.SYS_LOB0000075395C00004$$ by 8192 in tablespace DT_VIO_IMG
ORA-1691: unable to extend lobsegment TRFF_APP.SYS_LOB0000075395C00004$$ by 128 in tablespace DT_VIO_IMG
ORA-1691: unable to extend lobsegment TRFF_APP.SYS_LOB0000075395C00004$$ by 8192 in tablespace DT_VIO_IMG

然后查询当前表空间的数据文件所在路径


SQL> select file_name from dba_data_files where tablespace_name ='DT_VIO_IMG';

FILE_NAME
--------------------------------------------------------------------------------
+HDS/orcl/datafile/dt_vio_img.349.814111715
+HDS/orcl/datafile/dt_vio_img.862.826914343
+HDS/orcl/datafile/dt_vio_img.1080.850145971
+HDS/orcl/datafile/dt_vio_img.1291.866973157
+HDS/orcl/datafile/dt_vio_img.1292.866973163
+HDS/orcl/datafile/dt_vio_img.1715.902225027
+HDS/orcl/datafile/dt_vio_img.1717.902417461
+HDS02/orcl/datafile/dt_vio_img.268.913974347

8 rows selected.

添加两个数据文件


SQL> alter tablespace DT_VIO_IMG add datafile '+HDS02' size 100m autoextend on next 300m;

Tablespace altered.

SQL> alter tablespace DT_VIO_IMG add datafile '+HDS02' size 100m autoextend on next 300m;

Tablespace altered.

再查询数据文件


SQL> select file_name from dba_data_files where tablespace_name ='DT_VIO_IMG';

FILE_NAME
--------------------------------------------------------------------------------
+HDS/orcl/datafile/dt_vio_img.349.814111715
+HDS/orcl/datafile/dt_vio_img.862.826914343
+HDS/orcl/datafile/dt_vio_img.1080.850145971
+HDS/orcl/datafile/dt_vio_img.1291.866973157
+HDS/orcl/datafile/dt_vio_img.1292.866973163
+HDS/orcl/datafile/dt_vio_img.1715.902225027
+HDS/orcl/datafile/dt_vio_img.1717.902417461
+HDS02/orcl/datafile/dt_vio_img.268.913974347
+HDS02/orcl/datafile/dt_vio_img.338.922869979
+HDS02/orcl/datafile/dt_vio_img.339.922869991

10 rows selected.

整个过程的日志文件


Sun Sep 18 08:45:22 2016
ORA-1691: unable to extend lobsegment TRFF_APP.SYS_LOB0000075395C00004$$ by 128 in tablespace DT_VIO_IMG
ORA-1691: unable to extend lobsegment TRFF_APP.SYS_LOB0000075395C00004$$ by 8192 in tablespace DT_VIO_IMG
ORA-1691: unable to extend lobsegment TRFF_APP.SYS_LOB0000075395C00004$$ by 128 in tablespace DT_VIO_IMG
ORA-1691: unable to extend lobsegment TRFF_APP.SYS_LOB0000075395C00004$$ by 8192 in tablespace DT_VIO_IMG
Sun Sep 18 08:46:19 2016
alter tablespace DT_VIO_IMG add datafile '+HDS02' size 100m autoextend on next 300m
Sun Sep 18 08:46:20 2016
Starting control autobackup
Control autobackup written to DISK device
handle '/opt/app/oracle/product/10.2.0/db_1/dbs/c-1294175266-20160918-00'
Completed: alter tablespace DT_VIO_IMG add datafile '+HDS02' size 100m autoextend on next 300m
Sun Sep 18 08:46:31 2016
alter tablespace DT_VIO_IMG add datafile '+HDS02' size 100m autoextend on next 300m
Sun Sep 18 08:46:32 2016
Starting control autobackup
Control autobackup written to DISK device
handle '/opt/app/oracle/product/10.2.0/db_1/dbs/c-1294175266-20160918-01'
Completed: alter tablespace DT_VIO_IMG add datafile '+HDS02' size 100m autoextend on next 300m

整个记录仅做为记录参考,如有不足麻烦指出

上一篇:脚本查询oracle数据库表空间使用率等信息
下一篇:RMAN-00600: internal error, arguments [13205]
Oracle 11gRAC  Enterprises Manager (OEM)配置

Oracle 11gRAC Enterprises Manager (OEM)配置

sys帐号重命名导致的kokasgi1报错

sys帐号重命名导致的kokasgi1报错

dd命令的简单使用解决ORA-01200错误参考

dd命令的简单使用解决ORA-01200错误参考

BBED那些事-自用总结

BBED那些事-自用总结

关于数据库用户登录缓慢的问题

关于数据库用户登录缓慢的问题

数据库RAC 磁盘组磁盘调整

数据库RAC 磁盘组磁盘调整

CRS-2730集群资源DG无法删除

CRS-2730集群资源DG无法删除

发表评论

昵称
邮箱
网址

沙发空闲中,快来抢!