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