RE: Oracle-Managed Files - your views
Date: Wed, 16 Dec 2009 08:43:59 -0500
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.)
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
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.
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
> I want the controlfiles, redologs and datafiles in the same directory.
-- S. Anthony Sequeira ++ If you keep your mind sufficiently open, people will throw a lot of rubbish into it. -- William Orton ++ -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 16 2009 - 07:43:59 CST