RE: is there any way i can avoid rebuild physical standby database after every PROD to UAT database refresh ?
From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Sun, 10 Nov 2019 10:28:53 -0500
Message-ID: <089f01d597db$8fa45040$aeecf0c0$_at_rsiz.com>
Date: Sun, 10 Nov 2019 10:28:53 -0500
Message-ID: <089f01d597db$8fa45040$aeecf0c0$_at_rsiz.com>
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-lReceived on Sun Nov 10 2019 - 16:28:53 CET