Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create standby database from existing standby database

3012787Aug 14 2015 — edited Aug 18 2015

I have a scenario where in I need to create a standby database from an existing standby database.

Database version is 11.2.0.2.0 on Linux. I'm looking for RMAN duplicate "from active database" to create the new standby. But the duplicate fails with the below error.

Starting backup at 14-AUG-15

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

copying standby control file

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 14/08/2015 10:13:31

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 14/08/2015 10:13:31

ORA-01671: control file is a backup, cannot make a standby control file

Does anyone has an idea on this ?

This post has been answered by Shivananda Rao on Aug 17 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2015
Added on Aug 14 2015
19 comments
3,109 views