How to duplicate second standby database from first standby database

Apr 28, 2021 1:04AM

We are planning to establish data guard database(s) having the following topology:

|--- First Standby ( successfully created , Server B)

Primary (Server A) --|

|--- Second Standby ( Semi-success , Server B)

DB_UNIQUE_NAME for Primary is EMDBPR

DB_NAME for Primary is EMDB

The rman script to clone for first standby is successful similar to the following command

rman target sys/xxxx@prim auxiliary sys/xxxx@first_standby

run

{

duplicate target database for standby from active database dorecover nofilenamecheck

spfile

parameter_value_convert 'emdb','emdbdr'

set db_name = 'EMDB'

set db_unique_name = 'EMDBDR'

set memory_max_target = '0'

High Availability Data Guard, Sharding and Global Data Services (MOSC)