请检查备份目录空间是否充足。检查 DB_RECOVERY_FILE_DEST 目录空间大小是否充足

搜索引擎告诉我，如下连接可能会有帮助。

点击这里查看以下详细信息

The error is related to space in the DB_RECOVERY_FILE_DEST.

This means your backup is trying to write 935937 (blocksize=512) *=8192=
479,199,744 bytes to this location
"/oracle/RQ1/saparch/http://rq1arch1_6826_709302136.dbf/
" and enough space is not available at this location.

I think you might have deleted the old archived log files physically using
the OS command. Even after this also you are getting the same error.

My suggestion is as follows:-

1. Delete unnecessary file(s) in backup directory using RMAN.

2. Move backup location to a mount point with more space. For this carry out
   this procedure

SQL> show parameter db_recovery_file_dest

To change either the db_recovery_file_dest or the log_archive_dest_1
parameter, use the alter system command.

SQL> alter system set db_recovery_file_dest =
‘/my/new/directory/for/archivelogs’ scope=both;
SQL> alter system set log_archive_dest_1 =
‘LOCATION=/my/new/directory/for/archivelogs’ scope=both;

Thereafter you take the backup, that should work.

show parameter db_recovery_file_dest
看看对应的空间是否足够

SQL> show parameter db_recovery_file_dest;

NAME TYPE VALUE

db_recovery_file_dest string /Exp/arch
db_recovery_file_dest_size big integer 20G

-rwxrwxrwx 1 oracle oinstall 10485768192 Mar 2 15:20 /u01/app/oradata/aus130.dbf

RMAN> backup validate check logical datafile ‘/u01/app/oradata/aus130.dbf’;

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/02/2020 15:23:18
ORA-19501: read error on file “/u01/app/oradata/aus130.dbf”, blockno 42624 (blocksize=8192)
ORA-27063: number of bytes read/written is incorrect
Additional information: 770048
Additional information: 1048576

问题还在的。

-bash-3.2$ dbv file=/u01/app/oradata/aus130.dbf blocksize=8192

DBVERIFY: Release 10.2.0.4.0 - Production on Mon Mar 2 13:06:27 2020

Copyright © 1982, 2007, Oracle. All rights reserved.

DBVERIFY - Verification starting : FILE = /u01/app/oradata/aus130.dbf

DBV-00102: File I/O error on FILE (/u01/app/oradata/aus130.dbf) during verification read operation (-2)

dd写个空文件验证一下，应该是存储的问题