Re: Recovering a standby database with rman

The RESTORE PRIMARY CONTROLFILE command introduced in 11.2.0.4

https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/RESTORE.html#GUID-4491C03F-C5F8-43E5-B4C4-FE26C70F2E9B

See MOS document " Step by Step method to create Primary/Standby Database from Standby Backup (Doc ID 1604251.1)"
The examples in the document do NOT show an RMAN Catalog being used.

Hemant K Chitale

On Mon, May 31, 2021 at 6:21 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> 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