Backup on standby database
From: Pap <oracle.developer35_at_gmail.com>
Date: Mon, 3 May 2021 01:18:23 +0530
Message-ID: <CAEjw_fiStk+xtEOhVXCMxN4Rv6iR1GsazOPKad3shq2jvHCK4w_at_mail.gmail.com>
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.
Date: Mon, 3 May 2021 01:18:23 +0530
Message-ID: <CAEjw_fiStk+xtEOhVXCMxN4Rv6iR1GsazOPKad3shq2jvHCK4w_at_mail.gmail.com>
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-lReceived on Sun May 02 2021 - 21:48:23 CEST