Yesterday a co-worker was creating a dataguard by using the command duplicte for standby
channel c1: restoring control file ORA-19625: error identifying file /tbe/prod/uti/bck/controle_cdn_standby.ctl ORA-27037: unable to obtain file status HPUX-ia64 Error: 2: No such file or directory Additional information: 3 ORA-19600: input file is control file (/tbe/prod/uti/bck/controle_cdn_standby.ctl) ORA-19601: output file is control file (/tbe/prod/data/cdn/tbectrl1.con) failover to previous backup
He is executing a duplicate like show below;
DUPLICATE TARGET DATABASE FOR STANDBY
He is using a tape backup of the primary database, but the file RMAN is looking to restore, was on disk instead of tape, RMAN can not find it.
After a bit of investatiion, we have seen that my partner, after the tape backup, executed the following command
ALTER DATABASE BACKUP CONTROLFILE TO ‘/xxxx/xxxx/control.bck’;
The alter system has been registered in the control file of the primary database, to which we are connected from the stanby to execute the duplicate, as a backup of the control file. The duplicate that is executed does not include any set until clauses, so Oracle looks for the more recently backup of the CF, in this case the copy on disk (with the same path), but has not been copied from the source machine to the destination (the rest of the backup is on tape)
Copy this backup to the CF disk in the same route in the machine where the standby solves the problem. Other solution would be set until time (or scn) to a point before the CF backup to disk.
HTH – Antonio NAVARRO