oracle 11g 错误1691,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

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