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!

Second physical standby on the same host

user12702548Dec 23 2015 — edited Dec 24 2015

Hi,

I am experimenting with data guard in 12c environment. I set up a physical standby on a remote host. Now I want to set up a logical standby on the same remote host. I followed the same procedure as the first one and I am getting controlfile error below.

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

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

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

RMAN-03002: failure of Duplicate Db command at 12/23/2015 12:28:11

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

ORA-19660: some files in the backup set could not be verified

ORA-19661: datafile 0 could not be verified

ORA-19849: error while reading backup piece from service db12c

ORA-19504: failed to create file "/u01/app/oracle/oradata/DB12C/controlfile/o1_mf_c6mo5ymp_.ctl"

ORA-27086: unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

Additional information: 12011

RMAN> exit

This is the rman command I used to create physical standby.

run {

allocate channel prmy1 type disk;

allocate auxiliary channel stby1 type disk;

duplicate target database for standby from active database

spfile

parameter_value_convert 'db12c','db12cl'

set db_unique_name='db12cl'

set db_file_name_convert='db12c','db12cl'

set log_file_name_convert='db12c','db12cl'

set fal_server='db12c'

nofilenamecheck;

}

It is trying to create the control file at the same location as the first physical standby.

Is it even possible to create two standbys in one host as both will have the same db name and only db unique name will vary?

Is it possible to create the control file inside ../oradata/db_unique_name/controlfile instead of ../oradata/db_name/controlfile?

Thanks.

This post has been answered by Oratig-Oracle on Dec 23 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 21 2016
Added on Dec 23 2015
8 comments
2,443 views