Re: Recover database calls for backup pieces far earlier than the level 0 backup
- From: David Barbour <david.barbour1@xxxxxxxxx>
- To: Gus Spier <gus.spier@xxxxxxxxx>
- Date: Thu, 4 Sep 2014 08:31:40 -0500
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@xxxxxxxxx> wrote:
> Nope. this is single instance.
>
>
> Gus Spier
> Gus.Spier@xxxxxxxxx
>
> 540 454 3074
>
>
> On Sep 3, 2014, at 23:14, "Dimensional DBA" <dimensional.dba@xxxxxxxxxxx>
> wrote:
>
> Is it RAC?
>
>
>
> *Matthew Parker*
>
> *Chief Technologist*
>
> *425-891-7934 <425-891-7934> (cell)*
>
> *Dimensional.dba@xxxxxxxxxxx <Dimensional.dba@xxxxxxxxxxx>*
>
> *View Matthew Parker's profile on LinkedIn*
> <http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
>
>
>
> *From:* Dimensional DBA [mailto:dimensional.dba@xxxxxxxxxxx
> <dimensional.dba@xxxxxxxxxxx>]
> *Sent:* Wednesday, September 03, 2014 8:14 PM
> *To:* 'gus.spier@xxxxxxxxx'; 'fuzzy.graybeard@xxxxxxxxx'
> *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@xxxxxxxxxxx <Dimensional.dba@xxxxxxxxxxx>*
>
> *View Matthew Parker's profile on LinkedIn*
> <http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [
> mailto:oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>] *On
> Behalf Of *Gus Spier
> *Sent:* Wednesday, September 03, 2014 7:46 PM
> *To:* fuzzy.graybeard@xxxxxxxxx
> *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@xxxxxxxxx>
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
Other related posts:
