Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Minimizing backup induced downtime

Re: Minimizing backup induced downtime

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 12 Jul 2007 19:45:36 -0700
Message-ID: <1184294735.490064@bubbleator.drizzle.com>


Alexander Skwar wrote:
> ยท DA Morgan <damorgan_at_psoug.org>:
>

>> Alexander Skwar wrote:
>>
>>> Let me explain how I currently do a backup.
>>>
>>> 1) Shut down application, which uses Oracle as a backend
>> Not necessary with RMAN

>
> Wrong. This is not a question of using RMAN. RMAN has nothing
> to do with the application. Further, it would also not necessary with
> EXP to shut down the application.
>
> But as I explained very clearly, this is not just about Oracle. I
> explained quite clearly, that Oracle even isn't the most important
> aspect. But you're of course free to ignore that. You know, I find it
> quite bad from you to snip so much from my post, and especially to snip
> those parts, where I wrote that certain things, like shutting down
> Oracle, wouldn't be necessary when RMAN would be used.
>
> Nonetheless - how would you make sure that the application is in
> a consistent state, when RMAN is used? As I wrote, a consistent state
> would mean, that the application would make sure that all the files
> are written to disk.
>
>> Absolutely paleolithic.

>
> Fine. How would you solve the task? I take it, that you don't
> have a solution? Or why did you not post one?
>
> To avoid misunderstandings, please let me try to rephrase the
> situation in more simple terms, so that it's even harder to misunderstand
> it:
>
> -> Take backup of some directory and database, making sure, that the
> directory and database are in sync. The contents of the directory are
> not controlled by some mechanism inside of Oracle.
>
> I would really love to hear a solution. As far as I can tell right
> now, your so-called "superior" solution with RMAN would only make
> backup and recovery worse. But that's certainly just because I don't
> have as much experience with this "superior" technology. And as that
> is so, I turned to this, as you called it "forum", to get some help
> from people who are much more experienced. It now kind of baffles me,
> that the most experienced people here don't have any hints on how to
> improve the backup scenario. Doesn't this strike you as odd either, Daniel?
>
> Anyway, as mentioned before, I'm always interested in learning
> something new and employing a better solution (BTW: I don't understand
> why you say that I show a disregard for my employer, when I'm looking
> for something which improves a situation at work, but I guess that's
> just me...). That said, I'm interested in using RMAN, if it improves
> the setup. Up to now, I don't see how it would improve the setup,
> but I'm willing to learn.
>
> I'm just curious, why is it, that "you Oracle guys" (I mean you
> and Sybrand) are always out to attack people (or at least me)
> without even offering help? Are you really *THAT* frustrated?
>
> Alexander Skwar

If your change management practices are so bad that you don't have a copy of your production application you should not involve yourself in anything more mentally taxing than pouring coffee.

Oh we offered help ... we got back attitude by the barrel.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jul 12 2007 - 21:45:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US