Re: Recover database calls for backup pieces far earlier than the level 0 backup

From: David Barbour <david.barbour1_at_gmail.com>
Date: Thu, 4 Sep 2014 08:31:40 -0500
Message-ID: <CAFH+ife3GSxNHjFgQOuCf3E-zFKbdNds75TqRKwEw2CjC3fhWg_at_mail.gmail.com>

Set until SCN one digit beyond your Level 0 backup. I have seen this with clone snaps that use RMAN and the archivlogs are taken from the live database.

On Thu, Sep 4, 2014 at 5:39 AM, August Spier <gus.spier_at_gmail.com> wrote:

> Nope. this is single instance.
>
>
> Gus Spier
> Gus.Spier_at_gmail.com
>
> 540 454 3074
>
>
> On Sep 3, 2014, at 23:14, "Dimensional DBA" <dimensional.dba_at_comcast.net>
> wrote:
>
> Is it RAC?
>
>
>
> *Matthew Parker*
>
> *Chief Technologist*
>
> *425-891-7934 <425-891-7934> (cell)*
>
> *Dimensional.dba_at_comcast.net <Dimensional.dba_at_comcast.net>*
>
> *View Matthew Parker's profile on LinkedIn*
> <http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
>
>
>
> *From:* Dimensional DBA [mailto:dimensional.dba_at_comcast.net
> <dimensional.dba_at_comcast.net>]
> *Sent:* Wednesday, September 03, 2014 8:14 PM
> *To:* 'gus.spier_at_gmail.com'; 'fuzzy.graybeard_at_gmail.com'
> *Cc:* 'oracle-l'
> *Subject:* RE: Recover database calls for backup pieces far earlier than
> the level 0 backup
>
>
>
> There are a variety of reasons on old archive recovery point is selected,
> some are bugs and some are human error.
>
>
>
> 1. Is a table space or data file in backup mode?
>
> 2. Was a tableapace or datafile added at the archive log recovery
> point it is looking for?
>
>
>
>
>
> *Matthew Parker*
>
> *Chief Technologist*
>
> *425-891-7934 <425-891-7934> (cell)*
>
> *Dimensional.dba_at_comcast.net <Dimensional.dba_at_comcast.net>*
>
> *View Matthew Parker's profile on LinkedIn*
> <http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [
> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *On
> Behalf Of *Gus Spier
> *Sent:* Wednesday, September 03, 2014 7:46 PM
> *To:* fuzzy.graybeard_at_gmail.com
> *Cc:* oracle-l
> *Subject:* Re: Recover database calls for backup pieces far earlier than
> the level 0 backup
>
>
>
> Yes, the recovery catalog is in place. I'm at home now, so I cannot tell
> you which version ... we are trying to run a recovery out of rhe control
> files now. If that doesn't work, we'll have to open a ticket with Oracle
> <SIGH />
>
> Gus
>
>
>
> On Wed, Sep 3, 2014 at 10:28 PM, Hans Forbrich <fuzzy.graybeard_at_gmail.com>
> wrote:
>
> Can we assume Recovery Catalog is in place? If yes, which version? was
> it updated when they went to 10.2.0.4?
>
> Steps to determine are covered in
> http://docs.oracle.com/cd/B28359_01/backup.111/b28273/compat002.htm#RCMRF1948
>
> (Just eliminating factors ...)
> /Hans
>
> On 03/09/2014 7:51 PM, Gus Spier wrote:
>
> And before anybody asks ...
>
> OS: RHEL 5.6
> Oracle 10.2.0.4
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

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

Received on Thu Sep 04 2014 - 15:31:40 CEST