RMAN backup failed with this error: RMAN-03009
Posted by Roshan on May 23, 2016; 8:22am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-backup-failed-with-this-error-RMAN-03009-tp1000.html
Hello,
we are getting the error below:
RMAN backup failed with this error: RMAN-03009
RMAN backup fails due to corrupt blocks found.
channel ORA_DISK_2: starting piece 1 at 20-MAY-16
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/20/2016 19:39:46
continuing other job steps, job failed will not be re-run
ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/oracle/PROD/db/apps_st/data/system09.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
Starting backup at 20-MAY-16
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/20/2016 19:39:46
ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/oracle/PROD/db/apps_st/data/system09.dbf
I run the following:
rman> backup validate check logical database;
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
352 FAILED 0 45928 192128 5965214510244
File Name: /u01/oracle/PROD/db/apps_st/data/system09.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 77197
Index 0 40770
Other 26473 28233
RMAN> run {blockrecover corruption list;}
Starting recover at 22-MAY-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=813 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1223 device type=DISK
searching flashback logs for block images
finished flashback log search, restored 0 blocks
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/22/2016 08:11:41
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 352 found to restore
RMAN-06023: no backup or copy of datafile 352 found to restore
I have also run the following:
RMAN> advise failure;
01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
26462. Please contact Oracle Support Services to resolve failure 159150: Block 192117 in datafile 352: '/u 01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
26463. Please contact Oracle Support Services to resolve failure 159156: Block 192118 in datafile 352: '/u 01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
26464. Please contact Oracle Support Services to resolve failure 159162: Block 192119 in datafile 352: '/u 01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
26465. Please contact Oracle Support Services to resolve failure 159168: Block 192120 in datafile 352: '/u 01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
26466. Please contact Oracle Support Services to resolve failure 159174: Block 192121 in datafile 352: '/u 01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
26467. Please contact Oracle Support Services to resolve failure 159180: Block 192122 in datafile 352: '/u 01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
26468. Please contact Oracle Support Services to resolve failure 159186: Block 192123 in datafile 352: '/u 01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
26469. Please contact Oracle Support Services to resolve failure 159192: Block 192124 in datafile 352: '/u 01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
26470. Please contact Oracle Support Services to resolve failure 159198: Block 192125 in datafile 352: '/u 01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
26471. Please contact Oracle Support Services to resolve failure 159204: Block 192126 in datafile 352: '/u 01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
26472. Please contact Oracle Support Services to resolve failure 159210: Block 192127 in datafile 352: '/u 01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
26473. Please contact Oracle Support Services to resolve failure 159216: Block 192128 in datafile 352: '/u 01/oracle/PROD/db/apps_st/data/system09.dbf' is media corrupt
Still did not solve the issue
Regards,
Roshan