Cloning Fails During Recovery with ORA-19870 ORA-19502 and ORA-27072
Last updated on APRIL 18, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 27-NOV-2015 ***
Cloning the database using Rman.
Restore is successful. However recovery fails with
ORA-19502: write error on file "/u01/app/oracle/product/10.2.0/db/dbs/arch1_86743_620229694.dbf", blockno 56321 (blocksize=512)
ORA-27072: File I/O error
failover to previous backup
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '+DATA/ipwp/datafile/system.395.671060087'
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure of recover command at 11/17/2008 22:11:42
RMAN-20506: no backup of archivelog found
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 86743 lowscn 16425148899 found to restore
RMAN-06025: no backup of log thread 1 seq 86742 lowscn 16425125780 found to restore
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms