Re: Implementing Archiving of Redo logs some more questions (Sybrand and Howard)

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 20 Feb 2003 06:31:20 +1100
Message-ID: <pan.2003.02.19.19.31.17.310955@yahoo.com.au>

On Sat, 15 Feb 2003 10:23:43 +0000, mokat6 wrote:

> On Sat, 15 Feb 2003 15:28:17 +1100, "Howard J. Rogers"
> <howardjr2000_at_yahoo.com.au> wrote:
>

>>On Sat, 15 Feb 2003 00:31:52 +0000, mokat6 wrote:
>>
>>> May I thank both Gentlemen Sybrand and Howard for their fast response.
>>> 
>>> But I see differences in the answers of 2 questions:
>>> 
>>>> 4-  In case of recovery operation where is the database looking for
>>>> the log files? In my case location 1, 2 or both as long as he find the
>>>> right log?
>>> 
>>> Sybrand:  c) is the right answer
>>> 
>>> Howard:  In location 1, but if it can't find the log it needs there,
>>> it will flip over to location 2 automatically to see if it can find it
>>> there. This behaviour was intended to happen in 8i, but didn't (!!),
>>> but it works fine
>>> in 9i.
>>>
>>
>>Well, Sybrand can defend himself just fine. But simply saying 'it looks in
>>both locations' is a bit daft: if it finds it in the first location, why
>>on earth would it proceed to waste time looking for the same file in the
>>second location?

>
> My case is that if drive D has crashed I like to recover a datafile on
> this drive. As u read before there is also an archive location on
> this drive (I know it should not be on a drive with datafiles) while
> restoring the D drive it contains the archive files from the backup
> tape (so it is missing some which are still avaialble on the archive
> location on the E drive. My question is: If oracle first looks on the
> D drive and finds some log files it needs and use them but missing
> some also will it automatically take over and searching on the E drive
> archive location without any intervention of myself?

The answer is still the same as I gave before: in 9i, yes. Before 9i, no.

HJR Received on Wed Feb 19 2003 - 13:31:20 CST