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,
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

 

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s