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

Last updated on OCTOBER 31, 2016

Applies to:

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


Symptoms

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 


....... 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms