I got this error below

ORA-19510: failed to set size of 261894 blocks for file “/oracle_backup/PRD01_14816_3” (block size=8192)

ORA-27045: unable to close the file

Linux-x86_64 Error: 5: Input/output error

First thing,  let’s get the size of the backup piece (261894 * 8192) /1024 /1024  = 2046 MB  = 2GB

We are currently  using a Windows NFS Share to house the backup so the backup file piece cannot be > 2GB

Therefore we need to make sure the RMAN backup piece won’t exceed the O/S permitted filesize limit. Fortunately you can restrict the RMAN backup piece using the MAXPIECESIZE option.

RMAN> connect target /

connected to target database: PRD01 (DBID=1805732661)

RMAN> Configure channel device type disk MAXPIECESIZE = 2G;

using target database control file instead of recovery catalog

old RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   ‘/oracle_backup/%d_%s_%p’ MAXPIECESIZE 2 G;

new RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;

new RMAN configuration parameters are successfully stored

This has resolved the issue.

Leave a Reply

Your email address will not be published. Required fields are marked *