Re: cascade standby activation to primary

So will "*alter database activate physical standby database" * open my db in Read-write mode + Primary Role ?

alter system set log_archive_dest_3='disable' scope=both; --> ### on Prod_stby
Now shutdown the MRP on standby ### prod_cascade *alter database activate physical standby database;* alter system set log_archive_config='(PROD,PROD_STBY)' scope=both; ### On prod & Prod_stby both
alter system set log_archive_config='(prod_cascade,prod_cascade_stby)' scope=both; ### for new standby for cascade .

On Mon, Jul 31, 2017 at 11:54 PM, bhavani d <bhavani021_at_gmail.com> wrote:

> You 'll have to disable the dest_n parameter for the prod_cascade stand by
> on Primary with the below command.
>
> alter system set log_archive_dest_3='disable' scope=both; ----assume i m
> using 3 for prod_cascade.
>
> Now shutdown the MRP on standby
>
> now activate the prod_cascde standby database
>
> *alter database activate physical standby database;*
>
>
> *Thanks*
> *Bhavani *
>
> On Mon, Jul 31, 2017 at 2:18 PM, Sumit Kumar T <dba.tyagisumit_at_gmail.com>
> wrote:
>
>> Hi ,
>>
>> I have a cascade standby configuration ( PROD --> PROD_STBY -->
>> PROD_CASCADE )
>>
>> Primary : PR0D ( 3-Node RAC )
>> Standby : PROD_STBY ( 3-Node RAC)
>> Cascade standby : PROD_CASCADE (2 - Node RAC )
>>
>> I want to remove PROD_CASCADE from cascaded standby and open it as a
>> primary database which will have no dependency on PROD & PROD_STBY .
>>
>> I will later create a new standby ( PROD_CASCADE_STBY ) with
>> PROD_CASCADE as primary So we want below new configurations which will
>> be independent of each other .
>>
>> How can this be done ? How can i remove prod_cascade from standby
>> configuration without impacting prod & prod_stby .
>>
>>
>> Primary : PR0D
>> Standby : PROD_STBY
>>
>>
>> Primary : PROD_CASCADE
>> Standby : PROD_CASCADE_STBY
>>
>> *--*
>> *BR*
>> *Sumit Tyagi*
>>
>>
>
>
> --
> Thanks,
> Bhavani Prasad.
>

-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

--
http://www.freelists.org/webpage/oracle-l