Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from smtp-aa.freelists.org (smtp-aa.freelists.org [23.23.80.81]) by malta2546.startdedicated.com (Postfix) with ESMTPS id 6EE84100311819 for ; Mon, 31 May 2021 17:09:28 +0200 (CEST) Received: from turing.freelists.org (ip-10-0-0-164.ec2.internal [10.0.0.164]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits)) (No client certificate requested) by smtp-aa.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 6472740919; Mon, 31 May 2021 15:09:27 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 5755740D09; Mon, 31 May 2021 15:09:27 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1622473767; bh=j5RvChwM6XZx6MtvsowbJeaFr7H3I2Uy2dkJCOwj08U=; h=From:Sender:Sender:From; b=KkUmTdk8rxfBDMExKxNeCH5n+VV0bH6dlcaQyYYi6SKdt53fFv6TtEC6B2OqYxRKz nS0P7MFf9rsTlQX/3IjKsuPy5bc9doFQBl1GopoE/ky0a7uOrKPPOxKAWAuiTYSi95 bDEcqqbRTsDw3Osa+mNQh7db2FzlelCTIKcRrX98= X-Virus-Scanned: by FreeLists at turing2.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id vxMvICFsbzMo; Mon, 31 May 2021 15:09:27 +0000 (UTC) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id D0FC340AF9; Mon, 31 May 2021 15:09:24 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1622473765; bh=j5RvChwM6XZx6MtvsowbJeaFr7H3I2Uy2dkJCOwj08U=; h=From:Sender:Sender:From; b=kmhWsdq/NvaRdAdxPOJ/kwRe0t/blIRrgcvPjnoYBrZLDI1iChIyJI5asdCbZlMoG lOzlx1B2z0AnCJTwock8NdutZctsX8F+KIr6urWlYRXNHNW/H9IsOuLjZoV/TlL3NW DRa704hAki24TzDgDDkl/bJD9vLgONWDcjwv001E= Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 31 May 2021 15:09:23 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 4EE1840D09 for ; Mon, 31 May 2021 15:09:23 +0000 (UTC) Authentication-Results: turing.freelists.org; dkim=pass (2048-bit key; unprotected) header.d=gmail.com header.i=@gmail.com header.a=rsa-sha256 header.s=20161025 header.b=tS0wHx6x; dkim-atps=neutral Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id k21nl66yK_w1 for ; Mon, 31 May 2021 15:09:23 +0000 (UTC) Received: from mail-lf1-f43.google.com (mail-lf1-f43.google.com [209.85.167.43]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by turing.freelists.org (Postfix) with ESMTPS id 3F4A140AF9 for ; Mon, 31 May 2021 15:09:23 +0000 (UTC) Received: by mail-lf1-f43.google.com with SMTP id r5so17295103lfr.5 for ; Mon, 31 May 2021 08:09:23 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=PYKv3pooCwMyR8UmeP9/scXuhlTwjWdiW7e7Nv+HAzs=; b=nk49TfObDfdwa8pAfeoQK652b/opQEkWMLi7cO8TYD408SjTurbVxvc1zu0nWBPB1i 0y3LiqBMfGD+Ae80R8IsSZM9PfaAdGpzOmkYU5zEDVJzxofoBS7bTodtmHyZXnzO4fc4 Lp+n4zML35/Ugipaue6GxD5MaGdFqOk8FzS9fMhrMXMQWXGSrBfYNmEnEXyQAFnWPgjn ajAu9mpDNSwEnKZm5EcJJFE+nqlkddAqRYHZs6rAqNmJ3gQysuIMuzIqkLp69Vmotx9Y BRh/J6FGG1OWKH9Kq61eqGWkuXvBcoxbl593CtcxJilWIW/TUBdmUGpOG6LgbL7O+WJh jDiA== X-Gm-Message-State: AOAM530P2p15w5VPikNhEAwwXnWuSTjcFMGdGenrsfSW1UkILtyps4UC 1HI4/VnakJHYW7ruAQHTiQ0QxWTO0+R75MEXyTw= X-Google-Smtp-Source: ABdhPJwDm6kyFZzXXMZvsolditD9ZXSsc6z/LsY03vZ1L1GYpdT1/465AES4MH3ghYwAB3cYqisXkVMorsu5Q0R0Tqk= X-Received: by 2002:ac2:5979:: with SMTP id h25mr15117848lfp.497.1622473761984; Mon, 31 May 2021 08:09:21 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Hemant K Chitale Date: Mon, 31 May 2021 23:08:56 +0800 Message-ID: Subject: Re: Recovering a standby database with rman To: Mladen Gogala Cc: Howard Latham , ORACLE-L Content-Type: multipart/alternative; boundary="0000000000003d940605c3a19cf9" X-archive-position: 80104 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: hemantkchitale@gmail.com Precedence: normal Reply-To: hemantkchitale@gmail.com List-Help: List-Unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-Subscribe: List-Owner: List-post: List-Archive: X-list: oracle-l --0000000000003d940605c3a19cf9 Content-Type: text/plain; charset="UTF-8" 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 wrote: > And how do you plan to restore standby backup to the primary without > catalog? > > On Mon, May 31, 2021, 05:19 Howard Latham 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, >> 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 >>> 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, >>>> 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 >>>>> >>>> --0000000000003d940605c3a19cf9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

The RESTORE PRIMARY CONTROLFILE=C2=A0 =C2= =A0command introduced in 11.2.0.4


See MOS document " Step by Step method= to create Primary/Standby Database from Standby Backup (Doc ID 1604251.1)&= quot;
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 Go= gala <gogala.mladen@gmail.com= > wrote:
=
And how do you plan to restore standby backup to the prim= ary without catalog?

On Mon, May 31, 2021, 05:19 Howard Latham <howard.latham@gmail.c= om> wrote:
I think that may be the secret. Always backup logs from= primary to go with standby backup=C2=A0=C2=A0

On Mon, 31 May 2021, 10:12 He= mant K Chitale, <hemantkchitale@gmail.com> wrote:
=
You don't need a CATALOG.

1=C2=A0 Stop Recove= ry on the Standby, note the last ArchiveLog applied.
2. Take an R= MAN Backup of the Standby.
3.=C2=A0 Backup additional=C2=A0Archiv= eLogs from the Primary
4.=C2=A0 Restore the Backup from the Stand= by to the Primar
5.=C2=A0 RECOVER using the ArchiveLogs from Step= 3

(However, I d= emonstrate only the Standby Backup, not the RESTORE and RECOVER at the Prim= ary)

If you DO use a CATALOG see :



Hemant K Chitale



On Sun, May 30, 2021 at 11:28 PM = Howard Latham <howard.latham@gmail.com> wrote:
= Hi mladen happy labor day . What I didn't make clear the exercise was= =C2=A0 a bare metal restore all else has gone and there is no catalog.=C2= =A0 Only an rman backup from a standby.=C2=A0 We hope to rebuild our primar= y from this backup.=C2=A0

On Sun, 30 May 2021, 05:26 Gogala, Mladen, <gogala.mladen@gmail.com> wrote:
=20 =20 =20

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:
=20
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 s= witch does not occur on the primary but redo is applied through the standby=C2=A0redo log. Has anyone experienced=C2=A0problems with = this? Obviously on a primary we=C2=A0would force a log switch but you can't=C2=A0do that on a standby. If I've missed a doc on = this apologies=C2=A0and 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=
--0000000000003d940605c3a19cf9-- -- http://www.freelists.org/webpage/oracle-l