Duplicate Target Database For Standby Fail

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,
backup  current controlfile for standby format 'CONTROLFSTB_%s_%t_%c';
release channel t6;


The solution is to backup controlfile with clause “for stantdby”.





Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s