My Oracle Support Banner

Cloning Fails During Recovery with ORA-19870 ORA-19502 and ORA-27072 (Doc ID 779084.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 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-19870: error reading backup piece /dump/ipwp/arc_backup/IPWP_arc_20081117_s34233_p1
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
Oracle Error:
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-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.