----- Original Message -----
From: "Tim Schaefer" <tim@spamethnot.com>
To: <informix-list@iiug.org>
Sent: Wednesday, February 11, 2004 9:15 AM
Subject: Re: Whatcha' wanta have?????


> Mark,
>
> I don't know Oracle well enough to talk competently about redo logs,
> but it's my limited understanding they are a bit different than the
> logical logs in Informix. As I understand it Oracle people live and
> die with creative log shipping that most Informix people would never
> even think of doing with logical logs. This is a good thing about
> Oracle, as I understand it, but the comparison is not quite apples
> to apples.

-- slightly OT, but of interest (at least to me)

I was just reading something about this today. They have an undo log -
which is analoguous to our physical log, and a redo log which is analoguous
to our logical log (did I miss a third one here?). Something cute that they
do is allow you to mirror the logs - set up groups and the engine will write
to all members of the group - all three or 15. We would do the same thing
by mirroring the dbspace or the underlying disk.

Also, evidently their desire for 'cooked' files vs raw disk stems from the
ease of backup. Oracle opts for standard utilities to perform cold backups
(database down during backup) - so just copy the file off. They do support
a hot backup - roughly the same way Informix does, but it looks fairly
complex to set up (and I get a queasy feeling reading the description of
events). They don't have anything to compare to the 'simplicity' of onbar
or ontape.

-- sorry, backups are on my mind right now - amanda is, like, totally cool.
(http://www.amanda.org/)

cheers
j.


sending to informix-list


sending to informix-list

> They don't have anything to compare to the 'simplicity' of onbar
> or ontape.
>

Hmmm - I think you may have been reading the wrong parts of the doc -
please make sure to check out the RMAN (Recovery Manager) documentation.
While you can use standard OS utilities to do a backup (both hot and
cold), it's pretty much a legacy approach, and RMAN is the builtin
backup/recovery capability that greatly simplifies life.

"Mark Townsend" <markbtownsend@comcast.net> wrote in message
news:402E9BC8.90609@comcast.net...
> > They don't have anything to compare to the 'simplicity' of onbar
> > or ontape.
> >
>
> Hmmm - I think you may have been reading the wrong parts of the doc -
> please make sure to check out the RMAN (Recovery Manager) documentation.
> While you can use standard OS utilities to do a backup (both hot and
> cold), it's pretty much a legacy approach, and RMAN is the builtin
> backup/recovery capability that greatly simplifies life.

One area that, in my experience, Oracle and SQL Server are easier to
administer is in their third-party back-up integration. The Informix
integration for Data Protector (Omniback as was) for example is a shambles.

Let's avoid turning this thread into an "us-vrs-them" thread.

Neil, could you convert this comment into a request for feature? I'd really
appreciate that. Sounds like you might have some issues that we'd want to
address.

Thanks
M.P.

"Neil Truby" <neil.truby@ardenta.com> wrote in message
news:c0m6pl$17bbe2$1@ID-162943.news.uni-berlin.de...
> "Mark Townsend" <markbtownsend@comcast.net> wrote in message
> news:402E9BC8.90609@comcast.net...
> > > They don't have anything to compare to the 'simplicity' of onbar
> > > or ontape.
> > >
> >
> > Hmmm - I think you may have been reading the wrong parts of the doc -
> > please make sure to check out the RMAN (Recovery Manager) documentation.
> > While you can use standard OS utilities to do a backup (both hot and
> > cold), it's pretty much a legacy approach, and RMAN is the builtin
> > backup/recovery capability that greatly simplifies life.
>
> One area that, in my experience, Oracle and SQL Server are easier to
> administer is in their third-party back-up integration. The Informix
> integration for Data Protector (Omniback as was) for example is a
shambles.
>
>

Madison Pruet wrote:

> Let's avoid turning this thread into an "us-vrs-them" thread.

I don't think anybody is doing that.

I will, of course, continue to comment on any mis-understanding of
Oracle capabilities in this group, as is my wont (or even
mis-representation, which I do not think is the case this time). It's a
little thing called free speech.

Mark Townsend wrote:

> Madison Pruet wrote:
>
>> Let's avoid turning this thread into an "us-vrs-them" thread.
>
> I don't think anybody is doing that.
>
> I will, of course, continue to comment on any mis-understanding of
> Oracle capabilities in this group, as is my wont (or even
> mis-representation, which I do not think is the case this time). It's a
> little thing called free speech.

Ya boo sucks to you! )

How's the yacht? Getting any salty wet action lately?

--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche