RE: Recover database calls for backup pieces far earlier than the level 0 backup
Date: Wed, 3 Sep 2014 20:14:19 -0700
Message-ID: <01ec01cfc7ee$5203ac30$f60b0490$_at_comcast.net>
Is it RAC?
Matthew Parker
Chief Technologist
425-891-7934 (cell)
Dimensional.dba_at_comcast.net
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn
From: Dimensional DBA [mailto: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.
- Is a table space or data file in backup mode?
- Was a tableapace or datafile added at the archive log recovery point it is looking for?
Matthew Parker
Chief Technologist
425-891-7934 (cell)
Dimensional.dba_at_comcast.net
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn
From: oracle-l-bounce_at_freelists.org [mailto: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-lReceived on Thu Sep 04 2014 - 05:14:19 CEST