My Oracle Support Banner

ORA-19870 Control File Not Found When Creating Standby Database With RMAN (Doc ID 430621.1)

Last updated on DECEMBER 05, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 10-Feb-2012***


Trying to duplicate target DB for standby you get:
ORA-19870: error reading backup piece /oradump01/GCISBETA/rman/stndby_cf_GCISBETA_t620807057_s76_p1

RMAN> run {

2>  allocate auxiliary channel c1 device type disk;

3>  duplicate target database for standby 

4>  nofilenamecheck

5>  dorecover;

6> }


Using target database control file instead of recovery catalog 

allocated channel: c1 

channel c1: sid=188 devtype=DISK 

Starting Duplicate Db at 03-MAY-07 

contents of Memory Script: 


set until scn 8256655284077; 

restore clone standby controlfile; 

sql clone 'alter database mount standby database'; 


executing Memory Script 

executing command: SET until clause 

Starting restore at 03-MAY-07 

channel c1: starting datafile backupset restore 

channel c1: restoring control file 

channel c1: reading from backup piece /oradump01/GCISBETA/rman/stndby_cf_GCISBETA_t620807057_s76_p1 

ORA-19870: error reading backup piece /oradump01/GCISBETA/rman/stndby_cf_GCISBETA_t620807057_s76_p1 

ORA-19505: failed to identify file "/oradump01/GCISBETA/rman/stndby_cf_GCISBETA_t620807057_s76_p1" 

ORA-27037: unable to obtain file status 

SVR4 Error: 2: No such file or directory 

Additional information: 3 

failover to previous backup 



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.