Re: Recovering a standby database with rman

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