Re: Oracle licence question

"Tony Rogerson" <tonyrogerson_at_sqlserverfaq.com> wrote in message news:dtspt4$amv$1$8302bc10_at_news.demon.co.uk...
> > I have used log shipping and it is prone to problems. You have to
> > basically
> > freeze the database (source) and send it to the target. You have to be
> > careful applying logs, SS doesn't seem to be able to know what order to
> > apply logs in. (which seems rather silly, it should know the order)
> > Jim
>
> Freeze the source database? Where and on what planet did you get that
> impression from?
>
> You start with a backup of the source database, that is done online and
> takes into account current loading on the server so as to not affect
users,
> users can still use, update, insert etc... into the database. You then
> backup the log, copy to destination server (or servers) and restore the
> log - it can't get any more simple!
>
> Yes, you do need to apply logs in order at the destination but I don't see
a
> problem unless you are incompetant.
>
> If you install the free SDK you will get a log ship built into the
> maintanence plan in EM and its all done for you, and its through a GUI.
>

If you want to automate it to occur every 15 minutes there is a ton of stuff you have to do including freeze everything while you do it. Jim

> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
>
> "Jim Kennedy" <jim dot scuba dot kennedy at gee male dot com> wrote in
> message news:YYudnWEkfbmOQpzZnZ2dnUVZ_tCdnZ2d_at_comcast.com...
> >
> > "Tony Rogerson" <tonyrogerson_at_sqlserverfaq.com> wrote in message
> > news:dtrqsr$ocv$1$830fa79d_at_news.demon.co.uk...
> >> > eweek did a comparison of the two (albeit Enterprise Editions) just
> >> > recently
> >>
> >> I don't tend to read stuff like that, I can just as easily find
articles
> >> that put SQL Server in a good light rather than Oracle, awards its won
> >> etc... but they are all opinions of authors rather than people who
> > actually
> >> use the kit. It suprised me that some of the newer features - report
> >> builder, changes to the BI suite aren't even mentioned which says it
all
> >> about that particular article....
> >>
> >> > Database mirroring isn't shipping yet, right ?
> >> >
> >>
> >> Its shipping but not supported yet until SP1, but that doesn't stop you
> >> using other stuff like clustering (which is in workgroup and standard
> >> editions) or peer to peer replication, log shipping of your own....
> >
> > I have used log shipping and it is prone to problems. You have to
> > basically
> > freeze the database (source) and send it to the target. You have to be
> > careful applying logs, SS doesn't seem to be able to know what order to
> > apply logs in. (which seems rather silly, it should know the order)
> > Jim
> >>
> >> > The price for Oracle Standard Edition One on a dual core machine is
> > $4995
> >> > US or 2902 GBP.
> >>
> >> Is that for unlimited users though? Because its dual-core (2 CPU's) I
> > should
> >> add another 75% to that price?
> >>
> >> Check out http://www.theregister.co.uk/2005/07/15/oracle_core_pricing/
> > which
> >> sums it up nicely.
> >> And it gets even more complicated! A sharp Register reader forwards
this
> >> advisory from Oracle's finer print:
> >>
> >> "A multicore chip with 11 cores would require a 9 processor license (11
> >> multiplied by a factor of .75 equals 8.25 which is then rounded up to
the
> >> next whole number which is 9)."
> >>
> >> What I really wanted is something that lists features I get in Oracle
> >> Standard so I can compare that against SQL Server standard, which, is
the
> >> whole point of my reply to DA - I'd rather not he pass on yet another
> >> myth
> >> from his marketing list.
> >> --
> >> Tony Rogerson
> >> SQL Server MVP
> >> http://sqlserverfaq.com - free video tutorials
> >>
> >>
> >>
> >> "Mark Townsend" <markbtownsend_at_comcast.net> wrote in message
> >> news:4400F1A7.3090701_at_comcast.net...
> >> > Tony Rogerson wrote:
> >> >>>Sorry this is pure nonsense. I've yet to see a single example, in
> > recent
> >> >>>years, of Oracle being more expensive than SQL Server. In fact I
think
> >> >>>the exact opposite is true.
> >> >>>
> >> >>
> >> >>
> >> >> I've searched for a comparison of features between SQL Server 2005
> >> >> (Workgroup, Standard, Enterprise) and Oracle Standard and I don't
seem
> > to
> >> >> be able to find it - can you supply a URL for us to go visit.
> >> >
> >> > eweek did a comparison of the two (albeit Enterprise Editions) just
> >> > recently
> >> >
> >> > SQLServer - http://www.eweek.com/article2/0,1895,1894609,00.asp
> >> > Oracle - http://www.eweek.com/article2/0,1895,1618793,00.asp
> >> >
> >> > "However, by making management more complex, Microsoft has discarded
> >> > the
> >> > one significant advantage it had over Oracle Database 10g and IBM's
> >> > DB2-ease of administration. This makes DB2 and Oracle Database 10g
look
> >> > all the more attractive for their broader choice of development
> >> > frameworks, management interfaces, and server hardware and operating
> >> > systems."
> >> >
> >> > This doc identifies the differences between the Oracle Standard and
> >> > Enterprise Editions -
> >> >
> >

http://www.oracle.com/technology/products/database/oracle10g/pdf/twp_general_10gdb_product_family.pdf
> >> >
> >> >
> >> >>
> >> >> It would appear for £2,000 per physical processor (that means you
pay
> > for
> >> >> one even though its dual core) for the workgoup edition more than
> >> >> meets
> >> >> most company needs, you also have a free hot standby via database
> >> >> mirroring, log shipping or clustering (in workgroup edition), I
can't
> >> >> seem to work out the Oracle price but for a 2 proc machine (dual
core
> > for
> >> >> instance) it starts to get silly.
> >> >
> >> > Database mirroring isn't shipping yet, right ?
> >> >
> >> > The price for Oracle Standard Edition One on a dual core machine is
> > $4995
> >> > US or 2902 GBP.
> >> >
> >> >
> >> >>
> >> >> I doubt you'll reply with facts, more like a rant - but its worth a
> > try.
> >> >>
> >> >
> >>
> >>
> >
> >
>
>
Received on Sun Feb 26 2006 - 14:34:46 CST