1

Topic: How to recover corrupted block from - recover copy of database incremental level 1?

DB reservation is fulfilled here by such script

crosscheck backup;
crosscheck copy;
delete expired backup;
delete expired copy;
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 4;
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
RECOVER COPY OF DATABASE WITH TAG ' incr_update_backup ';
BACKUP
INCREMENTAL LEVEL 1 DURATION 30:00 PARTIAL
FOR RECOVER OF COPY WITH TAG ' incr_update_backup'
DATAFILECOPY FORMAT '/u01/app/backup2 / % U.dbf'
DATABASE FORMAT '/u01/app/backup2/INC1_BACKUP / % U.bkp ' FILESPERSET 1;
RECOVER COPY OF DATABASE WITH TAG ' incr_update_backup ';
delete obsolete;
SQL "alter system archive log current";
SQL "ALTER DATABASE BACKUP CONTROLFILE TO" u01/app/backup2/control01.ctl "REUSE";
SQL "CREATE PFILE =" u01/app/backup2/init$ORACLE_SID.ora "FROM SPFILE";
list copy;
report need backup;
report need backup days 2 database;
host ' date ';
exit $status

At attempt to recover beaten units (corrupted blocks) RMAN returns an error that does not find a copy

RMAN> recover datafile 7 block 17782181;
Starting recover at 8/3/2018 OF 6:06:31 PM
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1774 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1949 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=344 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=460 device type=DISK
channel ORA_DISK_1: restoring block (s) from datafile copy /u01/app/backup2/data_D-J34CDB_I-609507005_TS-JUST_DATA_FNO-7_o7t26od2.dbf
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/03/2018 6:06:34 PM
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN>

How it is possible to recover beaten units from such backup copy?

2

Re: How to recover corrupted block from - recover copy of database incremental level 1?

, I suspect it. And generally to documentation it is written that incrementel level 1 does not participate in recovery of beaten units. But oh, damn I do not see any other backup copies. It one and is rolled every day on it (recover) this incrementel level 1 - I resulted a script. It that turns out they and cannot be recovered if suddenly a complete recovery it to be necessary?