RE: Recovering a standby database with rman

Before either RMAN or standby were products, the way we did this was to pause recovery, backup on the standby, end recovery on the standby, then switch on the primary, transmit the archived redolog result of that switch, then back up the redologs we had on the standby, save the controlfile, and finally resume recovery on the standby (unless apply was intentionally lagged). With RMAN of course that dance with pause and resume recovery shouldn’t be needed.  

Are you doing a “physical backup” or using RMAN?  

Without checking I would not presume that is how 19 and recovery on the standby works in their product 30 years later. I’m only answering because possibly everyone has flown the coop for the holiday weekend and I saw this. Having not actually done a commercial scale back up and test recovery in a couple decades, I’m mostly just confirming that it does seem like you’d need that piece. I suspect that RMAN will tell you that you need it, and that physical recovery will not complete normally without it.  

I am mystified that this wouldn’t be the first example case study in the online documentation.  

Good luck, I bet someone on the list (still) does this or something very similar every day.  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Howard Latham Sent: Friday, May 28, 2021 5:25 AM
To: ORACLE-L
Subject: Recovering a standby database with rman  

Oracle 19c

RH EL 7  

We are struggling to understand how in 19 a standby can be backed up and then recovered from tape. A common method to reduce load on a primary DB. The reason is that if standby redologs are being applied rather than archived logs there seems to be a 'hole' in the backup if the timing is wrong and a log switch does not occur on the primary but redo is applied through the standby redo log. Has anyone experienced problems with this? Obviously on a primary we would force a log switch but you can't do that on a standby. If I've missed a doc on this apologies and please point me in the right direction!  

Best Wishes  

Howard A. Latham

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