Re: Recovering a standby database with rman

And how do you plan to restore standby backup to the primary without catalog?

On Mon, May 31, 2021, 05:19 Howard Latham <howard.latham_at_gmail.com> wrote:

> 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