Re: Recovering a standby database with rman

I think that may be the secret. Always backup logs from primary to go with standby backup

On Mon, 31 May 2021, 10:12 Hemant K Chitale, <hemantkchitale_at_gmail.com> wrote:

>
> You don't need a CATALOG.
>
> 1 Stop Recovery on the Standby, note the last ArchiveLog applied.
> 2. Take an RMAN Backup of the Standby.
> 3. Backup additional ArchiveLogs from the Primary
> 4. Restore the Backup from the Standby to the Primar
> 5. RECOVER using the ArchiveLogs from Step 3
>
> See
> https://hemantoracledba.blogspot.com/2020/05/rman-backup-of-standby-database.html
>
> (However, I demonstrate only the Standby Backup, not the RESTORE and
> RECOVER at the Primary)
>
> If you DO use a CATALOG see :
>
> https://hemantoracledba.blogspot.com/2021/04/primary-and-standby-in-same-rman-catalog.html
>
>
>
> Hemant K Chitale
>
>
>
>
> On Sun, May 30, 2021 at 11:28 PM Howard Latham <howard.latham_at_gmail.com>
> wrote:
>
>> Hi mladen happy labor day . What I didn't make clear the exercise was a
>> bare metal restore all else has gone and there is no catalog. Only an rman
>> backup from a standby. We hope to rebuild our primary from this backup.
>>
>> On Sun, 30 May 2021, 05:26 Gogala, Mladen, <gogala.mladen_at_gmail.com>
>> wrote:
>>
>>> Hi Howard!
>>>
>>> Since you need the rman catalog to backup production from standby,
>>> catalog will lump the backups of the same DBID under the same database.
>>> That means that you can backup archive logs on the primary and the database
>>> on the standby. When restoring you can use either one. Rman will be able to
>>> use any backup of archive logs that it finds in the catalog. Enjoy your
>>> Memorial Day and don't restore any backups during the holiday.
>>>
>>> Regards
>>> On 5/28/2021 5:25 AM, Howard Latham wrote:
>>>
>>> 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
>>>
>>>
>>> --
>>> Mladen Gogala
>>> Oracle DBA
>>> Tel: (347) 321-1217
>>> Blog: https://dbwhisperer.wordpress.com
>>>
>>

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