Re: Oracle recovery what is the best way

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 08 Jan 2003 09:25:54 -0800
Message-ID: <3E1C5F22.84883592@exesolutions.com>

Teresa wrote:

> Hi There
> I'm working on recovery of oracle in case of a disaster and I have the
> following question:
> I have a database in which most of the tables are with nologing, also
> I'm working on partition of one of the tables, can someone please
> tell me what is the best way of recover the database? for backup we do
> a ctas from one schema to other on daily basis and on weekends we do a
> degrag. This is oracle 8174 on sun. I have been told that the best
> way is just to have a clean export, do to the nologing at table level
> which they are unrecoverable Any help would be great
>
> Thanks
>
> Teresa

There is no single answer. The best solution depends on many factors of which you mention none ... start with how much data and what management's tolerance for the database being
unavilable. Seconds? Minutes? Hours? Days?

But one thing for sure ... you need to go to http://tahiti.oracle.com and look up NOLOGGING because it doesn't do what you think it does. Also check the google archives on these usenet groups.

Daniel Morgan Received on Wed Jan 08 2003 - 11:25:54 CST