Re: server managed backup on XE

From: joel garry <joel-garry_at_home.com>
Date: Mon, 27 Apr 2009 13:32:12 -0700 (PDT)
Message-ID: <f3d9ae0f-05dd-4963-ab25-213da29d1d7d_at_p6g2000pre.googlegroups.com>

On Apr 26, 5:04 pm, johnbhur..._at_sbcglobal.net wrote:
> On Apr 26, 9:53 am, rnbjr..._at_gmail.com wrote:
>
> snip
>
> > > > Hello, I am just trying to learn the limitation as stated in the
> > > > document.please read that pdf. Nothing more and nothing less. Oracle
> > > > should be able to clarify what they documented in a straight forward
> > > > fashion. Am I asking for too much?
>
> > > I read that pdf ... I am not confused about the capabilities of XE as
> > > noted in that document.
>
> > > What exactly are you confused about?
>
> > simple, what is server based backup!
>
> Well if you look herehttp://www.oracle.com/database/product_editions.html
> Oracle makes it pretty clear at least for 11g XE they claim that XE
> does not provide ( or at least is not supported ) rman ... using the
> main search atwww.oracle.comand the words server managed backup.
>
> That's not terminology that people in the dba community use for rman.

Google being my friend, Oracle does indeed use it: http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/intro.htm (search for server-managed, the dash doesn't make a difference to google, but does to oracle/browsers).
(Also in the 11g docs, but I've had less success posting links to it, so screw it).

"Server-managed backup and recovery manages the backup process, such as scheduling of backups, as well as the recovery process, such as applying the correct backup file when recovery is needed."

It appears it's not saying it doesn't provide rman, just that you can't use XE as a repository or scheduler or something. I could see the scheduler - you would be a non-trivial site for multiple databases anyways, and for a site that only uses XE you'd perhaps want to use the local capabilities for batching, even if they are stupid. For a repository, I dunno, I still haven't gotten around to one anyways (though I should and it's on the todo list), I could see where even a few nodes might want a separate node running XE to do it. But then again, Oracle wouldn't support that simply because it's XE, so it's a non-starter.

>
> The 10g pdf that you point to do say that XE provides/supports
> incremental backup and recovery ( aka rman ).
>
> So at this point we are left with two different interpretations from
> oracle about XE and rman.
>
> My guess is that 11g XE will do an rman backup and recovery.  My guess
> is that oracle wants people to be nervous about whether that is
> supported or not and that they want to sell standard licenses to
> anyone wanting to backup an xe database.

Could be, but I don't think that's the intent (and I'm often the first to be paranoid about such things). I think I've reconciled it above.

>
> My guess is that you will be hard pressed to get much more from oracle
> about the status of XE and if they support rman for it or not.  Then
> again ... they don't really support XE at all do they ... at least
> formally.  I have heard rumours that you can patch XE with regular
> patchsets.
>
> So in other words ... this whole area is probably clear as mud ... as
> oracle probably intends it to be.

I dunno, you can add comments to the docs. I think when it comes down to it, they don't want to shoot themselves in the foot either by not charging for something they could, or losing goodwill with muddy marketing.

jg

--
_at_home.com is bogus.
“There's been no change to Qualcomm's business model.”
http://www3.signonsandiego.com/stories/2009/apr/27/1b27qcom23113-qualcomm-broadcom-settle-patent-laws/?uniontrib

Received on Mon Apr 27 2009 - 15:32:12 CDT