Re: Backup on standby database

Thank You. Our infra team is responsible for backup , stating that running backup on primary is followed as a standard practice in our case. So wondering if there exists any possible negative side of switching/running the backup to DR side. Not fully clear though, but just thinking around that in case of backup running on DR side. If a real disaster happens to either side, will that cause any concern? or say while the lag is bigger between primary and DR and one of the sides(say DR on which backup is taking place) crashed , will that pose a threat for recovery?

Regards
Pap

On Mon, May 3, 2021 at 1:31 AM Howard Latham <howard.latham_at_gmail.com> wrote:

> We do it as standard. Keeps the impact down.
>
> Best Wishes
>
> Howard A. Latham
>
>
>
>
> On Sun, 2 May 2021 at 20:48, Pap <oracle.developer35_at_gmail.com> wrote:
>
>> We are using RMAN - ZDLRA for oracle database backup. We are running it
>> currently on Primary database and it runs for around 2hrs daily. We see
>> during the backup window there is higher IO utilisation and due to that
>> sometimes application query sees variable execution time.
>>
>> We do have dataguard configured standby database for disaster recovery so
>> want to know from experts if it's advisable to run backup on standby side?
>> Or does it have any down side?
>>
>> Regards
>> Pap
>>
>

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