Re: exp and archive available.... recover table

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 11 Jul 2007 09:30:55 -0700
Message-ID: <1184171454.445340@bubbleator.drizzle.com>

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

>> It seems to me that what you consider a database is an entity that is
>> very small, has very few transactions, has very few users, uses no
>> technology or technique more recent than version 7.3.4, and has
>> management that considers availability of more than 10 hours a day a
>> luxury.

>
> Actually, about 18hrs is good enough right now.

It is nice that you can use Oracle to store your mother's cookie recipes without an SLA: Others are not so fortunate.

>> And all for the sake of laziness or stubbornness: I can't tell which.
>> There is a tool that is faster, easier, better in every respect, and
>> more importantly SAFER, and you want to argue with me about it. Amazing.

>
> Well, that tool, rman, doesn't even let me specify the names of the
> file that it should create

<SARCASM>
Wow. Not having control over file names: Tragic. I'll write my Senator and my Congressman and Uncle Larry and Mr. Townsend right this very minute. Outrageous.

What is be more important ... a real backup or file names. Time to hang up my keyboard and put myself out to pasture. </SARCASM>

>> I would think a desire to perfect your skills
>> and be a professional would have led you to make other choices.

>
> I am currently educating myself in the use of RMAN. Up to now, we shut
> down the database at night and made a cold copy of the datafiles. That
> was good enough up to now.
>
> You know, as I said, it's really a matter of size.

No it is really a matter of priding oneself on a job well done. You seem to revel in bad practice like someone is going to give you a badge for the number of days you survive doing things poorly.

So you're studying RMAN eh. How long does it take to study this:

rman target / catalog <username>/<password>@<tnsnames_entry>

RMAN> create catalog;
RMAN> register database;
RMAN> backup database plus archivelog;
RMAN> exit;

Minutes? Hours? Weeks? Months? Years?

Perhaps my age is showing but I find your attitude and your callous disregard for your employer outrageous. Last rationalization is yours.

-- 
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 Wed Jul 11 2007 - 11:30:55 CDT