Re: is there any way i can avoid rebuild physical standby database after every PROD to UAT database refresh ?

Hi Falgun,
Even without resetlogs, you have to rebuild the standby because the primary has been overwritten.
If you do not open resetlogs (like with a restore without open) then you can rebuild the standby from the same backups that were used for the primary. But I'm not sure that it will be better than re-creating the standby from the primary. Is that a problem if it is automated (duplicate for standby, or restore from service is easily automated). Regards,
Franck.

On Sat, Nov 9, 2019 at 1:16 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

>
> On 11/8/19 5:05 PM, falgun patel wrote:
>
>
> I have question related to Dataguard.
>
>
>
> I get 2 to 4 times request in a month to refresh Oracle Production
> Database to UAT Database.
>
>
>
> Production and UAT both databases are on 11g R2 version.
>
>
>
> Production Database Setup is 4 Node RAC i.e. 2 Node Primary and 2 Node
> Physical Standby.
>
>
>
> UAT Database Setup is 4 Node RAC i.e. 2 Node Primary and 2 Node Physical
> Standby.
>
>
>
> My Question:
>
>
>
> Every time if refresh Production database to UAT , and since every time
> incarnation gets changed in UAT after refresh from production database.
>
>
>
> Due to this my current UAT Physical standby database is of no use as it
> goes out of sync.
>
>
>
> Everytime After this production to UAT DB refresh i have to rebuild my UAT
> physical standby database again and again.
>
>
>
> I want to know if there is any way i can avoid this rebuild physical
> standby database after every UAT database refresh ?
>
>
>
> Please provide me detailed steps.
> --
>
> Regards
>
> Falgun Patel
>
> Hi Falgun,
> Of course you can avoid the rebuild of physical standby database. Why are changing the incarnation? Let me guess: you are connecting to catalog. I have been refreshing databases in the ancient times of 9.2 without changing the incarnation. You don't connect to catalog and you don't register the newly minted UAT copy to catalog. Also, use SRDF or whatever tool your array offers.
> Regards
>
>
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
>

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