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
|