Friday, December 12, 2014

ORA-19510 and ORA-27045 on RMAN Backup

Situation:
Doing RMAN backup I got this error message:
ORA-19510: failed to set size of 1193456 blocks for file "/backup" (block size=8192)ORA-27045: unable to close the fileLinux-x86_64 Error: 5: Input/output error

Cause:
The backup location is a Windows NFS share. It has a limitation that the backup piece cannot be greater than 2GB. Our backup piece is 9.1GB (1193456*8192/1024/1024/1024).

Solution:
Make the RMAN backup piece respect the file size limit. For this we can use the MAXPIECESIZE option. This is an example of the usage of the command:
RMAN> configure channel device type disk MAXPIECESIZE = 2G;