linux ora-27072,ORA-27072:ORA-19502: 磁盘空间不足 错误处理

RMAN> backup tablespace tps_09210610102 plus archivelog

delete input;

Starting backup at 08-DEC-11

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=6 RECID=3

STAMP=767331797

input archived log thread=1 sequence=7 RECID=5

STAMP=767334013

input archived log thread=1 sequence=8 RECID=7

STAMP=767917379

input archived log thread=1 sequence=9 RECID=10

STAMP=768531859

input archived log thread=1 sequence=10 RECID=12

STAMP=769234531

input archived log thread=1 sequence=11 RECID=14

STAMP=769306328

input archived log thread=1 sequence=12 RECID=15

STAMP=769306594

input archived log thread=1 sequence=13 RECID=18

STAMP=769309888

input archived log thread=1 sequence=14 RECID=19

STAMP=769310512

input archived log thread=1 sequence=15 RECID=21

STAMP=769311074

input archived log thread=1 sequence=16 RECID=24

STAMP=769314895

input archived log thread=1 sequence=17 RECID=25

STAMP=769315098

channel ORA_DISK_1: starting piece 1 at 08-DEC-11

RMAN-00571:

===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

===============

RMAN-00571:

===========================================================

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;

附：最主要的还是去删掉已经过期的归档日志