Thursday, 4 June 2015

backup controlfile for standby error with RMAN-03009 ORA-01671: control file is a backup, cannot make a standby control file

We are duplicating the standby database to other standby and during the process we are getting below error.

Starting backup at 04-JUN-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=693 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/04/2015 09:42:09
ORA-01671: control file is a backup, cannot make a standby control file

So standby-1 is having the issue of taking controlfile backup for standby controlfile.

Solution:

Please refer "RMAN ACTIVE DUPLICATE WHEN CONNECTED TO STANDBY AS TARGET (Doc ID 1343515.1)"

I applied the Patch 11715084  in standby-1 and tried the duplication which is successful.


No comments: