Re: Recovering a standby database with rman

Hi Howard,

RMAN always make a connection from the standby to the primary and force a log switch at the primary, thus you should have a consistent set of archive logs during the backup. ( I believe there was a bug in 10g where this did not happen)

If you’d like to take a consistent cold backup at the standby then have a look at this note:

    How to take consistent backups at standby site (Doc ID 1292126.1)  

HTH, Leng.

> On 31 May 2021, at 7:19 pm, 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 <mailto: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 <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 <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 <mailto: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 <mailto: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
>> 
>> 

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