Re: Oracle-Managed Files - your views

From: Tony Sequeira <tony_at_sequeira.org.uk>
Date: Wed, 16 Dec 2009 14:18:09 +0000
Message-ID: <4B28EC21.8070907_at_sequeira.org.uk>



Hi Mark,

I don't think that you were being cryptic, I think I didn't explain the problem properly.

Using DBCA, I couldn't find a way to specify the actual location of the control files, whilst still in the GUI, even in the storage screen, there was no way to change the default location.

I believe I could have edited the scripts and run them manually, but didn't feel like going that far.

Regards.

Mark W. Farnham wrote:
> Obviously I was too cryptic. What I meant was that if you are going to put
> them all in one place anyway, you should only have one control file. Writing
> multiple times to multiple files the same unit of recoverability does not
> add recoverability.
>
> (I hope that location is redundant in some way.)
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Tony Sequeira
> Sent: Wednesday, December 16, 2009 7:18 AM
> To: 'Oracle List'
> Subject: Re: Oracle-Managed Files - your views
>
> Mark,
>
> Thanks, a bit late now, but useful for the future.
>
> I don't recall exactly where this is in the GUI. I spent a fair amount
> of time attempting to get this right.
>
> Any pointers?
>
> Regards.
>
> Mark W. Farnham wrote:
>
>> If you want them in the same directory, then you want to remove the letter
>> "s" from the end of controlfiles.
>>
>> (and if you're SAME or single location, OMF should have no downside.)
>>
>> -----Original Message-----
>> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
>> On Behalf Of S. Anthony Sequeira
>> Sent: Tuesday, December 15, 2009 3:57 PM
>> To: Oracle List
>> Subject: Re: Oracle-Managed Files - your views
>>
>> <snip>
>> I want the controlfiles, redologs and datafiles in the same directory.
>>
>> <snip>
>>
>>
>>
>>
>>
>>
>
>
>

-- 
S. Anthony Sequeira
++
America, how can I write a holy litany in your silly mood?
		-- Allen Ginsberg
++


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 16 2009 - 08:18:09 CST

Original text of this message