Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 4F83019600E5 for ; Thu, 5 May 2016 00:52:39 +0200 (CEST) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTPS for ; Thu, 5 May 2016 00:52:39 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B6B6337CAA; Wed, 4 May 2016 18:52:37 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at turing.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 mpv1wAlm6yOk; Wed, 4 May 2016 18:52:37 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 82EC737CE7; Wed, 4 May 2016 18:52:25 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 04 May 2016 18:51:03 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AE40537CD8 for ; Wed, 4 May 2016 18:51:03 -0400 (EDT) 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 xIg_7oIxtqFJ for ; Wed, 4 May 2016 18:51:03 -0400 (EDT) Received: from mail-qk0-f174.google.com (mail-qk0-f174.google.com [209.85.220.174]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 7749937CA5 for ; Wed, 4 May 2016 18:51:03 -0400 (EDT) Received: by mail-qk0-f174.google.com with SMTP id x7so34430793qkd.3 for ; Wed, 04 May 2016 15:51:03 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc; bh=tqd9VFp+aLdpxO3RatZB6pAriagM93SlZkJ1J4G8goo=; b=LUa0B5WZCyj2o5teW6xSAuiaeFG/y/SyY0ZjP3v5afKS6YHBeL2+XQTId1ooAqU1Xa 5C7WhnVZ3cj7MtsbfuWmK1/xSFRb8L9Z3vjixcCKWFfDe2dJ8zBOcOfzOEldBXE2/bj3 RrAS3otRob2GZdRVKpdRJgOVPF+D+9TWCceFqD0JI1R24T5fGejK6vI7+hSL1Wa7RocU I7xgzFsbEJtOBvwyMyi+ac/CxrqOL8GLd7kJrXz7zKAXzVi0BxPhAxgZvE8e/IxoQ+u5 NjDqecb4HfyKxhBlqrGJ8gC6AbiiV31thhDS0Wo79dA8IrEjZ8QqSIFRzOsu4SryjrsW JusQ== X-Gm-Message-State: AOPr4FUPzBYo3VD7gEo4knElfdgxEBcHO4eBn6Jx3VWEcjIUdKpa/BsuEDfhu+MOMTHG6anME0wFyaNfHUZFLg== MIME-Version: 1.0 X-Received: by 10.233.220.4 with SMTP id q4mr11533776qkf.145.1462402262996; Wed, 04 May 2016 15:51:02 -0700 (PDT) Received: by 10.55.41.141 with HTTP; Wed, 4 May 2016 15:51:02 -0700 (PDT) In-Reply-To: References: Date: Wed, 4 May 2016 17:51:02 -0500 Message-ID: Subject: Re: dataguard standby creation - duplicate target not using incrementals From: Andrew Kerber To: Robert Freeman Cc: ORACLE-L Content-Type: multipart/alternative; boundary=94eb2c0436b0679eed05320c0f26 X-archive-position: 64815 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: andrew.kerber@gmail.com Precedence: normal Reply-To: andrew.kerber@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 --94eb2c0436b0679eed05320c0f26 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable The 'list backup of database' shows them as incremental level 1 backups each day after Saturday,and shows Saturday's backup as an incremental level 0, Which is what it should show I think. On Wed, May 4, 2016 at 5:22 PM, Robert Freeman wrote: > Your not doing a combination of incremental and merged incremental backup= s > are you? There is a known bug if you are using both kinds of backup > strategies. > > Did you run the *list backup of database* report from RMAN and make sure > that RMAN reports level 1 incremental backups (LV=3D1). I=E2=80=99ve seen= some cases > in the past > > When people thought they were doing incremental backups and they were not= . > > Are you using the keep syntax in your backup incremental commands? > > > > Just a few thoughts running through my head=E2=80=A6 > > > > *From:* oracle-l-bounce@freelists.org [mailto: > oracle-l-bounce@freelists.org] *On Behalf Of *Andrew Kerber > *Sent:* Wednesday, May 04, 2016 4:01 PM > *To:* ORACLE-L > *Subject:* dataguard standby creation - duplicate target not using > incrementals > > > > I ran into something interesting today. We have a full backup of a > database from Saturday night, and incrementals each night through last > night. > > We ran a 'duplicate target database for standby;' command to use the > existing backup. Oracle restored from the full backup, but did not use t= he > incrementals. Instead, it asked for all of the archive logs since the fu= ll > backup. Is this expected behavior, or just something overlooked in the > design, or what? > > Oracle 11.2.0.4 on Redhat 6.7 > > > -- > > Andrew W. Kerber > > 'If at first you dont succeed, dont take up skydiving.' > --=20 Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' --94eb2c0436b0679eed05320c0f26 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
The 'list backup of database' shows them as increm= ental level 1 backups each day after Saturday,and shows Saturday's back= up as an incremental level 0, Which is what it should show I think.

On Wed, May 4, = 2016 at 5:22 PM, Robert Freeman <rfreeman@businessolver.com&g= t; wrote:

Your not doing a combination of incre= mental and merged incremental backups are you? There is a known bug if you = are using both kinds of backup strategies.

Did you run the list backup of database report from RMAN and make sure that RMAN rep= orts level 1 incremental backups (LV=3D1). I=E2=80=99ve seen some cases in = the past

When people thought they were doing i= ncremental backups and they were not.

Are you using the keep syntax in your= backup incremental commands?

=C2=A0

Just a few thoughts running through m= y head=E2=80=A6

=C2=A0

From: oracle-l-bounce@freelists.org [mai= lto:orac= le-l-bounce@freelists.org] On Behalf Of Andrew Kerber
Sent: Wednesday, May 04, 2016 4:01 PM
To: ORACLE-L <oracle-l@freelists.org>
Subject: dataguard standby creation - duplicate target not using inc= rementals

=C2=A0

I ran into something = interesting today.=C2=A0 We have a full backup of a database from Saturday = night, and incrementals each night through last night.

We ran a 'duplica= te target database for standby;' command to use the existing backup.=C2= =A0 Oracle restored from the full backup, but did not use the incrementals.= =C2=A0 Instead, it asked for all of the archive logs since the full backup.=C2=A0 Is this expected behavior, or just something overlo= oked in the design, or what?

Oracle 11.2.0.4 on Redhat 6.7


--

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'




--
Andrew W. Kerber

'If at first you dont succeed, dont tak= e up skydiving.'
--94eb2c0436b0679eed05320c0f26-- -- http://www.freelists.org/webpage/oracle-l