ORA-38872: Cannot perform backup control file recovery if Flashback Database is enabled

RLodbrock
Дата: 27.10.2015 06:10:02
Доброе утро! У меня вылазит ошибка ORA-38872. Делаю следующее:
+
RMAN> reset database to incarnation 18;

database reset to incarnation 18


RMAN> restore database until scn=2588936;

Starting restore at 27-OCT-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
flashing back control file to SCN 2588936
ORACLE error from target database: 
ORA-38729: Not enough flashback database log data to do FLASHBACK.


channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/db01/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/db01/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/db01/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/db01/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/db01/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/db01/DEV_mds.dbf
channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/db01/DEV_biplatform.dbf
channel ORA_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/db01/corrupt.dbf
channel ORA_DISK_1: reading from backup piece /u02/backup/backup8vqkljgd_1_1_20151026.bkp
channel ORA_DISK_1: piece handle=/u02/backup/backup8vqkljgd_1_1_20151026.bkp tag=TAG20151026T074101
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:46
Finished restore at 27-OCT-15


И во время recovery происходит ошибка:
+
RMAN> recover database until scn=2588936;

Starting recover at 27-OCT-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /u01/app/oracle/oradata/db01/system01.dbf
destination for restore of datafile 00002: /u01/app/oracle/oradata/db01/sysaux01.dbf
destination for restore of datafile 00003: /u01/app/oracle/oradata/db01/undotbs01.dbf
destination for restore of datafile 00004: /u01/app/oracle/oradata/db01/users01.dbf
destination for restore of datafile 00005: /u01/app/oracle/oradata/db01/example01.dbf
destination for restore of datafile 00006: /u01/app/oracle/oradata/db01/DEV_mds.dbf
destination for restore of datafile 00007: /u01/app/oracle/oradata/db01/DEV_biplatform.dbf
destination for restore of datafile 00008: /u01/app/oracle/oradata/db01/corrupt.dbf
channel ORA_DISK_1: reading from backup piece /u02/backup/backup93qkljqn_1_1_20151026.bkp
channel ORA_DISK_1: piece handle=/u02/backup/backup93qkljqn_1_1_20151026.bkp tag=TAG20151026T074630
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/27/2015 09:03:05
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start until change 2588936
ORA-00283: recovery session canceled due to errors
ORA-38872: Cannot perform backup control file recovery if Flashback Database is enabled.
RLodbrock
Дата: 27.10.2015 06:14:00
RLodbrock,
проблема решилась отключением flashback'ов:
alter database flashback off;