Re: Oracle-Managed Files - your views
- From: Tony Sequeira <tony@xxxxxxxxxxxxxxx>
- To: 'Oracle List' <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Dec 2009 14:18:09 +0000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
>> 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
++
Other related posts: