Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!newsfeeds.ihug.co.nz!lust.ihug.co.nz!ihug.co.nz!not-for-mail From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server Subject: Re: Effect of NOLOGGING tablespace on hot backup Date: Fri, 7 Jun 2002 05:41:19 +1000 Organization: ihug ( New Zealand ) Lines: 37 Message-ID: References: <59dd9910.0206061024.318d582c@posting.google.com> NNTP-Posting-Host: p53-tnt5.syd.ihug.com.au X-Trace: lust.ihug.co.nz 1023392497 28371 203.173.136.53 (6 Jun 2002 19:41:37 GMT) X-Complaints-To: abuse@ihug.co.nz NNTP-Posting-Date: Thu, 6 Jun 2002 19:41:37 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: easynews comp.databases.oracle.server:149782 X-Received-Date: Thu, 06 Jun 2002 12:39:01 MST (news.easynews.com) Actually, very little happens when you set NOLOGGING, so the answer is nearly number 3. But since they wouldn't have invented a useless keyword (Oh, I forgot -they did. Hello PCTINCREASE).... OK, so they wouldn't *intentionally* invent a useless keyword, so the answer is also nearly number 2. Plain fact of the matter is that ordinary DML *ALWAYS* logs, whatever the tablespace says. NOLOGGING is respected, however, by certain operations (such as create index, create table ... as select, and a lot of Partitioned DML). Whenever one of these operations is performed in a nologging table, it's time to backup, because they are unrecoverable by applying redo. Incidentally, it's what nologging is set to on the *table* that counts. What the tablespace is set to is irrelevant -that's only specifiable at the tablespace level so as to provide a default setting for tables created within the tablespace. If the tablespace says nologging, and you create a table 'logging', the logging attribute is the one that is set for that table. Regards HJR "Jenn" wrote in message news:59dd9910.0206061024.318d582c@posting.google.com... > If I have a tablespace that is marked NOLOGGING and I do a hot backup, > what do I get back when I recover? > > 1. Nothing > 2. Objects as of the time of the backup with no ability to roll > forward through the logs > 3. Everything > 4. something else? > > Thanks, Jenn