oracle常见错误号

1，ORA-01002 fetch out of sequence 读取（提取）违法顺序
2，ORA-00957: duplicate column name 重复列名
3，ORA-01403: no data found 未找到数据
4，ORA-00928: missing SELECT keyword 缺失 SELECT 关键字
5，ORA-00904: "OBJECTID": invalid identifier 无效标识符
6，ORA-00904 invalid column name 列名无效
7，ORA-01406: fetched column value was truncated 读取的列值被截断
9，ORA-00942：table or view does not exist 表和视图不存在
10，ORA-12560: TNS:protocol adapter error TNS: 协议适配器错误
11，ORA-00980: synonym translation is no longer valid 同义词转换不再有效
12，ORA-02291：integrity constraint (约束名) violated - parent key not found
违反完整约束条件（orauser.FK_KNO_EVENTTYPE1）--未找到父项关键字
13，ORA-02292: integrity constraint violated - child record found
违反完整约束条件（orauser.FK_KNO_EVENTTYPE1）--已找到子记录
14，ORA-00936: missing expression 缺失表达式
15，ORA-00001: unique constraint (BUSHR.PK_T_DIC_BMFL) violated 违反唯一约束条件（主键值重复）
16，ORA-01031 insufficient privileges 权限不足
17，ORA-12514：TNS：listener does not currently know of serverice requested in connect descriptor
TNS：监听程序当前无法识别连接描述符中请求的服务

18,ORA-28001 口令已经失效
19，ORA-28000 帐户已被锁定
20,ORA-27072:ORA-19502: 磁盘空间不足 错误处理

RMAN-03002: failure of backup plus archivelog command at 12/08/2011 02:38:38

ORA-19502: write error on file "/home/oracle_11/db/oracle/flash_recovery_area/ORCL/backupset/2011_12_08/o1_mf_annnn_TAG20111208T023819_%u_.bkp", block number 235521 (block size=512)

ORA-27072: File I/O error

Linux Error: 2: No such file or directory

Additional information: 4

Additional information: 235521

Additional information: 409088



原因磁盘空间不足

解决方法：

1、查询表空间 把不要的表空间删了

2、把要备份的表空间的大小设置小一点 不要设置太大了

3.、将归档设置到其他目录，修改alter system set log_archive_dest = 其他路径

4、.转移或者删除闪回恢复区里的归档日志。

5、增大闪回恢复区。

ALTER SYSTEM SET db_recovery_file_dest_size=4g scope=both;

6、查看闪回区使用情况：

SYS@PENG SQL> select round(space_used/space_limit,2), space_used, number_of_files, substr(name,1,20) from v$recovery_file_dest;

rman target/

rman>crosscheck archivelog all;

rman>crosscheck backup ;

7、删除重复的备份集和归档日志

rman>delete expired archivelog all;

rman>delete expired backup;