Saturday, March 9, 2019

RMAN-03009 and ORA-19510: failed to set size of 92079 blocks for file


If you RMAN backup commands are failing with RMAN-03009 with ORA-19502 and ORA-19510, it is because your destination file system has no space left on it for the backup. You need to make sure that file system where you are storing backup should have sufficient space to host the backup. Output of command may be similar to the following

input datafile file number=00016 name=+DATA/mydb/data01.dbf
input datafile file number=00020 name=+DATA/mydb/tools01.dbf
input datafile file number=00001 name=+DATA/mydb/system01.dbf
input datafile file number=00025 name=+DATA/mydb/data02.dbf
channel dsk1: starting piece 1 at 2017-06-07 12:00:08
channel dsk2: starting compressed incremental level 0 datafile backup set
channel dsk2: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/mydb/officedata01.dbf
input datafile file number=00009 name=+DATA/mydb/officeindx01.dbf
input datafile file number=00013 name=+DATA/mydb/trandata01.dbf
input datafile file number=00017 name=+DATA/mydb/tranindx01.dbf
input datafile file number=00024 name=+DATA/mydb/hrdata01.dbf
input datafile file number=00002 name=+DATA/mydb/sysaux01.dbf
channel dsk2: starting piece 1 at 2017-06-07 12:00:08
channel dsk3: starting compressed incremental level 0 datafile backup set
channel dsk3: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on dsk3 channel at 06/07/2017 12:01:53
ORA-19502: write error on file "/backup/mydb/ora_20170607_q7s66o28_1_1.rbf", block number 91521 (block size=8192)
ORA-27072: File I/O error
Linux-x86_64 Error: 5: Input/output error
Additional information: 4
Additional information: 91521
Additional information: -1
channel dsk3 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on dsk2 channel at 06/07/2017 12:02:00
ORA-19502: write error on file "/backup/mydb/ora_20170607_q6s66o28_1_1.rbf", block number 100353 (block size=8192)
ORA-27072: File I/O error
Linux-x86_64 Error: 5: Input/output error
Additional information: 4
Additional information: 100353
Additional information: -1
channel dsk2 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on dsk4 channel at 06/07/2017 12:02:00
ORA-19510: failed to set size of 92079 blocks for file "/backup/mydb/ora_20170607_q8s66o28_1_1.rbf" (block size=8192)
ORA-27045: unable to close the file
Linux-x86_64 Error: 5: Input/output error
Additional information: 4
channel dsk4 disabled, job failed on it will be run on another channel
released channel: dsk1
released channel: dsk2
released channel: dsk3
released channel: dsk4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dsk1 channel at 06/07/2017 12:02:15
ORA-19502: write error on file "/backup/mydb/ora_20170607_q5s66o28_1_1.rbf", block number 133889 (block size=8192)
ORA-27072: File I/O error
Linux-x86_64 Error: 5: Input/output error
Additional information: 4
Additional information: 133889
Additional information: -1


No comments:

Post a Comment

Popular Posts - All Times