A coworker is creating an DATAGUARD and when run the “DUPLICATE TARGET DATABASE FOR STANDBY” command gives the error below.
released channel: t2 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 08/12/2014 13:45:25 RMAN-03015: error occurred in stored script Memory Script RMAN-06026: some targets not found - aborting restore RMAN-06101: no channel to restore a backup or copy of the control file
Investigating I see that is happening, has not been done in source database a backup of controlfile with format for standby. This is;
allocate channel t6 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=zzzz.xxxx.xxxx, NSR_DATA_VOLUME_POOL=HotFullPool, NSR_CLIENT=yyyy.xxxx.xxxx)'; backup current controlfile for standby format 'CONTROLFSTB_%s_%t_%c'; release channel t6; }
The solution is to backup controlfile with clause “for stantdby”.
HTH – Antonio NAVARRO