Re: Minimizing backup induced downtime

· 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

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

-- 
Make a wish, it might come true.